Power BI Report Server replace report error "Could not replace item. Something went wrong"

[Anonymous]

Hello,

We have on-premises Power BI Report Server. Replacing report throws following error:

the user who modified/created the report can replace it without errors.

Opened the report in Power BI desktop (September 2024), saved it and tried to replace, didn't work "Could not replace item".

How to troubleshoot this further? 

[Anonymous · Accepted solution]

UPDATE: There was a lock in the ReportServer database which blocked SELECT on dbo.Users and maybe more. Killed the blocking session.

[Anonymous]

1. the user who created the report can replace it, we who cannot belong in same domain groups. If one of us edit the report and try to replace, then the error occures.
2. yes, we who have this problem can see report, replace is not working, we can enter the "Manage" page and we are part of the "Security" group which has Publisher role
Content Manager role is BUILTIN\Administrators and we alla belong to the server administrators group

I have trouble finding the Report Server logs, where are they?

[Vanchy_Liao]

@Anonymous ,

you can follow the document

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-service-trace-log?view=sql-server-ver16#bkmk_view_log

[Anonymous]

Hello, logs are in C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles

There's timeout error in RSPortal_2025_01_10_08_52_08.log

2025-01-10 09:31:10.3469|INFO|48|Received request PUT /api/v2.0/catalogitems(1c8b9231-f57e-40ca-bb90-bfc71bc749a8)| RequestID = s_518e6fe1-aea2-458d-9b6d-099519147a97
2025-01-10 09:36:10.8132|ERROR|48|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: , Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.AggregateException: One or more errors occurred. ---> Microsoft.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__210_0(Task`1 result)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Dapper.SqlMapper.<QueryRowAsync>d__34`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.BIServer.HostingEnvironment.Storage.MeteredSqlConnection.<QueryFirstOrDefaultAsync>d__15`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.BIServer.HostingEnvironment.Storage.MeteredSqlConnection.<QueryFirstOrDefaultAsync>d__14`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.BIServer.Configuration.Catalog.CatalogAccessFactory.<QueryFirstOrDefaultAsync>d__5`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.ReportingServices.CatalogAccess.CatalogDataAccessor.<GetUserID>d__9.MoveNext()
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.SetDataModelDataSourcesTrusted(IPrincipal userPrincipal, Guid itemId, IEnumerable`1 dataSources, Boolean isOverwrite)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.<>c__DisplayClass| RequestID = s_518e6fe1-aea2-458d-9b6d-099519147a97
2025-01-10 09:36:10.8132|INFO|48|library|Report server dump occured. Exception: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.AggregateException: One or more errors occurred. ---> Microsoft.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out, Message: , Unhandled Exception: False| RequestID = s_518e6fe1-aea2-458d-9b6d-099519147a97
2025-01-10 09:36:10.8132|INFO|48|library|Skipped creating a dump file for the error InternalCatalogException, because a dump with the identical stack trace (with signature 2984734991) was already created.| RequestID = s_518e6fe1-aea2-458d-9b6d-099519147a97
2025-01-10 09:36:10.8152|ERROR|48|OData exception occurred: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.AggregateException: One or more errors occurred. ---> Microsoft.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out.| RequestID = s_518e6fe1-aea2-458d-9b6d-099519147a97
2025-01-10 09:36:10.8152|INFO|170|Sending response. Response code domain\myuseraccount 500, Elapsed time 0:05:00.4710831| RequestID = s_518e6fe1-aea2-458d-9b6d-099519147a97

[Vanchy_Liao]

@Anonymous ,

Depending on your description, i conclude the background as below:

1. the user who created/modified the report can replace it without errors

==> the same user

==> only the user who created the report can replace it.

2. the other users can see the report but can not replace it.

==> the other users can enter the "Manage Page"

==> the other users role can be content manager/publisher.

you can check out the report server log.

but i think there is a problem for the authorization of the other users to connect to the PBIRS machine.