Report Subscription - FAILS when trying to attach the Report content [pdf]

Question

Report Subscription - FAILS when trying to attach the Report content [pdf]

venk

SSC Enthusiast

Points: 123
More actions
August 5, 2005 at 4:32 am

#165207

Hi.
I am trying to send the Report content (as pdf attachment) through email subscription.
Using Windows 2000 sevrer, SQL server 2000.
When the event is fired as per the schedule, i get the following error message.
{ If i include only the link (url) to the report instead of content attachemnt, it works without problem & mail will be delivered.}
Failure sending mail: The Report Server has encountered a configuration error; more details in the log files.
Last few lines of the logfile are like this....
----------------------------------------------------------------------
aspnet_wp!library!778!8/5/2005-15:05:32:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
aspnet_wp!library!b54!08/05/2005-15:14:30:: i INFO: Call to GetPermissions:/DDS/rptCSSummarySubsDetail
aspnet_wp!library!b54!08/05/2005-15:14:30:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/DDS/rptSummaryByNetworkDetail' cannot be found., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/DDS/rptSummaryByNetworkDetail' cannot be found.
aspnet_wp!processing!b54!08/05/2005-15:14:30:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: The item '/DDS/rptSummaryByNetworkDetail' cannot be found.
aspnet_wp!processing!b54!08/05/2005-15:14:30:: e ERROR: Stack trace:    at Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext reportContext, String subreportPath, CatalogItemContext& subreportContext, GetReportChunk& getCompiledDefinition, DataSourceInfoCollection& dataSources)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!b54!08/05/2005-15:14:30:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!b54!08/05/2005-15:14:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/DDS/rptSummaryByNetworkDetail' cannot be found., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/DDS/rptSummaryByNetworkDetail' cannot be found.
aspnet_wp!processing!b54!08/05/2005-15:14:31:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: The item '/DDS/rptSummaryByNetworkDetail' cannot be found.
aspnet_wp!processing!b54!08/05/2005-15:14:31:: e ERROR: Stack trace:    at Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext reportContext, String subreportPath, CatalogItemContext& subreportContext, GetReportChunk& getCompiledDefinition, DataSourceInfoCollection& dataSources)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!b54!08/05/2005-15:14:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/DDS/rptSummaryByNetworkDetail' cannot be found., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/DDS/rptSummaryByNetworkDetail' cannot be found.
aspnet_wp!processing!b54!08/05/2005-15:14:31:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: The item '/DDS/rptSummaryByNetworkDetail' cannot be found.
aspnet_wp!processing!b54!08/05/2005-15:14:31:: e ERROR: Stack trace:    at Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext reportContext, String subreportPath, CatalogItemContext& subreportContext, GetReportChunk& getCompiledDefinition, DataSourceInfoCollection& dataSources)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!b94!8/5/2005-15:15:32:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
aspnet_wp!library!778!8/5/2005-15:25:32:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
Any help to solve this will be greatly appreciated.
This issue is very urgent. Please respond immediately.
Thanks
-Venk.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 1

From the log it looks like the sub report (rptSummaryBynetowrkDetail) isn't where RS is expecting it do be (sub-dir /DDS/<report&gt. If the two reports are in the same dir, you may want to try creating a new folder (DDS) and putting the subreport within this sub folder. Maybe you published the 'parent' report without the child? If so, publish the sub-report too.

Steve.