SSRS Email Subscription Not Rendering Full Report
-
I have had this report set up to email out every morning in MHTML format for about a month now. About two weeks ago, I started noticing that the report wouldn't render fully when the subscription is being run. But when I get in at 8 AM and run the exact same subscription manually, the report is distributed as it should be.
This is the "problem" (suspended installs table is empty) :
And this is when I run it a an hour later:
What's missing from the first one is that it is not populating the "suspended installs" table. It isn't a lack of data issue, because when I moved the report subscription to run at 8:30 am, the report subscription would still have the same issue. It is very unpredictable; some days the report will be emailed out with the suspended installs table populated, and some days it doesn't have anything in the table.
I have tried to work with our server team, but they haven't been able to help, because there are no errors that are given when the report subscription is run.
Any help at all would be appreciated,
Thank you
-
From the data, it looks like nothing was suspended, so it had no data to display? You're saying when you change the time you have the same issue. Is it possible that something in the job data is throwing an error on the INSERT for the temp table, which means it doesn't populate? Is there a TRY/CATCH structure to bubble errors up to you?
Perhaps you should add a debug option into the stored proc to throw out current status, so you can see where it pukes?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply