AnsweredAssumed Answered

Getting error in PMO Accelerator 3.3 installations in CA Clarity 14.2

Question asked by Anant_Raj_89 on Sep 15, 2015
Latest reply on Sep 15, 2015 by nick_darlington

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)

Outcomes