An error occurred while parallel saving VertiPaq data objects for Schema 'db'.'

Question

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

Answer 1

Installing CU17 on this SQL Server 2019 solved the problem!

Answer 2

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

Answer 3

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