Cannot Run Any Jobs. Error "Couldn't Recover Jobs: Couldn't Store Trigger: ORA-64219: Invalid LOB Locator Encountered" (Doc ID 2860973.1)

Last updated on DECEMBER 20, 2024

Applies to:

Symptoms

On : 5.5.1 version on 19c database and Weblogic 12.2.1.4, Integra Apps

Error while scheduling jobs in CCG

Error encountered while processing the request. Please try again.
If problem persists, please contact your System Admininstator

com.applimation.amplatform.exception.AMException
at com.applimation.amplatform.action.AMSchedulesAction.execute(AMSchedulesAction.java:469)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)

ERROR
=====

-----------------------Error in the log file

* Nested Exception (Underlying Cause) ---------------
org.quartz.JobPersistenceException: Couldn't recover jobs: Couldn't store trigger: ORA-64219: invalid LOB locator encountered
[See nested exception: org.quartz.JobPersistenceException: Couldn't store trigger: ORA-64219: invalid LOB locator encountered
[See nested exception: java.sql.SQLException: ORA-64219: invalid LOB locator encountered
]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:704)
at org.quartz.impl.jdbcjobstore.JobStoreTX.recoverJobs(JobStoreTX.java:100)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:502)
at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:74)
at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:915)
at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1047)
at com.applimation.amplatform.api.scheduler.quartz.AMQuartzSchedulerAPI.getScheduler(Unknown Source)
at com.applimation.amplatform.api.scheduler.quartz.AMQuartzSchedulerAPI.(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorI


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to CG application as amadmin user.
2. Navigate to Jobs - Schedule jobs
3. Add Item -Select the Job type and Program name -Click on save -Schedule

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run any definitions.

Cause

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