Hi All,
We are getting belown shown error while installing PMO Accelerator 3.3 (Please find the whole error log and XOG log attached from admin side attached)
Applying objects/costplan.xml
Applying objects/costplandetail.xml
Applying menus/application_odf_cop_idea_prj_mapList.xml
ERROR 15-09 14:01:26,252 - Database Error thrown
com.niku.union.persistence.PersistenceException:
SQL error code: 1
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (CLARITY.CMN_ACTIONS_U1) violated
Executed:
INSERT INTO CMN_ACTIONS
( ID, ACTION_CODE, ALIAS_CODE ,PAGE_ID,TARGET,
IS_SYSTEM, IS_ACTIVE, IS_SSL_ENABLED,
PRINCIPAL_TYPE, PRINCIPAL_ID,
CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
VALUES
( ?, ?, ?, ?, ?,
?, ?, ?,
?, ?,
?, ?, ?, ?)
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="menus/menuItem.xml" id="npt.addMenuAction" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
<sql dbVendor="all">
<text>
INSERT INTO CMN_ACTIONS
( ID, ACTION_CODE, ALIAS_CODE ,PAGE_ID,TARGET,
IS_SYSTEM, IS_ACTIVE, IS_SSL_ENABLED,
PRINCIPAL_TYPE, PRINCIPAL_ID,
CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
VALUES
( ?, ?, ?, ?, ?,
?, ?, ?,
?, ?,
?, ?, ?, ?)
</text>
<param name="actionId" type="long" direction="IN" expressionListDelimiter=","/>
<param name="actionCode" type="string" direction="IN" expressionListDelimiter=","/>
<param name="aliasCode" type="string" direction="IN" expressionListDelimiter=","/>
<param type="long" direction="IN" constantValue="0" expressionListDelimiter=","/>
<param name="target" type="string" direction="IN" expressionListDelimiter=","/>
<param type="long" direction="IN" constantValue="0" expressionListDelimiter=","/>
<param type="long" direction="IN" constantValue="0" expressionListDelimiter=","/>
<param type="long" direction="IN" constantValue="0" expressionListDelimiter=","/>
<param name="principaltype" type="string" direction="IN" expressionListDelimiter=","/>
<param name="principalId" type="long" direction="IN" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param replace="userId" direction="IN" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param replace="userId" direction="IN" expressionListDelimiter=","/>
</sql>
</statement>
Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="npt.addMenuAction" inputSource="map" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/>
Using input:
{actionCode=odf.custom.customSection, principalId=0, name=addMenuAction, principaltype=SYSTEM, value=npt.addMenuAction, actionId=5174211, parameters=[null:actionId:5174211:, null:actionCode:odf.custom.customSection:, null:principalId:0:, null:principaltype:SYSTEM:], parameterSet=[], visitor=com.niku.xql2.XQLVisitor@13a35906}
at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2084)
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2188)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2818)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:867)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:767)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:575)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:305)
at com.niku.xql2.pmd.PMDDataSource.execute(PMDDataSource.java:204)
at com.niku.xql2.handlers.ExecuteHandler.postProcess(ExecuteHandler.java:90)
at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1419)
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.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:54)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)