Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Time out when Process database in SSAS

I have a model in SSAS, and it is import mode, Capability is 1500,   Recently I deploy a model into the SSAS,When I process every single table, I can refresh it successfully,  When I  processed th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry, Attach a wrong screenshot, the error message is:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding..

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

The current operation was cancelled because another operation in the transaction failed.

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Maybe you can set both parameters to 3600 seconds and try again.
Also, how big was the data you imported?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-lionel-msft 

    Hi Lionel,

    Thanks for your solution, I set the Time to 3600, but it is not work, 

    The Previous model is in the Power Bi desktop, it is 2.5 G, and recently we migrate it to SSAS server, and enlarge the time frame , May you please indicate me how to get the data volumn info in the SSAS?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi, could you resolve this one?