|
|
You're in the
sql server reporting services
group:E-mail failure in data driven subscriptions
sql server reporting services:
reports to different addresses I have only been able to find a number that were successful or failed. Is there any way to tell specifically which
The ReportServerService<timestamp>.log file will contain the information.
There is no UI around this information. -- -Daniel This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "bwray" <bwray@discussions.microsoft.com> wrote in message news:021B7E1F-76F7-4932-9448-7B79EF561763@microsoft.com... > When using a data driven subscription to generate and send a number or > reports to different addresses I have only been able to find a number that > were successful or failed. Is there any way to tell specifically which > e-mails from the group failed?
Thanks. That helped to some degree. I still can't find which indivdual
e-mail within the batch failed. I set up a controlled report scenario in which I knew two of the e-mails would fail. However, the indivdual entrees in the execution log all had a 'rssuccess' status for the report. The 'last run status' in the schedule table shows '2 of 3 comlete with 2 errors'. I know which ones failed, I just can't seem to pinpoint them within the logs. Am I on the right track or am I looking in the wrong place? Thanks. [quoted text, click to view] "Daniel Reib [MSFT]" wrote:
> The ReportServerService<timestamp>.log file will contain the information. > There is no UI around this information. > > -- > -Daniel > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "bwray" <bwray@discussions.microsoft.com> wrote in message > news:021B7E1F-76F7-4932-9448-7B79EF561763@microsoft.com... > > When using a data driven subscription to generate and send a number or > > reports to different addresses I have only been able to find a number that > > were successful or failed. Is there any way to tell specifically which > > e-mails from the group failed? > >
You should look in the log files for something like the following:
Notification <guid> completed. Success: True, Status: Mail sent to <address>, DeliveryExtension: Report Server Email, Report: <report name>, Attempt 0 -- -Daniel This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "bwray" <bwray@discussions.microsoft.com> wrote in message news:C99702B8-05E3-46FC-B7F5-A450289EF8DF@microsoft.com... > Thanks. That helped to some degree. I still can't find which indivdual > e-mail within the batch failed. I set up a controlled report scenario in > which I knew two of the e-mails would fail. However, the indivdual > entrees > in the execution log all had a 'rssuccess' status for the report. The > 'last > run status' in the schedule table shows '2 of 3 comlete with 2 errors'. > I > know which ones failed, I just can't seem to pinpoint them within the > logs. > Am I on the right track or am I looking in the wrong place? Thanks. > > "Daniel Reib [MSFT]" wrote: > >> The ReportServerService<timestamp>.log file will contain the information. >> There is no UI around this information. >> >> -- >> -Daniel >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "bwray" <bwray@discussions.microsoft.com> wrote in message >> news:021B7E1F-76F7-4932-9448-7B79EF561763@microsoft.com... >> > When using a data driven subscription to generate and send a number or >> > reports to different addresses I have only been able to find a number >> > that >> > were successful or failed. Is there any way to tell specifically which >> > e-mails from the group failed? >> >> >>
Thanks again. I think I'm getting closer to what I'm looking for but I'm
still not there. The 'To:' address for e-mails that fail is not available in the log file. Now I can tell by recipient / time which ones were successful. Now the problem is that if multiple copies of the same named report go out in close proximity to each other (think invoices) I can't tell which one fails. [quoted text, click to view] "Daniel Reib [MSFT]" wrote:
> You should look in the log files for something like the following: > > Notification <guid> completed. Success: True, Status: Mail sent to > <address>, DeliveryExtension: Report Server Email, Report: <report name>, > Attempt 0 > > > -- > -Daniel > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "bwray" <bwray@discussions.microsoft.com> wrote in message > news:C99702B8-05E3-46FC-B7F5-A450289EF8DF@microsoft.com... > > Thanks. That helped to some degree. I still can't find which indivdual > > e-mail within the batch failed. I set up a controlled report scenario in > > which I knew two of the e-mails would fail. However, the indivdual > > entrees > > in the execution log all had a 'rssuccess' status for the report. The > > 'last > > run status' in the schedule table shows '2 of 3 comlete with 2 errors'. > > I > > know which ones failed, I just can't seem to pinpoint them within the > > logs. > > Am I on the right track or am I looking in the wrong place? Thanks. > > > > "Daniel Reib [MSFT]" wrote: > > > >> The ReportServerService<timestamp>.log file will contain the information. > >> There is no UI around this information. > >> > >> -- > >> -Daniel > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> > >> "bwray" <bwray@discussions.microsoft.com> wrote in message > >> news:021B7E1F-76F7-4932-9448-7B79EF561763@microsoft.com... > >> > When using a data driven subscription to generate and send a number or > >> > reports to different addresses I have only been able to find a number > >> > that > >> > were successful or failed. Is there any way to tell specifically which > >> > e-mails from the group failed? > >> > >> > >> > >
I'm not sure what the issue might be. Each row from the DataDriven
subscription will create a new notification row. Each of these rows are handled individually. I am not sure why you are not seeing the results. You could send me the log file and I could take a look if you like. Just remove the online from my address. -- -Daniel This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "bwray" <bwray@discussions.microsoft.com> wrote in message news:90179329-413F-425F-8D8F-FD97876F94FE@microsoft.com... > Thanks again. I think I'm getting closer to what I'm looking for but I'm > still not there. The 'To:' address for e-mails that fail is not available > in > the log file. Now I can tell by recipient / time which ones were > successful. Now the problem is that if multiple copies of the same named > report go out in close proximity to each other (think invoices) I can't > tell > which one fails. > > "Daniel Reib [MSFT]" wrote: > >> You should look in the log files for something like the following: >> >> Notification <guid> completed. Success: True, Status: Mail sent to >> <address>, DeliveryExtension: Report Server Email, Report: <report name>, >> Attempt 0 >> >> >> -- >> -Daniel >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "bwray" <bwray@discussions.microsoft.com> wrote in message >> news:C99702B8-05E3-46FC-B7F5-A450289EF8DF@microsoft.com... >> > Thanks. That helped to some degree. I still can't find which indivdual >> > e-mail within the batch failed. I set up a controlled report scenario >> > in >> > which I knew two of the e-mails would fail. However, the indivdual >> > entrees >> > in the execution log all had a 'rssuccess' status for the report. The >> > 'last >> > run status' in the schedule table shows '2 of 3 comlete with 2 >> > errors'. >> > I >> > know which ones failed, I just can't seem to pinpoint them within the >> > logs. >> > Am I on the right track or am I looking in the wrong place? Thanks. >> > >> > "Daniel Reib [MSFT]" wrote: >> > >> >> The ReportServerService<timestamp>.log file will contain the >> >> information. >> >> There is no UI around this information. >> >> >> >> -- >> >> -Daniel >> >> This posting is provided "AS IS" with no warranties, and confers no >> >> rights. >> >> >> >> >> >> "bwray" <bwray@discussions.microsoft.com> wrote in message >> >> news:021B7E1F-76F7-4932-9448-7B79EF561763@microsoft.com... >> >> > When using a data driven subscription to generate and send a number >> >> > or >> >> > reports to different addresses I have only been able to find a >> >> > number >> >> > that >> >> > were successful or failed. Is there any way to tell specifically >> >> > which >> >> > e-mails from the group failed? >> >> >> >> >> >> >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |