Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Burst Reports-DESKI-BOXI R2 SP2

Hello All,

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 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?

Many Thanks,

Madhu

Former Member
Not what you were looking for? View more on this topic or Ask a question