Azure Analysis Services: Error Locks

Question

I have just implemented Christian Wade's "Automated Partition Mangement" solution in my company.
https://azure.microsoft.com...

But I got an error message when I run the process full of all tables.

I have this error message:

Exception message: Failed to save modifications to the server. Error returned: 'The operation was canceled because a deadlock condition was detected with another transaction. This usually occurs when two transactions need to lock the same objects, but do so in a different order. Please retry your operation.

Anyone know how to fix this problem?

Answer 1

Hello @H. Laguide and welcome to Microsoft Q&A.

The link you shared pointed to the Azure homepage. Were you trying to share a link to the "Automated Partition Management" you mentioned?

IA web search turned up 5257-whitepaper-automated-partition-management-for-analysis-services-tabular-models. Is this what you are referring to?

In that document, page 26 has a section "Locking and Blocking" which seems particularly relevant. Blocking is when multiple processes are asking for the same resource. Usually one would wait its turn, waiting for another process to finish and free up the resource. However, suppose we have the following case:

Process A is currently using resource X, and needs to get resource Y to complete its job.
Process B is currently using resource Y, and needs to get resource X to complete its job.
The result is a deadlock, neither can move forward unless the other process releases the resource in its possession. The only way to resolve this, is to kill one of the processes and try again after the other process completes its job.