My Oracle Support Banner

DIP 11g 12c - Org.quartz.impl.jdbcjobstore.JobStoreTX ORA-00942: Table Or View Does Not Exist (Doc ID 1490029.1)

Last updated on JANUARY 13, 2025

Applies to:

Oracle Internet Directory - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

In Directory Integration Platform (DIP), the managed server is running but no synchronization occurs.

The configuration of the synchronization and provisioning profiles looks OK.

11g wls_ods1-diagnostic.log example :
------------------------------------------------

[2012-09-08T12:52:28.241-07:00] [wls_ods1] [ERROR] [] [org.quartz.impl.jdbcjobstore.JobStoreTX] [tid: QuartzScheduler_DefaultQuartzScheduler-<OID_HOSTNAME><nnnnnnnnnnnnnn>_ClusterManager] [userId: <anonymous>] [ecid: <ECID>] [APP: DIP#11.1.1.2.0] ClusterManager: Error managing cluster: Failure obtaining db row lock: ORA-00942: table or view does not exist[[
 org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ORA-00942: table or view does not exist
 [See nested exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
]
    at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:112)
    at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:112)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3096)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3713)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3749)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

 12c wls_ods1-diagnostic.log example:
-------------------------------------------------

[2024-05-14T05:32:59.865+00:00] [wls_ods1] [NOTIFICATION] [DIP-10605] [oracle.dip.update] [tid: Scheduler] [userId: <anonymous>] [ecid: <ecid>] [APP: DIP] [partition-name: DOMAIN] [tenant-name: GLOBAL] Profile added successfully for scheduling : ....
[2024-05-14T05:32:59.868+00:00] [wls_ods1] [ERROR] [] [oracle.dip] [tid: Scheduler] [userId: <anonymous>] [ecid: <ecid>] [APP: DIP] [partition-name: DOMAIN] [tenant-name: GLOBAL] ERROR_SUBMITTING_JOBS[[
org.quartz.JobPersistenceException: Couldn't retrieve job: ORA-00942: table or view does not exist
[See nested exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveJob(JobStoreSupport.java:1338)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$7.execute(JobStoreSupport.java:1308)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3662)

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)

Caused by: Error : 942, Position : 14, Sql = SELECT * FROM ODSQTZ_JOB_DETAILS WHERE JOB_NAME = :1 AND JOB_GROUP = :2 , OriginalSql = SELECT * FROM ODSQTZ_JOB_DETAILS WHERE JOB_NAME = ? AND JOB_GROUP = ?, Error Msg = ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
... 110 more

 

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


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