Clarity

 View Only
  • 1.  Anyone running into PPM v15.1 PMO install (admin content csk) failing due to Error Applying XOG: Failure occurred while applying resources/csk_roles.xml

    Posted Jan 11, 2017 09:42 AM

    Running the 'admin content csk' command to install the PMO add-on received a XOG Error

     

    1/10/17 12:27 PM (admin)  Applying resources/csk_roles.xml
    1/10/17 12:27 PM (admin) Error Applying XOG: Failure occurred while applying resources/csk_roles.xml
    1/10/17 12:27 PM (admin)  Check C:\niku\clarity\logs\content\xog\csk\resources/csk_roles_out.xml for errors
    1/10/17 12:27 PM (admin) Failed to install content pack. ID: csk
    C:\niku\clarity\META-INF\content\xog\csk\install.xml:240: exec returned: 2
     at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:643)
     at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:669)
     at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:495)

     

    The csk_roles_out.xml shows several column names; Developer, Project Manager, Test Engineer, Business Analyst, Architect, Network Engineer, Storage Architect, and DBA received ORA-01861: literal does not match format string 

     

    More info:

    Upgraded from 14.3 to 15.1 (no issues)

    Trying to activate 'New User Experience' UI. Documentation states the PMO add-on has to be installed.

    Current version of PMO running is csk_8.1_v2



  • 2.  Re: Anyone running into PPM v15.1 PMO install (admin content csk) failing due to Error Applying XOG: Failure occurred while applying resources/csk_roles.xml
    Best Answer

    Broadcom Employee
    Posted Jan 11, 2017 09:49 AM

    Hi Kenneth,

     

    Do you have the required NLS parameters set as per the Installation Guide on the Oracle database? Please check it out here:

    https://docops.ca.com/ca-ppm/15-1/en/installing-and-upgrading/set-up-the-ca-ppm-database

    Section Set the Required Oracle Database Parameters

    Especially make sure that The NLS_DATE_FORMAT should be set to the following, as per the documentation:

    YYYY-MM-DD HH24:MI:SS

     

    Once you do, go ahead and re-run the admin content csk command, and this should work.

     

     

    Hope this helps -Nika



  • 3.  Re: Anyone running into PPM v15.1 PMO install (admin content csk) failing due to Error Applying XOG: Failure occurred while applying resources/csk_roles.xml

    Broadcom Employee
    Posted Jan 11, 2017 10:19 AM

    Hi Kenneth,

     

    See the technical document below and it will help you to resolve 

     

    https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec581262.html 

     

    Regards

    Suman Pramanik 



  • 4.  Re: Anyone running into PPM v15.1 PMO install (admin content csk) failing due to Error Applying XOG: Failure occurred while applying resources/csk_roles.xml

    Posted Jan 11, 2017 11:38 AM

    Opened an internal ticket with our DBA. The NLS_DATE_FORMAT was incorrect for both the nls_instance_parameters and nls_session_parameters.

     

    Thanks for the help.

     

    I still need to rerun PMO add-on install to see if install ok.



  • 5.  Re: Anyone running into PPM v15.1 PMO install (admin content csk) failing due to Error Applying XOG: Failure occurred while applying resources/csk_roles.xml

    Posted Jan 12, 2017 12:46 PM

    OK. After DBAs made parameter change for the NLS_DATE_FORMAT the PMO install got past the resources/csk_roles.xml portion which is where the install previously failed.

    Now its getting

    ERROR 12-01 12:38:37,860 - NikuSRMProjectsRule.onValidateRecord(): Field SCHEDULE_START not set
    ERROR 2017-01-12 12:38:37,860 [main] niku.schedulers NikuSRMProjectsRule.onValidateRecord(): Field SCHEDULE_START not set
    ERROR 12-01 12:38:37,860 - Failure while evaluating "xogprojectapi($PROCESS,$OT_PROJECT,srcRecord.delete)" in expression "{xogprojectapi($PROCESS,$OT_PROJECT,srcRecord.delete)}"
    java.lang.Exception: Invalid expression xogprojectapi($PROCESS,$OT_PROJECT,srcRecord.delete): 101 : java.lang.Exception: Field SCHEDULE_START not set

     

    Suggestions?



  • 6.  Re: Anyone running into PPM v15.1 PMO install (admin content csk) failing due to Error Applying XOG: Failure occurred while applying resources/csk_roles.xml

    Broadcom Employee
    Posted Jan 12, 2017 01:33 PM

    Hi Kenneth

     

    It looks like it's trying to insert a file but this interferes with a Schedule Start field which seems to be set as required. Which is the exact file that has the issue, it's not in the error message above?

     

    Please try the following:

    1. Manually xog in the file that has the issue
      Here, some steps to help you with this just in case:
      a.Navigate to $clarity\xog-unzipped\bin
      Run the commands
      b. xog
      c.login admin/pwd@servername:port
      b.output C:\file_out.xml (change the path as needed)
      d.call C:\file.xml (change the filename and path as needed)

     2. Retry the PMO install again

     

    Hope this helps -Nika



  • 7.  Re: Anyone running into PPM v15.1 PMO install (admin content csk) failing due to Error Applying XOG: Failure occurred while applying resources/csk_roles.xml

    Posted Jan 13, 2017 11:51 AM

    After a few rounds of running manual XOGs for several files got the PMO to install. They all were having the same issue with the SCHEDULE_START not set.

     

    Thanks for the help.