topic Re: Error: One or more errors occurred. in Report Server

Error: One or more errors occurred.

niallhannon — Fri, 29 Dec 2017 11:53:50 GMT

I have the October 2017 version of Power BI Report server and in the RSManagement log I am seeing lots and lots of these errors:

Any ideas on how to diagnose?

I also have an issue saving power bi desktop reports to the server where it says "something went wrong" but if I refresh the page the report is uploaded. However its not possible to schedule a data refresh so it looks like something to do with an inability to store data source settings on the pwoer bi report.

So these could be related issues.

I have tried to "change" the encryption key but that didnt help.

Thanks

Re: Error: One or more errors occurred.

v-qiuyu-msft — Mon, 01 Jan 2018 06:48:29 GMT

Hi @niallhannon,

Please restart the Power BI report server service then check if message "something went wrong" display. To publish reports, you can try publish from Power BI desktop or use the Upload button in Power BI web portal directly. As there are several updates regarding Power BI report server October, please make sure you are running the latest version which is 14.0.600.438.

Regarding the issue that you are not able to schedule refresh, please check if you reports hit limitations firstly, then follow this article to configure schedule refresh.

Best Regards,
Qiuyun Yu

Re: Error: One or more errors occurred.

niallhannon — Tue, 02 Jan 2018 10:35:36 GMT

Yes I have tired restarting the service but it still happens and I am on the most recent version too.

How do I see details behind those error messages in the log? Those errors are not very descriptive so its diffciult to diagnose without knowing the detail of the error.

Re: Error: One or more errors occurred.

niallhannon — Tue, 02 Jan 2018 10:39:24 GMT

I also see this error in the RSPortal log:

RSPortal!reportserverwebapp!RSPortal.exe!5d5!01/02/2018-10:36:15:: i INFO: Received request POST /api/v2.0/catalogitems | RequestID = s_694261c5-338d-4f4d-933a-95f79983777e
RSPortal!reportserverwebapp!RSPortal.exe!5d5!01/02/2018-10:36:16:: e ERROR: OData exception occurred: Microsoft.BIServer.HostingEnvironment.Cryptography.Exceptions.CannotValidateEncryptedDataException: Exception of type 'Microsoft.BIServer.HostingEnvironment.Cryptography.Exceptions.CannotValidateEncryptedDataException' was thrown.
   at Microsoft.BIServer.HostingEnvironment.Cryptography.SymmetricKeyCrypto.EncryptInternal(Byte[] data)
   at Microsoft.BIServer.HostingEnvironment.Cryptography.Crypto.Encrypt(Byte[] unprotectedData, String tag)
   at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.SetDataModelDataSourcesTrusted(IPrincipal userPrincipal, Guid itemId, IEnumerable`1 dataSources, Boolean isOverwrite)
   at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.CreatePowerBIReport(RSService rsService, IPrincipal userPrincipal, String parentPath, Boolean overwrite, PowerBIReport item, Property[] properties)
   at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.CreateItem(IPrincipal userPrincipal, CatalogItem catalogItem, CatalogItem& createdItem)
   at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.CatalogItemsController.AddEntity(CatalogItem entity, CatalogItem& createdEntity)
   at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.Post(ODataPath oDataPath, T value)
   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.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_694261c5-338d-4f4d-933a-95f79983777e

Re: Error: One or more errors occurred.

BigRob — Fri, 16 Feb 2018 11:33:23 GMT

We are having the exact some issues, did you find a resloution?

Re: Error: One or more errors occurred.

rplescia_hsf — Fri, 16 Feb 2018 16:27:53 GMT

We have the exact same issue, updated to the latest CU, tried everything and still no joy

Re: Error: One or more errors occurred.

rplescia_hsf — Fri, 16 Feb 2018 16:30:06 GMT

We have the exact same issue, updated to the latest CU, tried everything and still no joy

Re: Error: One or more errors occurred.

niallhannon — Mon, 19 Feb 2018 07:33:05 GMT

Not yet, I have logged these as support requests to Microsoft and its gone to their product team for review.

One thing from it was they could replicate a number of issues I was having. They seem to occur when you upgrade an existing reportserver database rather than starting with a new database.

Did you upgrade an existing database as well?

Re: Error: One or more errors occurred.

rplescia_hsf — Mon, 19 Feb 2018 16:50:56 GMT

Yes, we upgraded from SSRS 2008 R2 to Power BI Report Server. All the legacy reports work but when we try to upload a new Power BI report we just get the error message.

Re: Error: One or more errors occurred.

niallhannon — Tue, 20 Feb 2018 07:58:34 GMT

Maybe report this to MS Support as well so that they know there are many customers with the same issue?