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

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Directory - Version 11.1.1.2.0 to 11.1.1.6.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

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

The configuration of the synchronization and provisioning profiles looks OK.

wls_ods1-diagnostic.log shows the following :-
------------------------------------------------

[2012-09-08T12:52:28.241-07:00] [wls_ods1] [ERROR] [] [org.quartz.impl.jdbcjobstore.JobStoreTX] [tid: QuartzScheduler_DefaultQuartzScheduler-oid11g.au.oracle.com1347070335370_ClusterManager] [userId: <anonymous>] [ecid: 0000JaZdVR1FKAaLxMK6yW1GIe_m000002,0] [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

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms