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

Document ID : KB000006667
Last Modified Date : 14/02/2018
Show Technical Document Details

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 




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: