BI Report Schedule Failing When Selecting Multiple Parameters For The Trigger (Doc ID 2758303.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Symptoms

Have a BI report which has a schedule trigger defined works fine when we run the report on demand.

When scheduling the report it runs ok when selecting only one parameter for the Trigger.
However, When we scheduling the report and selecting more than one parameter for the Trigger, the job status shows as Skipped and the job shows:

The trigger SQL failed to execute
[INSTANCE_ID=bip.bi_serverHA] [JOB_ID=204202]
Failed to execute event trigger
oracle.xdo.servlet.scheduler.ProcessingException: Failed to execute event trigger
at oracle.xdo.servlet.ReportContext.executeEventTrigger(ReportContext.java:651)
at oracle.xdo.enterpriseScheduler.SchedulerJob.execute(SchedulerJob.java:287)
at oracle.xdo.service.scheduling.impl.ess.EssJob.execute(EssJob.java:105)
at oracle.as.scheduler.rp.JavaSysExecWrapper$1.run(JavaSysExecWrapper.java:424)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.internal.jaas.AccActionExecutor.execute

Tried enabling Diagnostics, but no Diagnostic log was generated.

Changes

 Schedule the report and select multiple parameters for the Event Trigger.

Cause

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