DIP 11g - Org.quartz.impl.jdbcjobstore.JobStoreTX ORA-00942: Table Or View Does Not Exist
(Doc ID 1490029.1)
Last updated on MAY 29, 2024
Applies to:
Oracle Internet Directory - Version 11.1.1.2.0 and laterInformation 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-<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
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
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 |