It's new installation 2022, not upgrade.
Analysis Services 2022 Tabular Model error
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
3 answers
Sort by: Most helpful
-
-
James Navy 0 Reputation points
2023-08-03T14:10:04.25+00:00 SQL Server Analysis Services
-
SQLMonger 0 Reputation points
2023-08-25T19:06:20.26+00:00 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.