What is a subscription status in a Report Manager after it's executed?
If it's like ‘Done: {1} processed of {1} total;’ then everything worked fine. Your data driven (DD) query returned just one user to send email to.
If it's like ‘Done: {1} processed of {3} total; {2} errors’ then yes, two subscriptions failed. In that case you can find error details in the logfile. Subscription processing error details are logged into files like ReportServerService__<datetime>.log located at <Program Files>\Microsoft SQL Server\MSSQL.#\Reporting Services\LogFiles.
|||Second subscription at 10:45 (data driven) had one user to send e-mail to and it's processing failed. Please find error details in the RS windows service logfile.
|||What is the log filename?|||ReportServerService__12_21_2006_00_08_25.log|||Any chance there is another file ReportServerService__12_21_2006_hh_mm_ss.log created later that contains records for 10:45 subscription? Or any chance that there is another RS instance sharing same database, and that instance procesed 10:45 subscription? Logging is turned OFF by either removing ReportingServicesService.exe.config from Reporting Services\ReportServer\Bin directory or by setting DefaultTraceSwitch value to 0 in this config file. If none of options above explains why you don't see logging for 10:45 subscription then I don't have an explanation.
|||Thank's I will take a look.sql
No comments:
Post a Comment