Problem Note 36784: Some tables do not display results if the section query contains more than 31 categories
 |  |  |  |
In SAS Web Report Studio, if the section query contains more than 31 category data items from a relational information map, then some tables might not display. In the Edit view, the tables appear with a yellow warning sign.
Crosstabulation tables
For crosstabulation tables with more than 19 categories assigned to columns or to rows, you might see this error message inside of a box:
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.
If you view details, the following additional information is displayed:
[a12559785725100.1380565352551576_0_0] Error Rendering the Report 20 Root Cause: java.lang.ArrayIndexOutOfBoundsException: 20 at com.sas.servlet.tbeans.olaptableview.html.OLAPTableView.writeRowHeader(OLAPTableView.java:1078) at com.sas.servlet.tbeans.olaptableview.html.OLAPTableView.writeRows(OLAPTableView.java:1027) at com.sas.servlet.tbeans.tableview.AbstractBaseTableView.writeContent(AbstractBaseTableView.java:1715)
If you have fewer than 20 categories assigned to columns or to rows, the table will probably display, but it will contain the following message:
Assign one or more Category data items to rows to complete this table.
As a workaround, use the Select Data dialog box to remove all but 31 categories from the section query. If you are are using release 4.2_M2 or later, then you should be able to hide the extra categories in the table to resolve the issue.
List tables with totals
For list tables with totals, you might see the following error message inside of a box.
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.
If you view details, the following additional information is displayed:
[a12602184559260.7731711390773568_1_0] Error Rendering the Report startColumn must be > 0 Root Cause: java.lang.IllegalArgumentException: startColumn must be > 0 at com.sas.swing.visuals.tableview.TableFormatArea.setStartColumn(TableFormatArea.java:110) at com.sas.swing.visuals.tableview.TableFormatArea.(TableFormatArea.java:28) at com.sas.swing.visuals.tableview.TableViewUtil.setValuesOnMap(TableViewUtil.java:130)
As a workaround, you can delete the table and then recreate it without the totals, or you can use the Select Data dialog box to remove all but 31 categories from the section query. If you are are using release 4.2_M2 or later, then you should be able to hide the extra categories in the table to resolve the issue.
List tables with percent of total calculations
For list tables with percent of total calculations, you might see the following error message inside of a table.
Missing Data Item Assign one or more data items to complete this table.
As a workaround, you can delete the table and then recreate it without the percent of total calculation, or you can use the Select Data dialog box to remove all but 31 categories from the section query. If you are are using release 4.2_M2 or later, then you should be able to hide the extra categories in the table to resolve the issue.
List tables without added calculations (promoted reports only)
For plain list tables, you might see the following error message inside of a table if the report was promoted from version 3.1.
Missing Data Item Assign one or more data items to complete this table.
This issue will likely resolve itself when you close and then reopen the report. Otherwise, as a workaround, open the Assign Data dialog box, hide one data item, and then immediately add it back to columns. The table should now be valid and render results correctly.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | 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 Server 2003 Datacenter 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 Standard Edition | 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 | ||
| Type: | Problem Note |
| Priority: | high |
| Topic: | System Administration ==> Migration Query and Reporting ==> Interactive Querying Query and Reporting |
| Date Modified: | 2009-10-19 15:41:55 |
| Date Created: | 2009-08-07 11:50:38 |