search cancel

CA PPM Advance Reporting Cross Tab Adhoc Views are corrupted with Null Pointer Exception


Article ID: 6667


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


Advance Reporting Cross Tab Adhoc Views are getting corrupted in Advanced reporting views for users when the values of previously saved filters are changed. When User tries to Open previously saved Adhoc View it is throwing Null pointer exception error on the page.


Steps to Replicate: 

1. Create a new Adhoc view with any domain (example: Resource Management Domain )

2. Select Resource Name, investment name, Month Start Date from Calendar Periods, Available hours’ measure 

3. Create a cross tab adhoc view by adding investment name to rows, month start date & Available Hours to Columns 

4. Add Investment name to Filter and select any Project which displays data and apply filter 

5. Right Click on Month Start Date and delete Column Summary (This Step is Key as all the views with no Column Summary are having this issue) 

6. Save Adhoc View with the results 

7. Now change the name of the investment in CA PPM which is used in the filter 

8. Run Load Data warehouse job in CA PPM to update investment name in DWH Schema 

9. And navigate to Advanced Reporting and navigate to saved Adhoc view 

10. Try to Open Adhoc view and you will get alert 

<Please see attached file for image>


<Please see attached file for image>



Expected Results: The Cross tab Adhoc view should open 

Actual Results: The Cross tab Adhoc view throws error 


Jaspersoft log:

2017-04-26 06:54:33,159 ERROR AdhocAction,http-apr-8080-exec-6:621 [EMEA152|admin] - exception initializing ad hoc 


 at com.jaspersoft.ji.adhoc.InteractiveCrosstabEngine.addMeasuresToCell( 

 at com.jaspersoft.ji.adhoc.InteractiveCrosstabEngine.generateViewModel( 

 at com.jaspersoft.ji.adhoc.action.AdhocAction.setReportModelInContext( 

 at com.jaspersoft.ji.adhoc.action.AdhocAction.view( 

 at com.jaspersoft.ji.adhoc.action.AdhocAction.initForExistingReport( 

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 

 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 

 at java.lang.reflect.Method.invoke(Unknown Source) 



CA PPM 14.3 with Jaspersoft 6.2.1 onwards


This is a know bug of Jaspersoft JS-32658 and CA PPM Engineering team is working with Jaspersoft to get it fixed. CA PPM team is also tracking this under DE33934


Don't place the filter on the Cross Tab Adhoc view and show the sample data and create a filter prompt on the report

Additional Information

Please be aware of further knowledge on the Advanced Reporting area:


1558714674099000006667_sktwi1f5rjvs16ti8.jpeg get_app
1558714671822000006667_sktwi1f5rjvs16ti7.jpeg get_app