Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSAS Internal error: An Unexpected error occurred (file 'pfcre.cpp' function PFCREngine::SelectCartridge)

Has anyone seen this error before? If so, how did you fix it? I can't find anything on Google.

Here is what I have done:

  1. I tried doing a Google search but practically nothing came up.

  2. I checked all of my permissions everywhere, and from what I can tell, that is not the problem.

  3. Building and deploying does not generate errors.

  4. I only have errors when I try to process my cube.

Edit #1:

I have attached an image showing version information. I have never successfully processed a cube. I have been getting this from the very beginning of when I tried to process one.

version informations

Edit #2

Sorry for the delay, but I ran into some errors thanks to Windows latest update.

I am no longer receiving this error message after reinstalling everything, but this is what I have now:

WIDE World Importers DW database I downloaded somewhere from Microsoft I believe

I am trying to teach myself how to use SSAS for self-learning. I downloaded the database somewhere from Microsoft.

privileges

like image 422
Chicken Sandwich No Pickles Avatar asked Jul 06 '19 05:07

Chicken Sandwich No Pickles


1 Answers

I had to uninstall/reinstall Visual Studio as well as SQL Server due to an update that was causing errors.

After doing so, I was no longer able to reproduce the error message in part #1; however, part #2, Login failed for user NT Service \MSSQLServerOLAPService.;28000, was resolved by doing the following:

  1. Logging into SQL Server Management Studio

  2. Creating a new login for NT Service \MSSQLServerOLAPService.

  3. Assigning the db_datareader and db_datawriter role memberships.

After following these steps, I did not have any trouble processing my cube.

If I am able regenerate error #1 again, I will add more detail to my post, otherwise, I am problem free for the time being.

like image 146
Chicken Sandwich No Pickles Avatar answered Oct 15 '22 23:10

Chicken Sandwich No Pickles