question

pavanpatel-3329 avatar image
0 Votes"
pavanpatel-3329 asked SaurabhSharma-msft commented

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

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]




azure-analysis-services
xmla-timed-out.jpg (79.6 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @pavanpatel-3329,

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

0 Votes 0 ·

HI @SaurabhSharma-msft

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.

0 Votes 0 ·

Hi @pavanpatel-3329,
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

0 Votes 0 ·

0 Answers