Thursday, March 22, 2012

Data driven subscription

I have create a data driven subscription that should email to to different people. It is sent to one but not the other. if I set up a normal subscription to the email it works. I can not see anywhere in the log the problem. Any Ideas on how to find out what is causing it.

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.

|||

Edit

Send e-mail to PorterS

TimedSubscription

12/21/2006 8:40 AM

Mail sent to PorterS

Edit

Upcoming

TimedSubscription

12/21/2006 10:45 AM

Done: 1 processed of 1 total; 1 errors.

|||Also as you can see a subsscription ran at 10:45 But i do not see any log after 8:37 am this morning could loggin be turned off?|||

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