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
Same here. Once it errors the tessitura environment needs to get restarted overnight. Just RS,SQL server or report server, or the windows servers they sit on alone isn't enough.
We can't run a basic SSRs report once the error occurs once.
Transparent issue is interesting.
Curious to see what other people find too.