search cancel

Clarity Upgrade 16.0.3 to 16.1.0 Fails with Error Applying IMPORT_STAGING_DATA_JOB.xml

book

Article ID: 255336

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Upgrading from 16.0.3 to 16.1.0 fails while applying IMPORT_STAGING_DATA_JOB.xml

Steps to Reproduce: 

  • Have a system with 16.0.3 with PMO accelerator installed
  • Stop all the services
  • Start the upgrade to 16.1 

Expected Results: The upgrade should be successful without any error 

Actual Results: The upgrade fails with below error 

12/3/22, 1:11 AM (admin)           Applying IMPORT_STAGING_DATA_JOB.xml
12/3/22, 1:11 AM (admin) Error Applying XOG: Failure occurred while applying IMPORT_STAGING_DATA_JOB.xml
12/3/22, 1:11 AM (admin)  Check /opt/ppm/logs/IMPORT_STAGING_DATA_JOB_out.xml for errors
12/3/22, 1:11 AM (admin) ERROR: Upgrade failed for tenant  
 
The IMPORT_STAGING_DATA_JOB_out.xml has the below information 
 
            <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>XOG-3300: Job Definition record has not been inserted java.lang.NullPointerException
    at com.niku.odf.ori.service.BoViewService.getModifiedViewAttribute(BoViewService.java:94)
    at com.niku.odf.ori.xblhandlers.EntityHandler.modifyBusinessObject(EntityHandler.java:203)
    at com.niku.odf.ori.xblhandlers.EntityHandler.processOdfRequest(EntityHandler.java:120)
    at com.niku.odf.ori.xblhandlers.EntityHandler.postProcess(EntityHandler.java:57)
    at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1423)
    at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:217)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:97)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:54)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:388)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1389)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:201)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:77)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:95)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:54)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:388)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1389)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:201)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:77)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:54)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:388)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1389)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:201)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:77)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:54)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:388)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1389)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:201)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:77)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:54)
    at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:54)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1389)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:201)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:77)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:95)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:95)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:39)
    at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:261)
    at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:168)
    at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:180)
    at com.niku.xog.client.XOGAdminClient.processDoc(XOGAdminClient.java:1182)
    at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:918)
    at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:679)
    at com.niku.xog.client.XOGAdminClient.execute(XOGAdminClient.java:562)
    at com.niku.xog.client.XOGAdminClient.main(XOGAdminClient.java:268)</Description>
        <Exception>

Environment

Release : 16.1.0

Cause

DE67615 

 

Resolution

The DE67615 is in review with engineering and till its fixed follow the below workaround in order to upgrade 

Workaround:

  • Rolled back to 16.0.3, reinstall CSK again (admin content csk)  after stopping all the clarity service
  • Post CSK Installation, check the job definition by running the below query and 1 record should exist
    • SELECT * FROM CMN_SCH_JOB_DEFINITIONS where job_code = 'IMPORT_STAGING_DATA'
  • Re Run the upgrade provided the job definition exists, if the job definition doesn't exist contact Broadcom Support