Share via

SSAS 2019 Hangs while processing

Todd Chittenden 1 Reputation point
2020-08-19T18:23:20.647+00:00

This has happened four times now since March 2020: I have a SQL Agent job that handles the processing of several SSAS Tabular models. One of the processing steps will hang up. When it does, the SQL Agent Job cannot be STOPPED. Oh, you can try to stop it and it will give you the green check mark to say that it was stopped, but it's still hung up. Also, I cannot do anything to the database in SSMS. I can't Process, Un-Process, nothing.

The ONLY way to clear the log-jam, four times in a row now, is to re-boot the server. Even stopping and re-starting the Instance didn't work.

What is going on? Is this an issue or bug? How might I get Microsoft involved to help resolve this?

It's never a data issue because right after re-booting, we can process data and the cubes just fine again.

Frustrated.

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,248 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-08-20T03:14:20.383+00:00

    Hi,
    How long would it hang up and make no further progress?

    It is pretty hard to determine the root cause without detailed error messages. In your scenario, I would suggest you to use SQL Server Profiler to monitor your SSAS instance.

    For more information, please refer to Use SQL Server Profiler to Monitor Analysis Services.

    Or if you want Microsoft's support you could reach professional help at MS support

    Regards,
    Lukas

    0 comments