Content Add-In Installer fails post upgrade to 15.9.3

book

Article ID: 222089

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The Install Content Add-In fails after upgrading to 15.9.3. You are unable to import / install the package. 

STEPS TO REPRODUCE: 

  1. In Classic, go to Administration, Studio: Content Add-In 
  2. Upload a prepared Studio Content Manager Package file 

Expected Results: The process completes successfully to upload the package as expected. 

Actual Results: The BG Log and execution of Install Content Add-In Job contains errors 

java.lang.NumberFormatException: Error parsing number <attribute dataType
 at com.niku.union.utility.DataFormatUtil.parseNumber(DataFormatUtil.java:262)
 at com.niku.union.utility.DataFormatUtil.parseLong(DataFormatUtil.java:115)
 at com.ca.clarity.cms.addin.jobs.BaseContentAddInJobUtility.getContentAddInIdFromJobParams(BaseContentAddInJobUtility.java:228)
 at com.ca.clarity.cms.addin.jobs.BaseContentAddInJobUtility.init(BaseContentAddInJobUtility.java:63)
 at com.ca.clarity.cms.addin.jobs.ContentAddInInstaller.scheduledEventFired(ContentAddInInstaller.java:41)
 at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:746)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at java.base/java.lang.Thread.run(Thread.java:829)

Cause

Caused by DE62068

Environment

Release: 15.9.3

Resolution

This issue is fixed in:

  • Clarity 16.0
  • 15.9.3 pre-patch 1 for GCP only
  • 15.9.3 Patch 1 for On Premise.

Workaround: On Premise Only

  1. Stop the services
  2. Execute the update statement below (based on your database type)
  3. Restart the services

Oracle

update cmn_attributes 
set default_value='<attribute dataType="string" name="content_addin_id" referencedObjectId="PENDING_CONTENT_ADDINS_LOOKUP" referencedObjectCardinality="1" isActive="true" defaultValue="" isRequired="false" operation="add" xmlns="http://schemas.niku.com/2002/odf"><data/></attribute>'
where referenced_object_id = 'PENDING_CONTENT_ADDINS_LOOKUP'
and column_name = 'content_addin_id'


SQL Server

update cmn_attributes 
set default_value='<attribute dataType="string" name="content_addin_id" referencedObjectId="PENDING_CONTENT_ADDINS_LOOKUP" referencedObjectCardinality="1" isActive="true" defaultValue="" isRequired="false" operation="add" xmlns="http://schemas.niku.com/2002/odf"><data/></attribute>'
where referenced_object_id = 'PENDING_CONTENT_ADDINS_LOOKUP'
and column_name = 'content_addin_id'


PostgreSql

update cmn_attributes 
set default_value=E'<attribute dataType=\"string\" name=\"content_addin_id\" referencedObjectId=\"PENDING_CONTENT_ADDINS_LOOKUP\" referencedObjectCardinality=\"1\" isActive=\"true\" defaultValue=\"\" isRequired=\"false\" operation=\"add\" xmlns=\"http://schemas.niku.com/2002/odf\"><data/></attribute>'
where referenced_object_id = 'PENDING_CONTENT_ADDINS_LOOKUP'
and column_name = 'content_addin_id'

Additional Information

See also: Clarity frequently reported issues