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

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors