When by mistake we stopped the IBM WAS Server when Match Job was running. It didn't allowed us to run again the Match Job, every time it was giving following error:
[ERROR] com.delos.cmx.server.datalayer.repository.object.ReposTableObject$TableObjectExecutionThread: Thread[Revalidate for TABLE_NAME, 5,main] com.siperian.common.SipRuntimeException: SIP-09069: Failed to execute java null
Failed to execute java null
at com.siperian.common.SipRuntimeException.createNotExternalized(SipRuntimeException.java:74)
at com.delos.cmx.server.datalayer.repository.object.ReposTableObject$TableObjectExecutionThread.processException(ReposTableObject.java:2216)
at com.delos.cmx.server.datalayer.repository.object.ReposTableObject$TableObjectExecutionThread.run(ReposTableObject.java:2241) Caused by: com.informatica.mdm.dba.deala.CmxLock$CmxLockLogicException: SIP-20880: ERROR: Cannot lock table [TABLE_NAME] because the table is locked by another process.
TABLE_NAME
at com.informatica.mdm.dba.deala.CmxLock.acquire_lock_tbl(CmxLock.java:304)
at com.informatica.mdm.dba.deala.CmxLock.acquire_lock(CmxLock.java:181)
at com.informatica.mdm.jobcontrol.JobControl.acquireLock(JobControl.java:262)
at com.informatica.mdm.jobcontrol.JobControl.registerJob(JobControl.java:220)
at com.informatica.mdm.batch.recalculate.BatchRecalculate.registerJob(BatchRecalculate.java:313)
at com.informatica.mdm.batch.recalculate.BatchRecalculate.acquireLockOrRegisterJob(BatchRecalculate.java:290)
at com.informatica.mdm.batch.recalculate.BatchRecalculate.execute(BatchRecalculate.java:180)
at com.delos.cmx.server.datalayer.repository.object.ReposTableObject.executeJavaRevalidate(ReposTableObject.java:1239)
at com.delos.cmx.server.datalayer.repository.object.ReposTableObject.executeReal(ReposTableObject.java:2137)
at com.delos.cmx.server.datalayer.repository.object.ReposTableObject.access$200(ReposTableObject.java:97)
at com.delos.cmx.server.datalayer.repository.object.ReposTableObject$TableObjectExecutionThread.run(ReposTableObject.java:2234)
In order to solve above error do following:
- Make sure no Batch Processing is running.
- Login the SQL Developer
- Open your Database
- Fire following command
- Truncate c_repos_applied_lock table.
- Commit
- Rerun the job.
0 Comment(s)