Morning TN-
We're having a problem with scheduled SSRS reports after upgrading to V11. None of the reports are using the depreciated parameters and I think our T_DEFAULTS settings look fine for timeout and the servers. The reports do run manually.
Under Maintain Report/Utilitiy Schedules the reports show that they are going to run at the next schedule, but then pass the schedule either saying "Never Run" or a previous date pre-upgrade.
Any ideas?
Have you applied the following patches? AP_MAIL_REPORT_2467.sql, TessituraReportServer_2420.zip and AP_SEND_SMTP_MAIL_2411.sql
We had a few issues until we applied those patches.
Thanks for the replies-
Turns out that there are some quirks with the T_DEFAULTS settings where the reports should now be listed in GSR/the gooesoftreport tables as 'ReportName' and not 'path/ReportName' with the report path being held in the T_DEFAULTS table (Seems this may be a requirement, apparently) .
After this was sorted out we needed to then add a second SecheduledReports folder within the custom report folder as it was no longer going to use the folder in the main directory.
Finally it was found that there were some permissions missing on required folders to allow the snapshots to be written at all (this may have been the original issue?)
Thankfully Jennifer (RAMP) and Brian Pedaci were able to help us sort this out. Seems as if there are quite a few quirky differences in the setup introduced with updates to the paths. If anyone is having any similar issues I'd suggest really going through and utilizing all the new settings to their full intention.
Thanks-
Chris