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

Zoran Vujic 6 Reputation points
2022-08-15T14:28:38.567+00:00

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

231097-image.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,061 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Zoran Vujic 6 Reputation points
    2022-08-15T15:20:20.617+00:00

    Installing CU17 on this SQL Server 2019 solved the problem!

    1 person found this answer helpful.
  2. Joyzhao-MSFT 15,381 Reputation points Microsoft Employee
    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