Clarity

 View Only
Expand all | Collapse all

Getting error in PMO Accelerator 3.3 installations in CA Clarity 14.2

  • 1.  Getting error in PMO Accelerator 3.3 installations in CA Clarity 14.2

    Posted Sep 15, 2015 08:55 AM

    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)

    Attachment(s)

    zip
    PMO_Info.txt.zip   4 KB 1 version


  • 2.  Re: Getting error in PMO Accelerator 3.3 installations in CA Clarity 14.2

    Posted Sep 15, 2015 09:57 AM

    Strictly speaking, the constraint is occurring on the ACTION_CODE column of that table, meaning that a record already exists with a value in that column of 'odf.custom.customSection' and it is objecting to trying to insert another one.

     

    However the root cause behind that cannot be determined from that error message alone and this would be a good candidate for opening a support ticket so that the state of your environment can be more closely inspected before a solution can be proposed.  If you already have a ticket open, please share or send me the ticket number if you do not mind.  Thanks.