Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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

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's avatar
    Anonymous
    1 year ago

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

     

     

     

     

     

5 Replies

  • 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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    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?

     

      • Anonymous's avatar
        Anonymous
        Not applicable

        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

  • Anonymous's avatar
    Anonymous
    Not applicable

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