Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors