The Reporter Purge fails with error message: ORA-02292: integrity constraint (UNIREPORTER.UNI_EVT_VARIABLES_RL_FK) violated - child record found
book
Article ID: 86372
calendar_today
Updated On:
Products
CA Automic Dollar Universe
Issue/Introduction
Affects Release version(s): 3
Error Message : The following error message is present in Reporter's server.log ######################### [ERROR] 27 Apr 2012 10:15:01 [pool-1-thread-36] com.orsyp.reppub.server.process.ReporterPurgeExtractionSource - SQLException thrown by the purge operation for the [PurgeCriterionDuas - company = * uvmsName = * node = * areaCode = * mu = * session = * uproc = * limit = 180]; operation will be rollbacked java.sql.SQLException: ORA-02292: integrity constraint (UNIREPORTER.UNI_EVT_VARIABLES_RL_FK) violated - child record found
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062) at com.orsyp.reppub.server.process.ReporterPurgeExtractionSource.purgeChunkOfObjects(ReporterPurgeExtractionSource.java:135) at com.orsyp.reppub.server.process.ReporterPurgeExtractionSource.purge(ReporterPurgeExtractionSource.java:654) at com.orsyp.reppub.server.process.ReporterPurgeExtractionSource.call(ReporterPurgeExtractionSource.java:80) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [ERROR] 27 Apr 2012 10:15:01 [pool-1-thread-36] com.orsyp.reppub.server.listener.ReporterProcessListener - failedExecution:ReporterPurgeExtractionSource:43C32023-86F6-3630-FC64-5BE7FE36F1D6 java.util.concurrent.ExecutionException: java.sql.SQLException: ORA-02292: integrity constraint (UNIREPORTER.UNI_EVT_VARIABLES_RL_FK) violated - child record found
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at com.orsyp.util.concurrentrep.NotifyThreadPoolExecutor2.afterExecute(NotifyThreadPoolExecutor2.java:51) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: ORA-02292: integrity constraint (UNIREPORTER.UNI_EVT_VARIABLES_RL_FK) violated - child record found #########################
Patch level detected:Reporter The Reporter purge fails with error message: java.sql.SQLException: ORA-02292: integrity constraint (UNIREPORTER.UNI_EVT_VARIABLES_RL_FK) violated- child record found
Cause
Cause type: Defect Root Cause: This is a defect affecting Reporter 3
Environment
OS: All
Resolution
Update to a fix version listed below or a newer version if available.