Forum Discussion
scheduled refresh failes with : Transaction (Process ID 133) was deadlocked / Internal service
We have been seeing frequent data refresh failures( 4-5 times a week ) for a while now. some due to internal service errors and some due to database dead lock. I have started prev community threads with no solution so far --
Any suggestions on how to fix this ?
Error msgs ( Internal service error )
Failure Error msg1 : the last refresh attempt failed because of an internal service error.
Other data
Technical Information:
Activity Id: 02f891d3-1fbc-400e-ae56-067c67e47608
Request Id: 5c6b2b09-f221-488b-ab43-01c5fe509286
Cluster Name: DF-MSIT-SCUS-redirect.analysis.windows.net
Refresh Start Time: 12/29/2016 20:38:11Z
Refresh End Time: 12/29/2016 22:00:12Z
Failure Error msg2: Microsoft SQL: Transaction (Process ID 99) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Technical Information:
Activity Id: c768b34b-464b-4ff2-84d8-86a99eed8cef
Request Id: b6d7c837-8c54-4b05-8ac3-051c0993ceae
Cluster Name: DF-MSIT-SCUS-redirect.analysis.windows.net
Refresh Start Time: 01/03/2017 08:40:51Z
Refresh End Time: 01/03/2017 09:34:00Z
2 Replies
v-sihou-msftMicrosoft Employee
Have you tried to troubleshoot the deadlock issue? Please refer to the article suggested by v-qiuyu in your issue thread.
Regards,
thanks simon, I havent had a chance to look at those, will look at them today. However that is just 1/3 rd of the problem . We frequently see Internal service errors( above) or Refresh cancelled errors (below) causing refresh failures. how do we resolve those ?
Error Msg : The command has been canceled.
Technical Information:
Activity Id: da12355b-3a47-4310-9bd7-ba7c7dab27ae
Request Id: 3cf042e3-e7cb-4059-9aee-cfc976110191
Cluster Name: DF-MSIT-SCUS-redirect.analysis.windows.net
Refresh Start Time: 01/23/2017 20:47:05Z
Refresh End Time: 01/23/2017 21:36:07Z
