Xog Out fails with error Java heap space

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Unable to update large volume of  records using xog and failing with below errors 

 

      <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>XOG-3656: Investment Object operation failed: update</Description>
        <Exception><![CDATA[
java.lang.OutOfMemoryError: Java heap space
 at com.ca.clarity.jdbc.oracle.OracleImplConnection.a(Unknown Source)
 at com.ca.clarity.jdbc.oracle.ddu.a(Unknown Source)
 at com.ca.clarity.jdbc.oracle.ddu.a(Unknown Source)
 at com.ca.clarity.jdbc.oracle.ddu.a(Unknown Source)
 at com.ca.clarity.jdbc.oracle.ddu.a(Unknown Source)
 at com.ca.clarity.jdbc.oracle.ddu.a(Unknown Source)
 at com.ca.clarity.jdbc.oracle.ddu.a(Unknown Source)
 at com.ca.clarity.jdbc.oracle.ddu.a(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.dddx.getObject(Unknown Source)
 at com.niku.union.persistence.utils.SQLUtils.extractValue(SQLUtils.java:111)
 at com.niku.union.persistence.utils.SQLUtils.extractValueAsObject(SQLUtils.java:204)
 at com.niku.union.persistence.results.DBRow.<init>(DBRow.java:46)
 at com.niku.union.persistence.results.DBResultResponse.createRow(DBResultResponse.java:111)
 at com.niku.union.persistence.PersistenceResponse.extractNormalResultSet(PersistenceResponse.java:200)
 at com.niku.union.persistence.PersistenceController.extractResultSet(PersistenceController.java:1942)
 at com.niku.union.persistence.PersistenceController.extractResultSets(PersistenceController.java:1995)
 at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3128)
 at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:892)
 at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:790)
 at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:592)
 at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:315)
 at com.niku.xql2.pmd.PMDRecordSet.executePMDStatement(PMDRecordSet.java:276)
 at com.niku.xql2.pmd.PMDRecordSet.<init>(PMDRecordSet.java:87)
 at com.niku.xql2.pmd.PMDDataSource.select(PMDDataSource.java:95)
 at com.niku.xql2.pmd.rules.INVInvestmentsRule.onPostUpdate(INVInvestmentsRule.java:462)
 at com.niku.xql2.odf.ODFRecord.update(ODFRecord.java:263)
 at com.niku.xql2.handlers.UpdateHandler.postProcess(UpdateHandler.java:103)
 at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1421)
 at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)
 at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)
 at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
 at com.niku.xql2.handlers.MatchHandler.preProcess(MatchHandler.java:129)
></Exception>
      </ErrorInformation>

Environment

Release : All Support clarity release 

 

Cause

Inadequate memory allocation 

Resolution

1- Edit the \bin\xog.bat file (from the XOG Client install folder)
2- Locate line: 
set PROGRAM_ARGS=%SSL_DEBUG_ARG% -Dfile.encoding=UTF-8 -Xmx512m -Dniku.home="%NIKU_HOME%" -Dforehead.conf.file="%NIKU_HOME%\bin\xog.forehead" com.werken.forehead.Forehead -installDir "%NIKU_HOME%" 
3- Change the value from -Xmx512m to a larger one (could try starting with -Xmx2048m).