Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Calling stored procedures to refresh the SSAS tabular model often results in errors

I have published 4-5 tabular 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.

1 Reply

  • can you verify the MySQL Server has enough resources to process all the requests on that pointintime?