The Reporter Purge fails with error message: ORA-02292: integrity constraint (UNIREPORTER.UNI_EVT_VARIABLES_RL_FK) violated - child record found

Document ID : KB000086372
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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
Environment:
OS: All
Cause:
Cause type:
Defect
Root Cause: This is a defect affecting Reporter 3
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Reporter 3.0.10