cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vishayv
Frequent Visitor

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 --

 

http://community.powerbi.com/t5/Issues/frequent-issues-with-Power-BI-data-refresh-internal-service/i...

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 2
v-sihou-msft
Microsoft
Microsoft

@vishayv

 

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors