Recursive Bill of Materials in Agile Can Cause the Compliance Rollup to Crash (Doc ID 1204065.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Agile Product Governance and Compliance - Version 9.3.0.1 and later
Information in this document applies to any platform.
Add ***Checked for relevance on 17-Jul-2014***

Symptoms

The Agile Application stopped responding with out of memory errors.

java.sql.SQLException: ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu call ,pmucalm coll)
ORA-06512: at line 1

10/08/02 19:33:16 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
10/08/02 19:33:16 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
10/08/02 19:33:16 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
10/08/02 19:33:16 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
10/08/02 19:33:16 at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)
10/08/02 19:33:16 at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)
10/08/02 19:33:16 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
10/08/02 19:33:16 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
10/08/02 19:33:16 at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3093)
10/08/02 19:33:16 at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4286)
10/08/02 19:33:16 at com.agile.pc.cmserver.item.ItemBOMIterator.traverseAllLevelNodesEx(ItemBOMIterator.java:755)
10/08/02 19:33:16 at com.agile.pc.cmserver.item.ItemBOMIterator.getMaxLevelOut(ItemBOMIterator.java:1022)
10/08/02 19:33:16 at com.agile.pgc.rollup2.complianceRollup.ItemComplianceRollup.traverseBOM(ItemComplianceRollup.java:239)
10/08/02 19:33:16 at com.agile.pgc.rollup2.complianceRollup.ItemComplianceRollup.doRollup(ItemComplianceRollup.java:180)
10/08/02 19:33:16 at com.agile.pgc.rollup2.complianceRollup.ItemComplianceRollup.rollup(ItemComplianceRollup.java:155)
10/08/02 19:33:16 at com.agile.pgc.service.RollupUtil.doRollup(RollupUtil.java:205)
10/08/02 19:33:16 at com.agile.pgc.service.RollupUtil.rollupForTLA(RollupUtil.java:112)
10/08/02 19:33:16 at com.agile.pgc.service.ComplianceRollupTask.doAllShippableRollup(ComplianceRollupTask.java:101)
10/08/02 19:33:16 at com.agile.pgc.service.ComplianceRollupTask.execute(ComplianceRollupTask.java:76)
10/08/02 19:33:16 at com.agile.common.server.eventmgr.RunnableEvent.run(RunnableEvent.java:44)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms