Clarity Upgrade error - JasperDomainAttribute.getAttributeType()" is null

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Clarity upgrade to 16.4.1 fails with error:

/25/26, 10:03 PM (admin) Updating Domains to have customizations... 
2/25/26, 10:03 PM (admin) Updating Dynamic attributes..
2/25/26, 10:03 PM (admin) Updating Dynamic attributes..
2/25/26, 10:03 PM (admin) Error while updating dynamic domains.. Cannot invoke "String.equals(Object)" because the return value of "com.ca.clarity.etl.kettle.JasperDomainAttribute.getAttributeType()" is null
2/25/26, 10:03 PM (admin) Failed to import content for tenant  
java.lang.NullPointerException: Cannot invoke "String.equals(Object)" because the return value of "com.ca.clarity.etl.kettle.JasperDomainAttribute.getAttributeType()" is null
    at com.ca.clarity.etl.kettle.JasperSoftDomainUpdates.getAttributesForDomainUpdates(JasperSoftDomainUpdates.java:689)
    at com.ca.clarity.etl.kettle.JasperSoftDomainUpdates.processDomainAddedAttributes(JasperSoftDomainUpdates.java:277)
    at com.ca.clarity.etl.kettle.JasperSoftDomainUpdates.dynamicDomainUpdates(JasperSoftDomainUpdates.java:176)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateDynamicDomains(ClarityJasperAdmin.java:1056)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateDomains(ClarityJasperAdmin.java:1039)
    at com.niku.reporting.jasper.ClarityJasperAdmin.jasperContent(ClarityJasperAdmin.java:867)
    at com.niku.reporting.jasper.importexport.JasperContentCommand.execute(JasperContentCommand.java:192)
    at com.niku.reporting.jasper.ClarityJasperAdmin.executeCommand(ClarityJasperAdmin.java:3832)
    at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:322)
    at com.niku.nsa.service.AdminManager.execute(AdminManager.java:204)
    at com.niku.nsa.service.Admin.main(Admin.java:78)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:569)
    at com.werken.forehead.Forehead.run(Forehead.java:551)
    at com.werken.forehead.Forehead.main(Forehead.java:581)

Environment

All Supported Clarity releases

Resolution

1. To see which attributes cause the issue, run the query: 

SELECT object_code, attribute_code, dwh_table_name, attr_type, js_processed
FROM dwh_meta_columns
WHERE js_processed = 0
  AND is_deleted = 0
  AND attr_type IS NULL
  AND object_code IS NOT NULL
  AND attribute_code IS NOT NULL;

2. Review to understand what attr_type needs to be and update accordingly (example) 

update dwh_meta_columns
set attr_type = 'string' 
where attribute_code =XXXXXX