An internal error occurred on the report server. See the error log for more details.

jimmywong — Tue, 18 Sep 2018 03:13:18 GMT

Hi,

I have installed Power BI report server and I get a problem, once when I have changed the password of the data source, there was something wrong afterward in the catalog. I cannot goto the default Data source folder, when I enter the folder "Data Source", following error message prompted.

Then everytime when I open the SSRS report, there is error occurred.

Here below is what the logfile captured.

------------------------

2018-09-18 10:09:02.8435|INFO|26|Received request GET /api/v2.0/catalogitems%28e8f804e8-bc37-43fe-9e64-f07edf42a4c0%29/Model.Folder/catalogitems/| RequestID = s_66c18c29-646d-467c-9b80-e582b9056e86
2018-09-18 10:09:02.9216|ERROR|26|OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.InvalidOperationException: (processing): Adding more than one data source with null original name
at Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.DefaultRSTraceInternal.Fail(String componentName, String message)
at Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean condition, String message)
at Microsoft.ReportingServices.DataExtensions.DataSourceInfoCollection.Add(DataSourceInfo dataSource)
at Microsoft.ReportingServices.Library.DBInterface.InnerGetDataSources(Guid itemID, Boolean& itemIDisModelID)
at Microsoft.ReportingServices.Library.DBInterface.GetDataSources(Guid itemID)
at Microsoft.ReportingServices.Library.DataSourceCatalogItem.LoadStoredAndDerivedProperties()
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.<>c__DisplayClass8.<GetItemDescriptor>b__7()
at Microsoft.ReportingServices.Portal.Services.Extensions.RsServiceExtensions.ExecuteStorageAction(RSService rsService, Action action, ConnectionTransactionType transactionType, IsolationLevel isolationLevel)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Portal.Services.Extensions.RsServiceExtensions.ExecuteStorageAction(RSService rsService, Action action, ConnectionTransactionType transactionType, IsolationLevel isolationLevel)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.GetItemDescriptor(IPrincipal userPrincipal, RSService rsService, String path)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.GetCatalogItem(RSService rsService, IPrincipal userPrincipal, String path)
at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.<>c__DisplayClass14.<TraverseFolder>b__11(FavoriteableCatalogItemDescriptor i)
at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at Model.FolderRepository.LoadCatalogItems()
at Model.Folder.get_CatalogItems()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.SegmentHandlers.PropertySegmentHandler.Handle(Object source, ODataPathSegment segment)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.ReflectionODataController`1.Get(ODataPath oDataPath)
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- 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 System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.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 System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.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 System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.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 System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.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 System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext().| RequestID = s_66c18c29-646d-467c-9b80-e582b9056e86
2018-09-18 10:09:02.9216|INFO|32|Sending response. Response code PURE-INTL\biadmin 500, Elapsed time 0:00:00.0753839| RequestID = s_66c18c29-646d-467c-9b80-e582b9056e86

------------------------

PURE-INTL\biadmin is the domain and AD account. And I don't know what happened at all, kindly please help.

Regards,

Jimmy

Re: An internal error occurred on the report server. See the error log for more details.

Anonymous — Tue, 18 Sep 2018 11:08:03 GMT

1. Go to the Report Server Configuration Manager and change the password to the new of the service account

2. After tge restart, navigate to the properties of the report and go to the datatousrces and change the password. It is Possible that Step 1 solve your Problems ..

Re: An internal error occurred on the report server. See the error log for more details.

jimmywong — Wed, 19 Sep 2018 01:35:28 GMT

Hi,

Thanks for your reply, I have changed the password of the defined data source, not that of the service account.

Regards,

Jimmy

Re: An internal error occurred on the report server. See the error log for more details.

Anonymous — Wed, 19 Sep 2018 05:19:52 GMT

Okay, i mis understood.

But I think you should try the first step. It seems that the service account does not get the proper rights. Step 1 can solve this - hopefully.

Does any messages appear in the Windows Event Log or the outher SSRS Logs (Portal)?

Re: An internal error occurred on the report server. See the error log for more details.

jimmywong — Wed, 19 Sep 2018 06:12:53 GMT

Hi philipplenz,

I only cannot access the default "Data Sources" folder, not all. Is there a tool to check or clean the data inside the catalog? I can connect to the PBIS repository database, only I don't know how to fix it accordingly.

Re: An internal error occurred on the report server. See the error log for more details.

rpatkar — Wed, 19 Sep 2018 16:34:42 GMT

Looks like your database is in a corrupted state. Are you able to delete and re-create the "Data Sources" folder through UI? We highly recommend NOT modifying database contents directly.

Re: An internal error occurred on the report server. See the error log for more details.

jimmywong — Thu, 20 Sep 2018 02:00:01 GMT

Thanks for your reply, rpatkar.

You mean I can remove that folder even if there are data sources inside the folder, so I have to recreate all data sources again in another folder, right?

Re: An internal error occurred on the report server. See the error log for more details.

Anonymous — Mon, 24 Sep 2018 09:38:55 GMT

Before you do this, ensure that you have a backup of the RS databases

topic Re: An internal error occurred on the report server. See the error log for more details. in Report Server

An internal error occurred on the report server. See the error log for more details.

Re: An internal error occurred on the report server. See the error log for more details.

Re: An internal error occurred on the report server. See the error log for more details.

Re: An internal error occurred on the report server. See the error log for more details.

Re: An internal error occurred on the report server. See the error log for more details.

Re: An internal error occurred on the report server. See the error log for more details.

Re: An internal error occurred on the report server. See the error log for more details.

Re: An internal error occurred on the report server. See the error log for more details.