Scheduling a BIP Report failed but ESS job with same BIP report is going to success

Sahana Sakkarpani-Oracle

Hi Team,

Is anybody faced issue in scheduling BIP report which leads to failure with below error.

Job processor caused exception
[INSTANCE_ID=bip.bi_server1] [INSTANCE_JOB_ID=79688]

Error getting report data
[INSTANCE_ID=bip.bi_server1]
oracle.xdo.servlet.scheduler.ProcessingException:
Error getting report data
[INSTANCE_ID=bip.bi_server1]
at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.getControlXML(BurstingJobProcessor.java:767)
at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.execute(BurstingJobProcessor.java:450)
at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.onMessage(BurstingJobProcessor.j

Report is not having bursting, only CSV output format in report.

Ess Job is successfully completing and producing output for the same BIP report.

Regards

Sahana

Sumanth V -Oracle

@Sahana Sakkarpani-Oracle - Please validate your bursting query and main dataset query and make sure the data fetched matches.

Reference: BI Publisher - Bursting Fails With "Oracle.xdo.servlet.scheduler.ProcessingException: :ERROR_GETTING_REPORT_DATA" While Scheduling a Report (Doc ID 2994822.1)