Forum Discussion
Calling stored procedures to refresh the SSAS tabular model often results in errors
I have published 4-5 table models on the SSAS instance, and I refresh the data of the table model every day after the data warehouse is refreshed. However, they often report errors and the logs cannot identify any problems. Yesterday , last Sunday were successful, and today only one model is successful. What is the reason for this? The SSAS tabular model is a connected MySQL data source, and the error message is as follows:
001 Model:
The OLE DB provider 'MSOLAP' for linked server 'SSAS-001' returned the message 'OLE DB or ODBC error: [DataSource. Error] MySQL: Fatal error encoded during data read...'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 001 '. [SQLSTATE 42000] (Error 50000) This step failed.
003 Model:
The OLE DB provider 'MSOLAP' for linked server 'SSAS-003' returned the message 'The current operation has been canceled because another operation in the transaction failed.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 003 '. [SQLSTATE 42000] (Error 50000) This step failed.
003 Model:
The OLE DB provider 'MSOLAP' for linked server 'SSAS-003' returned the message 'The current operation has been canceled because another operation in the transaction failed.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 003 '. [SQLSTATE 42000] (Error 50000) This step failed.
004 Model:
The OLE DB provider 'MSOLAP' for linked server 'SSAS-004' returned the message 'OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 004 '. [SQLSTATE 42000] (Error 50000) This step failed.
Normally, it takes about 30 minutes to finish job refresh.
Looking forward to your reply, thank you.
- olafhelperBronze Contributor
The OLE DB provider 'MSOLAP' for linked server 'SSAS-001' returned the message杰克逊1300 I wonder about "linked server" in the error message.
Don't you access the MySQL directly, but the loop way of a MS SQL Server linked server?
- 杰克逊1300Copper ContributorHI, olaf,
thank you for your reply.
I tested that the script for the stored procedure can access the linked server. Yesterday, it was successfully accessed and refreshed. I am not sure what caused the error, possibly due to the network? Insufficient resources?