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

book

Article ID: 6667

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

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>

screencap1.JPG

<Please see attached file for image>

screencap3JPG.JPG

 

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 

java.lang.NullPointerException 

 at com.jaspersoft.ji.adhoc.InteractiveCrosstabEngine.addMeasuresToCell(InteractiveCrosstabEngine.java:816) 

 at com.jaspersoft.ji.adhoc.InteractiveCrosstabEngine.generateViewModel(InteractiveCrosstabEngine.java:390) 

 at com.jaspersoft.ji.adhoc.action.AdhocAction.setReportModelInContext(AdhocAction.java:1523) 

 at com.jaspersoft.ji.adhoc.action.AdhocAction.view(AdhocAction.java:617) 

 at com.jaspersoft.ji.adhoc.action.AdhocAction.initForExistingReport(AdhocAction.java:504) 

 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) 

 

Cause

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

Environment

CA PPM 14.3 with Jaspersoft 6.2.1 onwards

Resolution

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:

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec1883794.html

Attachments

1558714674099000006667_sktwi1f5rjvs16ti8.jpeg get_app
1558714671822000006667_sktwi1f5rjvs16ti7.jpeg get_app