Update Jaspersoft Parameter command is throwing Null Pointer exception

Products

• Clarity PPM On Premise

Issue/Introduction

admin update jasperParameters is throwing null pointer exception.

Failed to update: jasperParameters: null
Error occurred: java.lang.NullPointerException

With -verbose on we observe the below stack trace.

 at java.base/java.util.concurrent.ConcurrentHashMap.putVal(ConcurrentHashMap.java:1011)
 at java.base/java.util.concurrent.ConcurrentHashMap.put(ConcurrentHashMap.java:1006)
 at java.base/java.util.Properties.put(Properties.java:1340)
 at com.niku.reporting.jasper.ClarityJasperAdmin.populateDBProperties(ClarityJasperAdmin.java:2257)
 at com.niku.reporting.jasper.ClarityJasperAdmin.updateDWHAttrsForBeanDS(ClarityJasperAdmin.java:1721)
 at com.niku.reporting.jasper.ClarityJasperAdmin.updateUserProfileAttrsForBeanDS(ClarityJasperAdmin.java:2041)
 at com.niku.reporting.jasper.ClarityJasperAdmin.updateUserProfileAttrsForBeanDS(ClarityJasperAdmin.java:2010)
 at com.ca.clarity.union.jasper.util.JasperUtils.updateJasperParameters(JasperUtils.java:108)
 at com.ca.clarity.union.jasper.util.JasperUtils.updateJasperParameters(JasperUtils.java:76)
 at com.ca.clarity.union.jasper.util.JasperUtils.updateJasperParameters(JasperUtils.java:65)
 at com.niku.nsa.service.AdminManager.doUpdate(AdminManager.java:3822)
 at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:497)
 at com.niku.nsa.service.AdminManager.execute(AdminManager.java:202)
 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:62)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at com.werken.forehead.Forehead.run(Forehead.java:551)
 at com.werken.forehead.Forehead.main(Forehead.java:581)

 

Environment

Release : 16.0.3

Cause

This is caused in 16.0.3 when you configure Clarity with Oracle Database using a TNS format connection string along with Service Name

Resolution

1. Download Clarity ISO and extract install.jar

2. Under install-packages/16.0.3/ run the command jar -xf package.jar lib/

3. The above command will extract only the lib folder. Copy the union.jar from this folder and replace it in the Clarity Server where you've seen this issue.

4. Bounce the services and test the command again.

 

Note :- This issue is only observed in 16.0.3 and please perform the steps with caution after taking proper backups.