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

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.

Error when open Data source folder

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

Error when open SSRS report

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