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

Question

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 · Answer

@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)