Forum Discussion
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
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.
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
