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
Martin51
Frequent Visitor

Deadlock on report server database when deploying Power BI report

Good afternoon,

 

We are getting some random failures while deploying Power BI .pbix reports to our report server.

 

Error: An error has occurred [Microsoft.PowerShell.Commands.WriteErrorException: System.Exception: Failed to create catalog item: The remote server returned an error: (500) Internal Server Error. ---> System.Net.WebException: The remote server returned an error: (500) Internal Server Error.

 

After investigation we can see that this type of errors are caused by deadlocks on the report server database.

 

Object name: ReportServer.dbo.DataModelDataSource

Index name: PK_DataModelDataSource

 

Object name: ReportServer.dbo.DataModelDataSource

Index name: IX_ItemId_ModelConnectionName

 

We deploy the reports via a release pipeline and make use of the ReportingServicesTools PowerShell module.

 

Our report server version is: Version 1.11.7815.26414 (May 2021)

Best regards,

Martin B

4 REPLIES 4
Martin51
Frequent Visitor

Hi @Icey , yes we will create a ticket and let you know.

Icey
Community Support
Community Support

Hi @Martin51 ,

 

Thank you in advance for sharing! 

 

In addition, for deadlock in SQL Server, hope these documents could help you:

What are SQL Server deadlocks and how to monitor them (sqlshack.com);

How to resolve deadlocks in SQL Server (sqlshack.com);

Capturing Deadlocks in SQL Server - Brent Ozar Unlimited®;

Analyze Deadlocks - SQL Server Profiler | Microsoft Docs.

 

 

Best Regards,

Icey

Icey
Community Support
Community Support

Hi @Martin51 ,

 

Do you create a support ticket as what @d_gosbell mentioned?

 

If you do create one, could you share us the solution or workaround when the issue is solved?

 

 

Best Regards,

Icey

d_gosbell
Super User
Super User

Your best approach here would be to raise an official support ticket with Microsoft. The powershell module uses the supported REST api under the covers so I do not believe that would be the issue. But this will possibly require a hotfix or changes to the database and both of those things would require the assistance of a support engineer. 

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.