Sub-reports in RS2008 parameters not passed when data driven subscription
im using sql2208 SP1, no cumalitive updates. I have a report that calls 4 subreports that are graphs, The report runs fine interactivly, it also runs fine as am email subscription, but it fails when its a data driven subscription! Each of the Graphs trigger an error into the RsLog file but the params must be populated correctly in the sub report as the email subscription works fine when the params are populated for the Main Report! Error Log portion posted below, anyone know a fix for whats happening here ? its clear the params are not getting to the sub report but its not clear which ones ... schedule!WindowsService_65!a8c!08/19/2011-22:32:07:: Creating Time based subscription notification for subscription: c0a7d9e5-3b48-4e47-a2f7-b1b80221e182 library!WindowsService_65!a8c!08/19/2011-22:32:07:: i INFO: Schedule 4c354437-9923-4cad-8d5c-ec6e133780cd execution completed at 08/19/2011 22:32:07. library!ReportServer_0-125!a84!08/19/2011-22:32:08:: Call to GetPermissionsAction(/Deployment/Subcontractor and Advisor Subscription). library!ReportServer_0-125!a84!08/19/2011-22:32:08:: Call to GetSystemPropertiesAction(). library!ReportServer_0-125!a84!08/19/2011-22:32:08:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!ReportServer_0-125!a84!08/19/2011-22:32:08:: Call to GetSystemPermissionsAction(). library!ReportServer_0-125!a84!08/19/2011-22:32:08:: Call to ListSubscriptionsAction(/Deployment/Subcontractor and Advisor Subscription, null). library!ReportServer_0-125!a84!08/19/2011-22:32:08:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!ReportServer_0-125!a84!08/19/2011-22:32:08:: Call to GetSystemPropertiesAction(). library!WindowsService_65!ab4!08/19/2011-22:32:08:: i INFO: Initializing EnableIntegratedSecurity to 'True' as specified in Server system properties. library!WindowsService_65!ab4!08/19/2011-22:32:08:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties. library!ReportServer_0-125!139c!08/19/2011-22:32:11:: Call to GetPermissionsAction(/Deployment/Subcontractor and Advisor Subscription). library!ReportServer_0-125!139c!08/19/2011-22:32:11:: Call to GetSystemPropertiesAction(). library!ReportServer_0-125!139c!08/19/2011-22:32:11:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!WindowsService_65!384!08/19/2011-22:32:11:: i INFO: RenderForNewSession('/Deployment/Subcontractor and Advisor Subscription') library!ReportServer_0-125!139c!08/19/2011-22:32:11:: Call to GetSystemPermissionsAction(). library!ReportServer_0-125!139c!08/19/2011-22:32:11:: Call to ListSubscriptionsAction(/Deployment/Subcontractor and Advisor Subscription, null). library!ReportServer_0-125!139c!08/19/2011-22:32:12:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!ReportServer_0-125!139c!08/19/2011-22:32:12:: Call to GetSystemPropertiesAction(). library!WindowsService_65!a8c!08/19/2011-22:32:13:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties. library!WindowsService_65!ab4!08/19/2011-22:32:13:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties. library!WindowsService_65!a8c!08/19/2011-22:32:13:: i INFO: Initializing ChunkSegmentSize to default value of '32320' Bytes because it was not specified in Server system properties. library!WindowsService_65!ab4!08/19/2011-22:32:13:: i INFO: Initializing ChunkSegmentSize to default value of '32320' Bytes because it was not specified in Server system properties. processing!WindowsService_65!10b0!08/19/2011-22:32:14:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified. processing!WindowsService_65!10b0!08/19/2011-22:32:15:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified. processing!WindowsService_65!10b0!08/19/2011-22:32:15:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified. processing!WindowsService_65!10b0!08/19/2011-22:32:15:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified. processing!WindowsService_65!10b0!08/19/2011-22:32:16:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified. processing!WindowsService_65!10b0!08/19/2011-22:32:16:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more parameters required to run the report have not been specified. library!WindowsService_65!384!08/19/2011-22:32:16:: i INFO: Initializing ResponseBufferSizeKb to default value of '64' KB because it was not specified in Server system properties. library!WindowsService_65!384!08/19/2011-22:32:16:: Using folder C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files. reportrendering!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport4', located at: /Deployment/SubContractorAndAdvisorStartsTabular., ; Info: Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport4', located at: /Deployment/SubContractorAndAdvisorStartsTabular. processing!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: An error has occurred while processing a sub-report. Details: One or more parameters were not specified for the subreport, 'Subreport4', located at: /Deployment/SubContractorAndAdvisorStartsTabular. Stack trace: at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.CheckRetrievalStatus(Status status) at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport() reportrendering!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport5', located at: /Deployment/SubContractorandAdvisorStartsChart1., ; Info: Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport5', located at: /Deployment/SubContractorandAdvisorStartsChart1. processing!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: An error has occurred while processing a sub-report. Details: One or more parameters were not specified for the subreport, 'Subreport5', located at: /Deployment/SubContractorandAdvisorStartsChart1. Stack trace: at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.CheckRetrievalStatus(Status status) at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport() reportrendering!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport3', located at: /Deployment/SubContractorandAdvisorStartsChart2., ; Info: Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport3', located at: /Deployment/SubContractorandAdvisorStartsChart2. processing!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: An error has occurred while processing a sub-report. Details: One or more parameters were not specified for the subreport, 'Subreport3', located at: /Deployment/SubContractorandAdvisorStartsChart2. Stack trace: at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.CheckRetrievalStatus(Status status) at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport() reportrendering!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport6', located at: /Deployment/Subcontractor and Advisor Outcomes Table., ; Info: Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport6', located at: /Deployment/Subcontractor and Advisor Outcomes Table. processing!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: An error has occurred while processing a sub-report. Details: One or more parameters were not specified for the subreport, 'Subreport6', located at: /Deployment/Subcontractor and Advisor Outcomes Table. Stack trace: at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.CheckRetrievalStatus(Status status) at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport() reportrendering!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport2', located at: /Deployment/Subcontractor and Advisor Outcomes Chart., ; Info: Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport2', located at: /Deployment/Subcontractor and Advisor Outcomes Chart. processing!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: An error has occurred while processing a sub-report. Details: One or more parameters were not specified for the subreport, 'Subreport2', located at: /Deployment/Subcontractor and Advisor Outcomes Chart. Stack trace: at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.CheckRetrievalStatus(Status status) at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport() reportrendering!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport1', located at: /Deployment/Subcontractor and Advisor Sustained Pie., ; Info: Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: One or more parameters were not specified for the subreport, 'Subreport1', located at: /Deployment/Subcontractor and Advisor Sustained Pie. processing!WindowsService_65!384!08/19/2011-22:32:18:: e ERROR: An error has occurred while processing a sub-report. Details: One or more parameters were not specified for the subreport, 'Subreport1', located at: /Deployment/Subcontractor and Advisor Sustained Pie. Stack trace: at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.CheckRetrievalStatus(Status status) at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport() library!ReportServer_0-125!139c!08/19/2011-22:32:18:: Call to GetPermissionsAction(/Deployment/Subcontractor and Advisor Subscription). library!ReportServer_0-125!139c!08/19/2011-22:32:19:: Call to GetSystemPropertiesAction(). library!ReportServer_0-125!139c!08/19/2011-22:32:19:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!ReportServer_0-125!139c!08/19/2011-22:32:19:: Call to GetSystemPermissionsAction(). library!ReportServer_0-125!139c!08/19/2011-22:32:19:: Call to ListSubscriptionsAction(/Deployment/Subcontractor and Advisor Subscription, null). library!ReportServer_0-125!139c!08/19/2011-22:32:19:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!ReportServer_0-125!139c!08/19/2011-22:32:19:: Call to GetSystemPropertiesAction(). library!WindowsService_65!384!08/19/2011-22:32:20:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties. library!WindowsService_65!384!08/19/2011-22:32:20:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. library!WindowsService_65!384!08/19/2011-22:32:20:: i INFO: Initializing StoredParametersThreshold to '1500' characters as specified in Server system properties. library!ReportServer_0-125!11c4!08/19/2011-22:32:25:: Call to GetPermissionsAction(/Deployment/Subcontractor and Advisor Subscription). library!ReportServer_0-125!11c4!08/19/2011-22:32:25:: Call to GetSystemPropertiesAction(). library!ReportServer_0-125!11c4!08/19/2011-22:32:25:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!ReportServer_0-125!11c4!08/19/2011-22:32:25:: Call to GetSystemPermissionsAction(). library!ReportServer_0-125!11c4!08/19/2011-22:32:25:: Call to ListSubscriptionsAction(/Deployment/Subcontractor and Advisor Subscription, null). library!ReportServer_0-125!11c4!08/19/2011-22:32:26:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!ReportServer_0-125!11c4!08/19/2011-22:32:26:: Call to GetSystemPropertiesAction(). library!ReportServer_0-125!11c4!08/19/2011-22:32:29:: Call to GetPermissionsAction(/Deployment/Subcontractor and Advisor Subscription). library!ReportServer_0-125!11c4!08/19/2011-22:32:29:: Call to GetSystemPropertiesAction(). library!ReportServer_0-125!11c4!08/19/2011-22:32:29:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!ReportServer_0-125!11c4!08/19/2011-22:32:29:: Call to GetSystemPermissionsAction(). library!ReportServer_0-125!11c4!08/19/2011-22:32:29:: Call to ListSubscriptionsAction(/Deployment/Subcontractor and Advisor Subscription, null). library!ReportServer_0-125!11c4!08/19/2011-22:32:29:: Call to GetPropertiesAction(/Deployment/Subcontractor and Advisor Subscription, PathBased). library!ReportServer_0-125!11c4!08/19/2011-22:32:29:: Call to GetSystemPropertiesAction(). library!WindowsService_65!ab4!08/19/2011-22:32:37:: i INFO: Call to CleanBatch() library!WindowsService_65!ab4!08/19/2011-22:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 6 sessions, 0 cache entries, 3 snapshots, 67 chunks, 0 running jobs, 0 persisted streams, 29 segments, 29 segment mappings. library!WindowsService_65!ab4!08/19/2011-22:32:37:: i INFO: Call to CleanBatch() ends
August 27th, 2011 6:23pm

Hi RobinsonColin, From your description, I tried to reproduce this issue on my local machine. However, everything is fine. Could you please post more information about the parameters? Do you want to pass the main report parameters to filter data of subreprots? When you create a data-driven subscription, if you select “Get the value from the database” option on set parameter page, you can try to select “Specify a static value” option and type default parameter values for the main report. For more information about Create a data-driven subscription, please see: http://msdn.microsoft.com/en-us/library/ms187066(v=SQL.100).aspx Regards, Bin Long TechNet Subscriber Supportin forum If you have any feedback on our support, please contact tnmff@microsoft.comPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2011 11:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics