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
stefanp2
3 months agoRegular Visitor
i also run in this problem sometimes. I guess I understand your fix, but I am wondering if there is no official fix for that?