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
Hi Nathan!
I've sometimes noticed that SSRS reports that have trouble being scheduled (and spitting out the error you mention) usually have some sort of tiny flaw that doesn't appear when you run the report immediately via Tessitura. However, sometimes you'll see an "error" when you run the report in the Visual Studio designer in Preview. The error list might be some minor warnings (like "Transparent" isn't a real color, or something like that) - but I've often noticed when I remove those errors that appear in Preview, that I am suddenly able to successfully schedule the report. YRMV. :)
Beth
That's interesting, I'll start with that. Thanks very much!