SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Data Driven Subscription Inaccessible: Adding more than one data source with null original name


Data Driven Subscription Inaccessible: Adding more than one data source with null original name

Author
Message
agerard 65681
agerard 65681
SSChasing Mays
SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)

Group: General Forum Members
Points: 626 Visits: 122
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)
Sue_H
Sue_H
SSC Guru
SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)

Group: General Forum Members
Points: 72693 Visits: 14957


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



agerard 65681
agerard 65681
SSChasing Mays
SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)

Group: General Forum Members
Points: 626 Visits: 122
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>Wink. User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetItemTypeAction(/<reportPath>Wink. User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetReportParametersAction(/<reportPath>Wink. User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetItemTypeAction(/<reportPath>Wink. User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetReportParametersAction(/<reportPath>Wink. User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetItemTypeAction(/<reportPath>Wink. User: xxx.
library!ReportServer_0-1!e48!01/09/2018-14:54:08:: i INFO: Call to GetReportParametersAction(/<reportPath>Wink. 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>Wink. 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 ---;
agerard 65681
agerard 65681
SSChasing Mays
SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)

Group: General Forum Members
Points: 626 Visits: 122
We implemented a workaround. can i delete this "malfunctioning" subscription from the subscriptions table?
Sue_H
Sue_H
SSC Guru
SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)SSC Guru (72K reputation)

Group: General Forum Members
Points: 72693 Visits: 14957
agerard 65681 - Tuesday, January 9, 2018 4:20 PM
We 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



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search