Hello,
We have been using SSRS Subscriptions for quite some time now. The last few weeks we are noticing that the email notifications are being sent to users twice. One with correct data and one with incorrect data(without a clear pattern for the incorrect file).
11:00am today, we received an Accounts Due report that has all of the correct open AR and I was able to open the customer record and match every transaction.
11:02am today, Same report "Criteria aka Customer Criteria" yet inaccurate transaction output.
Out of the three customers in the inaccurate report, one is correct, one customer is completely missing and one is pulling 1 invoice that is accurate, 1 that is missing and another that appears on report, but system shows it was paid last month.
3/25/2019 the report generated once correctly.
4/1/2019 the report generated correctly and then an incorrect report was also sent 1 minute later.
4/8/2019 the report generated correctly and then an incorrect report was also sent 1 minute later. (Exact same report as the 4/1/19 incorrect rep)
4/15/2019 the report generated correctly and then an incorrect report was also sent 1 minute later. (Exact same report as the 4/1/19 incorrect rep)
4/15/2019 the report generated correctly ( I created a new subscription test) - duplicate issue does not take place.
Last week when I saw this pattern I asked our admin to delete the subscription for me and reenter it. That did not resolve the automated subscription that takes place every Monday at 11am. I feel like the automated subscriptions are stuck and for some reason grabbing historical data. The only thing that took place around this time frame is that we took one of our server backups and restored it in our new server environment for testing. But, live production should not have been affected.
Any one have an idea what could make this happen?
Looking at the Report Server dbo.Subscriptions the last run time only shows the correct 11:00 am report execution. I do not see the 11:02 record listed in this table.
Not sure where it is coming from or how to stop it. We have 199 subscriptions in total and staff receive numerous reports.
Thank you for your help!
*This post is locked for comments