January 9, 2018 at 1:39 pm
Hi folks,
Today someone made a simple change in the SQL portion of a data driven subscription. They applied their change, but now if anyone tries to edit this particular subscription, the front end throws an error. The logs show "Microsoft.ReportingServices.Portal.WebHost!processing!c!01/09/2018-14:54:14:: a ASSERT: Adding more than one data source with null original name", followed by a long and unintelligible-to-me stack dump. I am not able to delete the subscription. I tried restarting reporting services and the SQL server, no effect. Nobody changed any of the data sources. All we did was edit the SQL inside of the data driven subscription on the web portal and apply the change.
Anyone seen this before? Google search was not helpful...
/api/v1.0/reportserverinfo/model.DeliveryExtensions - Response 200 - 0:00:00.1636085
Microsoft.ReportingServices.Portal.WebHost!processing!c!01/09/2018-14:54:14:: a ASSERT: Adding more than one data source with null original name Call stack:
Microsoft.ReportingServices.Library.DBInterface.InnerGetDataSources(Guid itemID, Boolean& itemIDisModelID)
Microsoft.ReportingServices.Library.DBInterface.GetDataSourcesAndResolveModelLink(Guid itemID)
Microsoft.ReportingServices.Library.SubscriptionDB.GetSubscription(Guid id, IPathTranslator pathTranslator, Boolean isCacheRefreshPlanExpected)
Microsoft.ReportingServices.Library.SubscriptionManager.GetSubscription(Guid id, Boolean includeEncryptedSettings)
Microsoft.ReportingServices.Portal.Repositories.SubscriptionService.GetSubscription(IPrincipal userPrincipal, Guid key)
Microsoft.ReportingServices.Portal.ODataWebApi.V1.Controllers.SubscriptionsController.GetEntity(String key, String castName)
Microsoft.ReportingServices.Portal.ODataWebApi.V1.Controllers.Reflection.EntitySetReflectionODataController`1.GetRoot(ODataPath oDataPath, Int32& index)
Microsoft.ReportingServices.Portal.ODataWebApi.V1.Controllers.Reflection.ReflectionODataController`1.Get(ODataPath oDataPath)
DynamicClass.lambda_method(Closure , Object , Object[] )
System.Web.Http.Controllers.ReflectedHttpActionDescriptor+ActionExecutor+<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)
System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
System.Web.Http.Controllers.ApiControllerActionInvoker+<InvokeActionAsyncCore>d__0.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start(TStateMachine& stateMachine)
System.Web.Http.Controllers.ApiControllerActionInvoker.InvokeActionAsyncCore(HttpActionContext actionContext, CancellationToken cancellationToken)
System.Web.Http.Controllers.ApiControllerActionInvoker.InvokeActionAsync(HttpActionContext actionContext, CancellationToken cancellationToken)
System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>b__0(ActionInvoker innerInvoker)
System.Web.Http.Controllers.ActionFilterResult+<>c__DisplayClass10`1.<InvokeActionWithActionFilters>b__f()
System.Web.Http.Filters.ActionFilterAttribute+<CallOnActionExecutedAsync>d__5.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start(TStateMachine& stateMachine)
System.Web.Http.Filters.ActionFilterAttribute.CallOnActionExecutedAsync(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)
System.Web.Http.Filters.ActionFilterAttribute+<ExecuteActionFilterAsyncCore>d__0.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start(TStateMachine& stateMachine)
System.Web.Http.Filters.ActionFilterAttribute.ExecuteActionFilterAsyncCore(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)
System.Web.Http.Filters.ActionFilterAttribute.System.Web.Http.Filters.IActionFilter.ExecuteActionFilterAsync(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)
System.Web.Http.Controllers.ActionFilterResult+<ExecuteAsync>d__2.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start(TStateMachine& stateMachine)
System.Web.Http.Controllers.ActionFilterResult.ExecuteAsync(CancellationToken cancellationToken)
System.Web.Http.Controllers.ExceptionFilterResult+<ExecuteAsync>d__0.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start(TStateMachine& stateMachine)
System.Web.Http.Controllers.ExceptionFilterResult.ExecuteAsync(CancellationToken cancellationToken)
System.Web.Http.ApiController.ExecuteAsync(HttpControllerContext controllerContext, CancellationToken cancellationToken)
System.Web.Http.Dispatcher.HttpControllerDispatcher+<SendAsync>d__1.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start(TStateMachine& stateMachine)
System.Web.Http.Dispatcher.HttpControllerDispatcher.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)
System.Net.Http.HttpMessageInvoker.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)
System.Web.Http.Dispatcher.HttpRoutingDispatcher.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)
System.Net.Http.DelegatingHandler.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)
System.Web.Http.HttpServer+<SendAsync>d__0.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start(TStateMachine& stateMachine)
System.Web.Http.HttpServer.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)
System.Net.Http.HttpMessageInvoker.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)
System.Web.Http.Owin.HttpMessageHandlerAdapter+<InvokeCore>d__0.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start(TStateMachine& stateMachine)
System.Web.Http.Owin.HttpMessageHandlerAdapter.InvokeCore(IOwinContext context, IOwinRequest owinRequest, IOwinResponse owinResponse)
System.Web.Http.Owin.HttpMessageHandlerAdapter+<InvokeCore>d__0.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start(TStateMachine& stateMachine)
System.Web.Http.Owin.HttpMessageHandlerAdapter.InvokeCore(IOwinContext context, IOwinRequest owinRequest, IOwinResponse owinResponse)
Microsoft.ReportingServices.Portal.WebHost.Owin.CsrfTokenValidationMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.DatabaseAvailableMiddleware.Invoke(IOwinContext context)
Microsoft.Owin.StaticFiles.StaticFileMiddleware.Invoke(IDictionary`2 environment)
Microsoft.Owin.StaticFiles.DefaultFilesMiddleware.Invoke(IDictionary`2 environment)
Microsoft.ReportingServices.Portal.WebHost.Owin.UrlRewriterMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.LocalRequestMiddleware+<Invoke>d__0.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start(TStateMachine& stateMachine)
Microsoft.ReportingServices.Portal.WebHost.Owin.LocalRequestMiddleware.Invoke(IOwinContext portalContext)
Microsoft.ReportingServices.Portal.WebHost.Owin.PopulateHeadersMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.UrlRedirecterMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.UrlRedirecterMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.UrlRedirecterMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.UrlRedirecterMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.XFrameOptionsMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.LanguageMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.CsrfTokenCreationMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.RequestThrottlingMiddleware+<InvokeNext>d__6.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start(TStateMachine& stateMachine)
Microsoft.ReportingServices.Portal.WebHost.Owin.RequestThrottlingMiddleware.InvokeNext(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.RequestThrottlingMiddleware+<InvokeInternal>d__0.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start(TStateMachine& stateMachine)
Microsoft.ReportingServices.Portal.WebHost.Owin.RequestThrottlingMiddleware.InvokeInternal(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.RequestThrottlingMiddleware.Invoke(IOwinContext context)
Microsoft.ReportingServices.Portal.WebHost.Owin.RequestLoggingMiddleware+<Invoke>d__0.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start(TStateMachine& stateMachine)
Microsoft.ReportingServices.Portal.WebHost.Owin.RequestLoggingMiddleware.Invoke(IOwinContext context)
Microsoft.Owin.Hosting.Utilities.Encapsulate.Invoke(IDictionary`2 environment)
Microsoft.Owin.Host.HttpListener.OwinHttpListener+<ProcessRequestAsync>d__5.MoveNext()
System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start(TStateMachine& stateMachine)
Microsoft.Owin.Host.HttpListener.OwinHttpListener.ProcessRequestAsync(HttpListenerContext context)
Microsoft.Owin.Host.HttpListener.OwinHttpListener+<ProcessRequestsAsync>d__0.MoveNext()
System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
System.Runtime.CompilerServices.AsyncMethodBuilderCore+MoveNextRunner.Run()
System.Threading.Tasks.AwaitTaskContinuation.RunOrScheduleAction(Action action, Boolean allowInlining, Task& currentTask)
System.Threading.Tasks.Task.FinishContinuations()
System.Threading.Tasks.Task`1.TrySetResult(TResult result)
System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
System.Threading.Tasks.TaskFactory`1+<>c__DisplayClass35_0.<FromAsyncImpl>b__0(IAsyncResult iar)
System.Net.LazyAsyncResult.Complete(IntPtr userToken)
System.Net.LazyAsyncResult.ProtectedInvokeCallback(Object result, IntPtr userToken)
System.Net.ListenerAsyncResult.IOCompleted(ListenerAsyncResult asyncResult, UInt32 errorCode, UInt32 numBytes)
System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)
January 9, 2018 at 2:37 pm
What is the Reporting services log right before the error? You would want to look at a few of the lines before the error, especially the one right before the error.
And when you say:
Nobody changed any of the data sources. All we did was edit the SQL inside of the data driven subscription on the web portal and apply the change.
How did you make this change? Do you mean by editing the SQL in the rdl file itself?
Sue
January 9, 2018 at 3:13 pm
Thanks Sue.
The change was made via the web front end. Someone made a change to the SQL script in the data driven subscription.
The stack dump above is from the Portal.WebHost log. Nothing preceding it is related. Here's what's in the reporting services log from around the same time. We don't use PowerBI on our report server so I think that is a red herring.
library!ReportServer_0-1!3018!01/09/2018-14:54:08:: i INFO: Call to GetReportParametersAction(/<reportPath>). User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetItemTypeAction(/<reportPath>). User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetReportParametersAction(/<reportPath>). User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetItemTypeAction(/<reportPath>). User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetReportParametersAction(/<reportPath>). User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetItemTypeAction(/<reportPath>). User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetReportParametersAction(/<reportPath>). User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: , Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: The requested functionality is not currently enabled.;
extensionfactory!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Skipped instantiating Report Server PowerBI report server extension. Extension was not enabled.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: , Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: This operation is not supported on a report server that runs in native mode.;
library!ReportServer_0-1!e48!01/09/2018-14:54:14:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: , Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: The requested functionality is not currently enabled.;
extensionfactory!ReportServer_0-1!e48!01/09/2018-14:54:14:: i INFO: Skipped instantiating Report Server PowerBI report server extension. Extension was not enabled.
library!ReportServer_0-1!e48!01/09/2018-14:54:14:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: , Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: The requested functionality is not currently enabled.;
extensionfactory!ReportServer_0-1!e48!01/09/2018-14:54:14:: i INFO: Skipped instantiating Report Server PowerBI report server extension. Extension was not enabled.
library!ReportServer_0-1!3464!01/09/2018-14:54:48:: i INFO: Call to GetItemTypeAction(/<PathToSomeOtherReport>). User: xxx.
library!ReportServer_0-1!3464!01/09/2018-14:54:48:: e ERROR: Error rending control: System.Web.HttpException (0x80004005): Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.
See http://go.microsoft.com/fwlink/?LinkID=314055 for more information. ---> System.Web.UI.ViewStateException: Invalid viewstate.
Client IP: xxx.xxx.xxx.xxx
Port: 50050
Referer: https://reports.exemplarhs.com/ReportServer/Pages/ReportViewer.aspx?%2FSan%20Bernardino%2FProductivity%20Pilot&rc:showbackbutton=true
Path: /ReportServer/Pages/ReportViewer.aspx
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
ViewState: /<some sort of security key or token>
at System.Web.UI.ViewStateException.ThrowError(Exception inner, String persistedState, String errorPageMessage, Boolean macValidationError)
at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString, Purpose purpose)
at System.Web.UI.Util.DeserializeWithAssert(IStateFormatter2 formatter, String serializedState, Purpose purpose)
at System.Web.UI.HiddenFieldPageStatePersister.Load()
at System.Web.UI.Page.LoadPageStateFromPersistenceMedium()
at System.Web.UI.Page.LoadAllState()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
library!ReportServer_0-1!3464!01/09/2018-14:54:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Could not validate Viewstate., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.Web.UI.ViewStateException: Invalid viewstate.
Client IP: 172.16.27.113
Port: 50050
Referer: https://reports.exemplarhs.com/ReportServer/Pages/ReportViewer.aspx?%2FSan%20Bernardino%2FProductivity%20Pilot&rc:showbackbutton=true
Path: /ReportServer/Pages/ReportViewer.aspx
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
ViewState: /
<some sort of security key or token>
--- End of inner exception stack trace ---;
webserver!ReportServer_0-1!3464!01/09/2018-14:54:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: , Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: The report server encountered an unhandled exception in HttpApplication. ---> System.ArgumentNullException: Value cannot be null.
Parameter name: exception
at System.Web.UI.AsyncPostBackErrorEventArgs..ctor(Exception exception)
at System.Web.UI.PageRequestManager.OnPageError(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.TemplateControl.OnError(EventArgs e)
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--- End of inner exception stack trace ---;
January 9, 2018 at 4:20 pm
We implemented a workaround. can i delete this "malfunctioning" subscription from the subscriptions table?
January 9, 2018 at 4:42 pm
agerard 65681 - Tuesday, January 9, 2018 4:20 PMWe implemented a workaround. can i delete this "malfunctioning" subscription from the subscriptions table?
I'd try one of the supported methods first.
If you use the web service and SOAP API, you can call the DeleteSubscription method in an app or just write an rss file to use with rs.exe.
Using Powershell would be faster - download and import the ReportingServicesTools module and then just use the Remove-RsSubscription cmdlet.
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply