How to fix ---- Internal error: An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize').

Question

How to fix ---- Internal error: An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize').

Kaviyarasan J 10

i have XMLA script to create the Analysis service database.

i try to deploying the script with both primary and secondary server in the AAG environment.

i'm facing an issue while running the script - Internal error: An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize').

i struck more than a week with this issue.

Ross Buttery 10

I hit this issue on AWS and I finally resolved - 

 1. Locate msmdsrv.ini file (C:\Program Files\Microsoft SQL
    Server\MSAS16.MSSQLSERVER\OLAP\Config\)
 2. Create a copy as a backup
 3. Remove the line <Gen2ServerKey>1</Gen2ServerKey> and save
 4. Restart SSAS Service

Googling "Gen2ServerKey" doesn't show anything so not sure what this does although I've not hit any issues since removing it.

Kaviyarasan J 10 Reputation points

2023-11-07T12:24:53.7633333+00:00

Hai Ross Buttery ,

This was very useful, and now I can execute my XMLA script and create an Analysis service database.
SK 0 Reputation points

2023-12-07T20:58:39.7+00:00

I am running into the exact same issue .I tried this option , but , it did not fix it. Anyone else have tried a different option and were able to fix it ?

1 answer

Your answer

Ross Buttery 10 Reputation points

2023-09-18T14:00:42.48+00:00

I hit this issue on AWS and I finally resolved - 1. Locate msmdsrv.ini file (C:\Program Files\Microsoft SQL Server\MSAS16.MSSQLSERVER\OLAP\Config\) 2. Create a copy as a backup 3. Remove the line <Gen2ServerKey>1</Gen2ServerKey> and save 4. Restart SSAS Service Googling "Gen2ServerKey" doesn't show anything so not sure what this does although I've not hit any issues since removing it.
Kaviyarasan J 10 Reputation points

2023-11-07T12:24:53.7633333+00:00

Hai Ross Buttery ,

This was very useful, and now I can execute my XMLA script and create an Analysis service database.
SK 0 Reputation points

2023-12-07T20:58:39.7+00:00

I am running into the exact same issue .I tried this option , but , it did not fix it. Anyone else have tried a different option and were able to fix it ?

Answer 1

Limitless Technology 44,766

Hello

Thank you for your question and reaching out.

Open SQL Server Management Studio to log in

Establishing a fresh login for the NT Service MSSQLServerOLAPService.

determining the memberships for the db_datareader and db_datawriter roles.

Also try to change the account.

--If the reply is helpful, please Upvote and Accept as answer--

Share via

How to fix ---- Internal error: An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize').

1 answer

Your answer