Forum Discussion
3hungdc
1 year agoFrequent Visitor
Transaction (Process ID) was deadlocked on lock resources with another process
Hi Hello everyone, I'm encountering a deadlock issue in Power BI Report Server, and I'm not sure how to resolve it. When refreshing my dataset, I receive the following error: SessionID: 6b0...
- 1 year ago
I already found the problem.
When I checked System_health in extended events.
I see the details of deadlock as you said.But there, it's not problem about my code. It's about PowerBI Report Server bug.
After translate all these hard-to-understand-xml. I found out that have a problem with table CatalogItemExtendedContent . Made by PowerBI Report Server.
Finally, the deadlock is from sp: InitializeCatalogExtendedContentWrite
The code here:It deadlock because of that UPDATE.
Now I just need add WITH (ROWLOCK, UPDLOCK).
UPDATE [dbo].[CatalogItemExtendedContent] WITH (ROWLOCK, UPDLOCK) SET Content = 0x WHERE ItemID = @CatalogItemID AND ContentType = @ContentType;Voila . It no longer deadlock in my situation
carter_gray705
Advocate II
2 months agoDeadlock SQL Server side issue hai, Power BI ka direct problem nahi.
Simple fixes try karo:
- Tables par indexes add/verify karo (join/filter columns)
- Query ko simple karo ya SQL view bana lo
- Refresh ko off-peak time pe chalao
- Agar possible ho to enable karo READ_COMMITTED_SNAPSHOT
- Large tables ki statistics update karo
Parallel load off karna enough nahi hota—real issue DB locking hota hai.