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

Document ID:  TEC1457253
Last Modified Date:  08/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA PPM

Releases

  • CA PPM:Release:14.2
  • CA PPM:Release:14.2 On Demand
  • CA PPM:Release:14.2 On Premise
  • CA PPM:Release:14.3
  • CA PPM:Release:14.3 On Demand
  • CA PPM:Release:14.3 On Premise
  • CA PPM:Release:14.4
  • CA PPM:Release:15.1

Components

  • CA PPM SAAS JASPERSOFT INTERNAL ONLY:ODJSP
Issue:

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 

screencap1.JPG

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) 

 

Environment:
CA PPM 14.3 with Jaspersoft 6.2.1 onwards
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

Workaround:

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://support.ca.com/us/knowledge-base-articles.tec1883794.html

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >