Content Add-In Installer fails post upgrade to 15.9.3

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:

In Classic, go to Administration, Studio: Content Add-In
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)

Environment

Release: 15.9.3

Cause

DE62068

Resolution

Fixed in Release 16.0.0
Fixed in Release 15.9.3 Patch #1 (15.9.3.1)

Workaround: On Premise Only

Stop the services
Execute the update statement below (based on your database type)
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

Reference 16.0.0 Clarity Release Notes > Resolved Defects
Reference 15.9.3 Clarity and Jaspersoft Cumulative Patch README Files