Fusion BIP:Failed To Execute Event Trigger error while scheduling the report having event trigger (Doc ID 2911621.1)

Last updated on APRIL 28, 2024

Applies to:

Symptoms

When Customer tries to schedule the custom BIP report with event trigger and gets the following error.

ERROR:
  
Job processor caused exception
[INSTANCE_ID=bip.bi_server1] [INSTANCE_JOB_ID=XXXX]
The trigger SQL failed to execute
[INSTANCE_ID=bip.bi_server1] [JOB_ID=XXXX]
Failed to execute event trigger
oracle.xdo.servlet.scheduler.ProcessingException: Failed to execute event trigger
at oracle.xdo.servlet.ReportContext.executeEventTrigger(ReportContext.java:678)
at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.checkEventTrigger(BurstingJobProcessor.java:1389)
at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.onMessage(BurstingJobProcessor.java:231)
at oracle.xdo.enterpriseScheduler.util.Checkpo

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.