Burst Reports-DESKI-BOXI R2 SP2
We have some DESKI reports those are scheduled to run on every Tuesday.
Today these reports are failed for couple of users with the following reason:-
Start Time: 12 May 2009 12:08:26 o'clock BST
End Time: 12 May 2009 12:10:18 o'clock BST
Server Used: MI003MOA08-02.Desktop_IntelligenceJobServer
Error Message: Connection or SQL sentence error: (DA0005): [Exception: DBD, ORA-12537: TNS:connection closed State: N/A] A connection required to refresh this document is unavailable. (DA0004):  The following data providers have not been successfully refreshed: LW. (DMA0007): 
Both of these reports(Failed reports with the above reason) are scheduled to run for all stores, e.g The report is u201Cburstu201D to all stores, only the one attribute u201CStore Nou201D is changed via the scheduler, this report is then seen in the instance manager as 360 separate reports with column u201CRun Byu201D showing as username etc.
It is during the reports going through the scheduler that our errors are being seen.
Over the last 6-8 weeks the reports(360) have been a mix of single run and burst reports.
We have checked the event logs and nothing observed related to these reports.
I would be greteful if any one of you could please let me know the reason behind this error?