Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Bi Publisher 11g FAILED_TO_SEND_TO_JOB_QUEUE recursively scheduled job error

Question
15
Views
0
Comments

Summary

Bi Publisher 11g FAILED_TO_SEND_TO_JOB_QUEUE recursively scheduled job error

Content

Hi ,

When i schedule bipublisher report recursively with bursting, i.e. ; from 10:00 a.m. to 10:30 a.m. and run every 5 minutes. At this time, sometimes job ends successfully and sometimes ends with error. If job finishes error at this schedule period, it takes milliseconds. Report Sql query does not reach to database.

This issue is not happening for one report. Also when i schedule  different reports, i get same error.

But, when i choose "run now" method and submit  , jobs finish with success. i have tried this scenario more than 10 times.

I checked bipublisher.log under the path ( HOME$\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\logs\bipublisher) but did not find any clue about job finished with error.

Here is the error description , when job fails. It's sent to me as notification mail;

::FAILED_TO_SEND_TO_JOB_QUEUE.::[INSTANCE_ID= ServerName.1428059848466] [JOB_ID=17654]::

null::

java.lang.NullPointerException

at oracle.xdo.enterpriseScheduler.SchedulerJob.execute(SchedulerJob.java:204)

at oracle.xdo.service.scheduling.impl.quartz.QuartzJob.execute(QuartzJob.java:24)

at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)

How can i fix this issue?