Hello all.
I recently discovered that one of our local SSRS reports is having this problem for scheduled runs. In GOOESOFT_REQUEST, scheduled runs (type = 's') always have result_code = 's' and result_text = 'Error creating report snapshot'. The Maintain Schedules shows that the Next Run Date is incremented, but Last Run Date says "Never Run". The report runs fine when done manually.
So it seems like an issue with the snapshot folder, but I checked our settings in T_DEFAULTS and they're good. In fact, this is the only report that consistently has this problem. And it happens for anyone who schedules it (including myself, an admin), even people who have other scheduled reports that don't have problems.
My next step is to trouble-shoot the SSRS report itself, but I'm not sure where to start. Has anyone seen this behavior? Any suggestions?
Thanks very much!
Nathan
I was having these problems after upgrading to V12
after some troubleshooting, I established that shutting down the Report Server does not actually stop the process (i.e. it remains resident in memory).
So to remove report Server from memory:
1. Exit out of Report Server program.
2. Press CTRL+SHIFT+ESC to access Task Manager.
3. Look for gsrbatch.exe (this is the executable file for Report Server)
Should find that in left-most column ('Image Name' in Windows7 - )
4. Right-click on this and select end process. Select 'Yes'/End Process' to confirm.
5. Restart Report Server
Hope this helps with some of your problems.
David