Forum Discussion

杰克逊1300's avatar
杰克逊1300
Copper Contributor
Oct 16, 2023

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.

 

  • olafhelper's avatar
    olafhelper
    Bronze 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?

    • 杰克逊1300's avatar
      杰克逊1300
      Copper Contributor
      HI, 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?

Resources