Getting deadlock error while deploying model to Azure analysis service
We were trying to redeploy the analysis service model that is when we started getting above error. Here is how my setup looks like
I wanted to make a field type change in one of the view used by analysis service. Hence I modified the existing model (change the field type) using visual studio. Then selected “Process All” (In SSDT, click Model > Process > Process All). When “Process All” is selected everything processed without any error.
When I tried to deploy this model in Azure analysis service, metadata deployment succeeded but view/table processing failed. Error indicated issue related to deadlock. Here is the actual error “Failed to save modifications to the server. Error returned: The lock operation ended unsuccessfully because of deadlock”
If you refer to analysis service deployment context diagram show above you will notice that there are function apps trying to refresh analysis service model every 5 min. When this happens analysis service reads the data from Azure SQL server again to update its in-memeory data. So resolve deployment issue i stopped both the function applications and attempted deployment again.
I hope you find this information useful!
