Hi,
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:-
Status: Failed
Destination: None
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 burst to all stores, only the one attribute Store No is changed via the scheduler, this report is then seen in the instance manager as 360 separate reports with column Run By 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?
Many Thanks,
Madhu
madhu_pulluru (BOB member since 2009-03-11)