An error has occurred while trying to locate a long running XMLA request. The request might have been interrupted by service upgrade or server restart

pavan patel 1

We are facing issue in while processing AAS cube.

We have S0 pricing tier for Analysis services. And we have not found any issue from Logs.

The same cube is processing from the Visual studio but not able to process from SSMS.

If anyone have any solution then please help me on this.

Below is the error which we are getting in SSMS.

![145787-xmla-timed-out.jpg ]1

Saurabh Sharma 23,751 Reputation points Microsoft Employee

2021-11-03T06:05:49.88+00:00

Hi @pavan patel ,

Thanks for using Microsoft Q&A !!
Are you using SQL Authentication from SSMS ? If you, can you please trying using the SQL authentication.
Also, try to increase the timeout in the data source connection property if that helps.

Thanks
Saurabh
pavan patel 1 Reputation point

2021-11-03T07:51:00.847+00:00

HI @Saurabh Sharma

Thanks for your Response.

Yes i am using SQL authentication for SSMS.

I have tried to increase timeout settings from SSMS. Can you please confrim that are you asking that only to increase in dara source.

i am using SSMS 18.10 Version. Also we have increase Pricing tier from S0 to S2 but still getting the error.

If you can provide more solution then it will be helpful for us.
Saurabh Sharma 23,751 Reputation points Microsoft Employee

2021-11-10T01:06:51.647+00:00

Hi @pavan patel ,
Yes.
I suggest you to please open an Azure Support ticket so that an engineer could look into your environment. In case you have any limitations please let me know and I will help providing you a one time free support ticket.

Thanks
Saurabh