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:
Oracle Fusion Purchasing Cloud Service - Version 11.13.22.10.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |