Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 282 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Bi Publisher 11g FAILED_TO_SEND_TO_JOB_QUEUE recursively scheduled job error
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?