March 4, 2019 at 11:45 am
We have some SSRS reports and subscriptions running at weekend.
One report is a summary of a count of records of a table and sent the email to print vendors.
The subscription email also CC to us.
And we found last night the email for the subscription letter said there are 0 records that was sent.
That is not right because there are records in the data source tables of the report.
Tried to troubleshoot, the report did run midnight, and but its contents say there are 0 records.
We can see from the data of the data source table time stamp was created before the report generated.
There should not be a connection issue from SSRS to database server, if there is, it should error out instead of return 0 records.
And this early morning I rerun exactly the same job, and it generates the reports and the count (300 rows) correctly.
Between the time of last run and this run, there should not be any data changes because the data is stored in staging table.
Any troubleshooting tips I should consider?
Thanks
March 4, 2019 at 1:00 pm
I found the mystery answer. The job ran much longer time last night because many new data changed over the weekend.
And the job run time extended to another job which reset some flags.
Thanks.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply