This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 39%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOS%3C/text%3E%3C/svg%3E)
When run query in SSMS in
{
"create": {
"database": {
"name": "AdventureworksDW2016",
"description": "test"
}
}
}
i have error:
Executing the query ...
An unexpected error occurred (file 'pcserialize.cpp', line 1535, function 'ASDatabase::Serialize').
Run complete
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 24%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
I just had the same error crop up when deploying to a production server after upgrading the solution from VS2019 to VS2022. Deployment to the dev database from VS threw a metadata error that was resolved by deleting the target cube and deploying again. The next attempt to deploy to the production server from VS failed with the error mentioned above. Even scripting the successful cube from dev as XMLA and running the script on the production server generates the same error.
Just tried restoring a backup from Dev to Prod, and that throws an encryption error...
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 20%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Was that resolved? We have the same issue with deployment after upgrading to 2022.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 82%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Ran into this issue soon after you guys and it is still persisting... I'm guessing windows updates must've been the cause because it stopped working 'out of nowhere', so to say. At the time i was one SQL CU behind, as the newest one just came out (16.0.4055.4, July 2023).
I updated to this latest CU but it did not help... Trying to create the database through query like in the question above, or through our .NET app (using Microsoft.AnalysisServices.Tabular) fails with the same error.
SQL2019 works fine and i've been using that instead.. Hopefully it gets fixed sooner rather than later
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 92%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Any help with this, we are having the same issue on a new SQL 2022 server. We are running SSAS on a separate server from the database server as well.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 12%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO1%3C/text%3E%3C/svg%3E)
any solution to this issue?
It's new installation 2022, not upgrade.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 89%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
SQL Server Analysis Services
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 11%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Running into the exact same issue . There is not much information online also for this specific issue.
I was able to get this resolved by reinstalling SQL 2022. The instance that was failing deployments had been upgraded from SQL 2019 to SQL 2022.
Removing the upgraded instances and installing from the SQL 2022 image worked to solve the issue. I also made sure that the base OS had been patched and is fully current.
This was an SSAS only instance, no SQL Server instances on the box.
It may not be related to the upgrade from 2019, but doing a fresh installation definitely solved the issue.
One other alternative to consider is publishing your cube to Power BI Premium, if you already have a premium instance.