My Oracle Support Banner

PGC Rollup Error: ORA-02292: integrity constraint (AGILE.RESULT_SUBSTANCE_COMPLIAN_FK1) violated (Doc ID 2552217.1)

Last updated on JULY 27, 2019

Applies to:

Oracle Agile Product Governance and Compliance - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.3.6.0 version, Rollup (PGC)

When attempting to run PGC rollup ,
the following error occurs.

ERROR
-----------------------
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (AGILE.RESULT_SUBSTANCE_COMPLIAN_FK1) violated - child record found
ORA-06512: at "AGILE.AGILE_PGC_EXTERNAL_ROLLUP", line 3977


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open MPN with external specification.
2. Go to the Compliance tab.
3. Click on "Calculate Compliance"
4. Error displayed on the screen

ERROR LOG
-----------------------
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (AGILE.RESULT_SUBSTANCE_COMPLIAN_FK1) violated - child record found
ORA-06512: at "AGILE.AGILE_PGC_EXTERNAL_ROLLUP", line 3977
ORA-06512: at line 1
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)
  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
  at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300)
  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
  at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4230)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
  at com.agile.pgc.service.ExternalRollupDAO.deleteStagingTable(ExternalRollupDAO.java:68)
  at com.agile.pgc.rollup3.ComponentExternalRollup.rollup(ComponentExternalRollup.java:268)
  at com.agile.pgc.rollup2.complianceRollup.BasePartComplianceRollup.rollup(BasePartComplianceRollup.java:106)
  at com.agile.pc.cmserver.mfrpart.MfrPartService.rollupCompliance(MfrPartService.java:1428)
  at com.agile.pc.cmserver.mfrpart.MfrPartSessionBean.rollupCompliance(MfrPartSessionBean.java:241)
  at com.agile.pc.cmserver.mfrpart.MfrPartSessionBean_sugh32_EOImpl.__WL_invoke_2(Unknown Source)
  at com.agile.pc.cmserver.mfrpart.MfrPartSessionBean_sugh32_EOImpl.__WL_invoke_1(Unknown Source)
  at com.agile.pc.cmserver.mfrpart.MfrPartSessionBean_sugh32_EOImpl.__WL_invoke(Unknown Source)
  at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invokeInternal(SessionRemoteMethodInvoker.java:54)
  at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:21)
  at com.agile.pc.cmserver.mfrpart.MfrPartSessionBean_sugh32_EOImpl.rollupCompliance(Unknown Source)
  at com.agile.ipa.pc.CMMfrPart.rollupCompliance(CMMfrPart.java:256)
  at com.agile.ui.pcm.mfrpart.MfrPartHandler.checkCompliance(MfrPartHandler.java:677)

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.