AnsweredAssumed Answered

Unable to install PMO Accelerator in v15.5 (Required for New user Experience)

Question asked by varun.chopra.2 on Oct 10, 2018
Latest reply on Oct 17, 2018 by varun.chopra.2

Hi,

 

We have recently upgraded Clarity ppm from v14.4 to v15.5 successfully. But when installing PMO Accelerator (clarity/bin> admin content csk). It throws few error messages. do anyone have idea about it?

 

-------------------------------------------------------------------------------

ERROR 09-10 05:39:40,226 - Problem creating object or updating custom object table for object fiscaltimeperiod
10/9/18 5:39 AM (admin) com.niku.union.persistence.PersistenceException:
10/9/18 5:39 AM (admin) SQL error code: 2264
10/9/18 5:39 AM (admin) Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-02264: name already used by an existing constraint
10/9/18 5:39 AM (admin) Executed:
10/9/18 5:39 AM (admin) alter table ODF_CA_FISCALTIMEPERIOD add constraint ODF_CA_FISCALTIMEPERIOD_pk primary key ( id ) using index tablespace INDX_LARGE
10/9/18 5:39 AM (admin) Derived from statement:
10/9/18 5:39 AM (admin) <?xml version="1.0" encoding="UTF-8"?>
10/9/18 5:39 AM (admin) <statement location="unionPMD.xml" id="union.dynamicSQL" 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">
10/9/18 5:39 AM (admin) <sql dbVendor="all">
10/9/18 5:39 AM (admin) <text>@dynamic@</text>
10/9/18 5:39 AM (admin) <param direction="IN" dynamicReplacement="@dynamic@" expressionListDelimiter=","/>
10/9/18 5:39 AM (admin) </sql>

------------------------------------------------------------------------------

10/9/18 5:59 AM (admin) ERROR 09-10 05:59:11,110 - Database Error thrown
10/9/18 5:59 AM (admin) com.niku.union.persistence.PersistenceException:
10/9/18 5:59 AM (admin) SQL error code: 4098
10/9/18 5:59 AM (admin) Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04098: trigger 'NIKU.NOK_SRM_ADD_CALENDAR_LINK' is invalid and failed re-validation

-------------------------------------------------------------------------------------

10/9/18 5:59 AM (admin) <statementRef id="xog.insertCmnUserSRMResource_nested_0" inputSource="map" inputMapIndex="0" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" defaultSliceSize="20" ignoreIfError="false" hideResultSets="false" xmlns="http://schemas.niku.com/2002/pmd"/>
10/9/18 5:59 AM (admin) Using input:
10/9/18 5:59 AM (admin) {lastName=Admin, isExternal=0, resType=0, externalId=csk.admin, fullName=Admin, PMO, isActive=1, userId=5515000, firstName=PMO, uniqueName=csk.admin, execute::batch=false, parameterSet=[], externalSourceID=1, id=5524001, visitor=com.niku.xql2.XQLVisitor@71fac822, personType=300, parameters=[null:id:5524001:, null:lastName:Admin:, null:firstName:PMO:, null:uniqueName:csk.admin:, null:email:admin@mailserver.com:, null:personType:300:, null:isActive:1:, null:isExternal:0:, null:externalSourceID:1:, null:externalId:csk.admin:, null:resType:0:, null:userId:5515000:, null:fullName:Admin, PMO:], value=xog.insertCmnUserSRMResource, email=admin@mailserver.com}
10/9/18 5:59 AM (admin) at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2100)
10/9/18 5:59 AM (admin) at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2204)
10/9/18 5:59 AM (admin) at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2881)
10/9/18 5:59 AM (admin) at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:869)
10/9/18 5:59 AM (admin) at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:769)
10/9/18 5:59 AM (admin) at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:577)
10/9/18 5:59 AM (admin) at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:307)
10/9/18 5:59 AM (admin) at com.niku.xql2.pmd.PMDDataSource.execute(PMDDataSource.java:214)

---------------------------------------------------------------------------

10/9/18 5:59 AM (admin) Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04098: trigger 'NIKU.NOK_SRM_ADD_CALENDAR_LINK' is invalid and failed re-validation
10/9/18 5:59 AM (admin) at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
10/9/18 5:59 AM (admin) at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
10/9/18 5:59 AM (admin) at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)

---------------------------------------------------------------------

Error Applying XOG: Failure occurred while applying users/csk_admin.xml
10/9/18 5:59 AM (admin) Check E:\Clarity\logs\content\xog\csk\users/csk_admin_out.xml for errors
10/9/18 5:59 AM (admin) Failed to install content pack. ID: csk
E:\Clarity\META-INF\content\xog\csk\install.xml:242: exec returned: 2

Outcomes