Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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
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.
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |