Installing CU17 on this SQL Server 2019 solved the problem!
An error occurred while parallel saving VertiPaq data objects for Schema 'db'.'
Hi all,
I am having strange issue with SSAS tabular direct query mode.
First I was not able to create relation between tables when I was using dedicated workspace server, but I managed to solve this one switching to integrated workspace for this particular project
Switching to integrated workspace made it possible to create relationships but now if I try to reprocess/make change to my model I get this very strange error:
"Failed to save modifications to the server. Error returned: 'The following error occurred while opening the file '\ftfilesrv\shares\home\zvujic\Documents\management_kpi_tabular\tabular_dq\bin\Data\db.0.db\R$fact v exchange rate (81)$9b42c4e3 de65 4369 8a24 5fe012b52589 (158)$(1125).tbl\1128.prt\0.R$fact v exchange rate (81)$9b42c4e3 de65 4369 8a24 5fe012b52589 (158).INDEX.0.idf'.
The following error occurred while opening the file '\ftfilesrv\shares\home\zvujic\Documents\management_kpi_tabular\tabular_dq\bin\Data\db.0.db\R$fact v exchange rate (81)$97e17a63 3ada 4f19 bd49 b4c436040ce5 (154)$(1113).tbl\1116.prt\0.R$fact v exchange rate (81)$97e17a63 3ada 4f19 bd49 b4c436040ce5 (154).INDEX.0.idf'.
An error occurred while parallel saving VertiPaq data objects for Schema 'db'.'
'."
I am using VS Community edition v 16.11.17 and Microsoft analysis services project v 2.9.18
3 answers
Sort by: Most helpful
-
-
Joyzhao-MSFT 15,621 Reputation points
2022-08-17T08:13:57.66+00:00 Hi @Zoran Vujic ,
I am glad to hear that you have resolved your issue. If you have any questions, please feel free to let me know.
Best Regards,
Joy -
Reuter, Stefan 0 Reputation points
2024-07-30T08:39:18.9333333+00:00 Hi,
I still get this error message although I have installed the latest cu for SQL Server 2022 (16.0.4135.4). Any idea how to fix it?
Thanks for your support