January 4, 2012 at 10:12 am
For a SSRS 2008 report that is hosted in Sharepoint 2007 in Integrated mode. I have created a Data Driven subscription which shows the following message on the manage subscription page.
Done: 2 processed of 2 total; 2 errors.
There is only 2 rows in this data subscription.
Looking at the created SQL Server agent job this is reported as successful, other non Data Driven schedules work from this configuration and for the same report.
How do I find what the error is, as the agent job shows as successful?
January 4, 2012 at 11:25 am
Have you checked things like the error log?
SSRS logs errors to a file in the installation directory. It also has, if I remember correctly, an execution log in the reporting services database.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 6, 2012 at 3:07 am
I found the issue in the SSRS logs and was able to fix the problem.
I would have thought that if the SSRS had an error on a subscription then SQL Agent job would have failed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply