Forum Discussion

3hungdc's avatar
3hungdc
Frequent Visitor
1 year ago
Solved

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...
  • 3hungdc's avatar
    3hungdc
    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