Problem Note 37720: SAS® Web Report Studio report fails to open if any data item in the information map does not have a default aggregation specified
When you display a report in SAS Web Report Studio, you might see an error message that is similar to the following:
Missing report element
An error occurred in processing the report element. Please refresh the page to try again. Contact your administrator if this problem persists.
[a12573501530360.20852686736019155_0_0] Error Rendering the Report
When you view details, one of the following root causes will likely display:
Root Cause: java.lang.NullPointerException
at com.sas.report.render.util.IqDataWrapper.getMeasureResultItemsWithFunctions(IqDataWrapper.java:96)
at com.sas.report.render.optimizer.models.DefaultChildQueryAnalyzer.collectDataItemToFunctionNameIds(DefaultChildQueryAnalyzer.java:174)
at com.sas.report.render.optimizer.models.DefaultChildQueryAnalyzer.canAggregateOnParentWithoutSplitDataItems(DefaultChildQueryAnalyzer.java:103)
at com.sas.report.render.optimizer.models.DefaultOptimizationDataModel.canAggregateOnParentWithoutSplitDataItems(DefaultOptimizationDataModel.java:640)
Root Cause: java.lang.NullPointerException
at com.sas.report.render.optimizer.models.collections.DefaultDataItemMapper.getParentItem(DefaultDataItemMapper.java:156)
at com.sas.report.render.optimizer.models.collections.DefaultDataItemMapper.getOptimizedDataItem(DefaultDataItemMapper.java:125)
at com.sas.report.render.optimizer.models.collections.DefaultDataItemMapper.getOptimizedDataItem(DefaultDataItemMapper.java:117)
at com.sas.report.render.optimizer.util.ExpressionResolverUtil.findInAddedResultItems(ExpressionResolverUtil.java:757)
This error can appear for promoted reports and for new reports if the multi-edit feature is used to change data item properties in the information map.
As a workaround, follow these steps:
- In SAS Information Map Studio, open the information map.
- Open the properties for each data item. Do not use the multi-edit feature.
- For measures, and make sure that the Default aggregate function has a value.
- For categories, make sure that COUNT(argument) is displayed (but grayed-out) in the Default aggregate function list.
If it is not, then select the Measure radio button and then switch back to Category. COUNT(argument) should now be filled in.
- Save the information map.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Change in behavior from release 3.1
The behavior in SAS Web Report Studio 3.1 is different, which means that reports that rendered correctly in 3.1 might not render after promotion. SAS Web Report Studio 3.1 does not fail if the default aggregation method is not filled in.
Operating System and Release Information
SAS System | SAS Web Report Studio | Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
z/OS | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
64-bit Enabled AIX | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
64-bit Enabled Solaris | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
HP-UX IPF | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Linux for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Solaris for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
SAS System | SAS Information Map Studio | Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Topic: | Query and Reporting ==> Interactive Querying Query and Reporting Data Management ==> Data Sources ==> Information map
|
Date Modified: | 2009-11-04 11:11:18 |
Date Created: | 2009-11-04 10:39:22 |