reporting services - Report rsExecutionNotFound when exporting to other formats -
i using crm 4.0 ssrs. can display reports take long time. when report displays can export excel, xml or file type within in 10 minutes. after 10 minutes, cannot export reports excel or other formats.
report message :
the report execution ifjzab55k5icxl4510oyfsmt has expired or cannot found. (rsexecutionnotfound)
report server log text:
error: throwing microsoft.reportingservices.diagnostics.utilities.reportserverstorageexception: , error occurred within report server database. may due connection failure, timeout or low disk condition within database.; session!reportserver_0-10!17c8!05/09/2013-16:03:14:: e error: error in getting session data: expired session: qkmiqv455sdu5wyc2sa23az1 session!reportserver_0-10!17c8!05/09/2013-16:03:14:: info: loadsnapshot: item session: qkmiqv455sdu5wyc2sa23az1, reportpath: , username: vrvending\crm.service not found in database library!reportserver_0-10!17c8!05/09/2013-16:03:14:: e error: throwing microsoft.reportingservices.diagnostics.utilities.executionnotfoundexception: , microsoft.reportingservices.diagnostics.utilities.executionnotfoundexception: report execution qkmiqv455sdu5wyc2sa23az1 has expired or cannot found"
this happening because session ssrs using store reports data has expired, releasing cached data; when attempt export there's nothing there to export. clicking "view report" again should rebuild cache, , allow export, can understand not being ideal user experience.
2 things i'd suggest trying:
increase session timeout ssrs.
in web.config, find "httpruntime" element, , add "requestlength" property it, set value absurdly high, 100000, , see if helps. (do in both reportserver , reportmanager web.configs)
given error message, doubt 2nd 1 issue, still may worth checking out, i've seen similar behavior fixed (albeit different error message).
you try tinkering reports snapshot settings, amount of overhead introduce on server may outweigh benefits of letting people export report...
Comments
Post a Comment