Deadlock on report server database when deploying Power BI report

[Martin51]

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

[Martin51]

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

[Icey]

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]

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]

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.