Slow Performance or OOM issue during PMO upgrade bootstrap
search cancel

Slow Performance or OOM issue during PMO upgrade bootstrap

book

Article ID: 136426

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

When running PMO upgrade with command:

admin content csk

The install is very slow on bootstrap

or

An error is thrown, usually during bootstrap:

8/28/19, 3:42 PM (admin) Loading registered objects for custom attribute bootstrap...
8/28/19, 3:42 PM (admin) Loading registered objects for object mappings bootstrap...
8/28/19, 3:43 PM (admin) Loading registered objects to bootstrap...
8/28/19, 3:43 PM (admin) Loading registered objects for view bootstrap...
8/28/19, 3:43 PM (admin) Loading registered objects for object action bootstrap...
8/28/19, 3:43 PM (admin) Loading registered objects for data warehouse attributes bootstrap...
8/28/19, 3:44 PM (admin) ERROR 28-08 15:44:29,050 - rollback exception
8/28/19, 3:44 PM (admin) java.lang.OutOfMemoryError: Java heap space
8/28/19, 3:44 PM (admin)     at com.niku.union.persistence.results.DBResultResponse.endResultSetExtraction(DBResultResponse.java:265)
8/28/19, 3:44 PM (admin)     at com.niku.union.persistence.PersistenceController.extractResultSet(PersistenceController.java:1855)
8/28/19, 3:44 PM (admin)     at com.niku.union.persistence.PersistenceController.extractResultSets(PersistenceController.java:1902)
8/28/19, 3:44 PM (admin)     at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2882)
8/28/19, 3:44 PM (admin)     at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:878)
8/28/19, 3:44 PM (admin)     at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:778)
8/28/19, 3:44 PM (admin)     at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:585)
8/28/19, 3:44 PM (admin)     at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:308)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.pmd.PMDRecordSet.executePMDStatement(PMDRecordSet.java:267)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.pmd.PMDRecordSet.<init>(PMDRecordSet.java:87)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.pmd.PMDDataSource.select(PMDDataSource.java:95)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.XQLVisitor.getObjectSet(XQLVisitor.java:866)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.XQLVisitor.getField(XQLVisitor.java:1478)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.eval.XQLPropertyNode.eval(XQLPropertyNode.java:92)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1084)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1058)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:115)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1383)
8/28/19, 3:44 PM (admin)     at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
8/28/19, 3:44 PM (admin)     at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
8/28/19, 3:44 PM (admin)     at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:388)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1383)
8/28/19, 3:44 PM (admin)     at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
8/28/19, 3:44 PM (admin)     at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
8/28/19, 3:44 PM (admin)     at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
8/28/19, 3:44 PM (admin)     at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
8/28/19, 3:44 PM (admin)     at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
8/28/19, 3:44 PM (admin)     at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)

Resolution

  1. Connect to the Clarity server in $clarity/bin
  2. In text editor: Open the admin.bat file for Windows, and admin(or admin.sh) for Linux
    • Look for the last line, it should look similar to this:
    • java -cp $CLASSPATH -Djava.net.preferIPv4Stack=$PREFERIPV4STACK -Dfile.encoding=UTF-8 -Xmx512m -Dniku.home="$NIKU_HOME" -Dforehead.conf.file="$NIKU_HOME/bin/admin.forehead" \
    • com.werken.forehead.Forehead -installDir "$NIKU_HOME" $@
  3. Change the -Xmx512m to -Xmx5120m (Ensuring your system has enough spare RAM)
  4. Save
  5. Run admin content csk

Additional Information

Note: this solution is also applicable for slow PMO install/upgrade