Problem Note 44077: Reports are empty in the SAS® Risk Dimensions® GUI
 |  |  |  |  |
In the Results drop-down list on the Analysis tab of the SAS Risk Dimensions GUI, you might encounter reports that contain no results. The System tab of the SAS® Log window might display messages like the following when you view the reports:
Skipping index: 0 child: com.sas.analytics.risk.c_swing.util.ObjectSearchTreeLeaf@2b79ef
An error occured during SQL processing . Dumping libs for reference.
FAILED: executeQuery class java.lang.String:SELECT VAR, VAR_L, VAR_U, VARPCT, VARPCT_L, VARPCT_U,
NINST, NREP, N, NMISS, NADJUST, MEAN, STD, SKEWNESS, KURTOSIS, MIN, MEDIAN, MAX FROM RES_NUM.SIMSTAT WHERE
( RESULTNAME = ' 1. analysis-name: 1. P/L ' ) AND variable-value
Data Query Failed.
SELECT VAR, VAR_L, VAR_U, VARPCT, VARPCT_L, VARPCT_U, NINST, NREP, N, NMISS, NADJUST, MEAN, STD, SKEWNESS,
KURTOSIS, MIN, MEDIAN, MAX FROM RES_NUM.SIMSTAT WHERE ( RESULTNAME = ' 1. analysis-name: 1. P/L ' )
AND variable-value
Unable to execute query: SQL passthru expression contained these errors: ERROR: Expression using equals (=)
has components that are of different data types.
java.sql.SQLException: Data Query Failed.
SELECT VAR, VAR_L, VAR_U, VARPCT, VARPCT_L, VARPCT_U, NINST, NREP, N, NMISS, NADJUST, MEAN, STD, SKEWNESS,
KURTOSIS, MIN, MEDIAN, MAX FROM RES_NUM.SIMSTAT WHERE ( RESULTNAME = ' 1. analysis-name: 1. P/L ' )
AND variable-value
Unable to execute query: SQL passthru expression contained these errors: ERROR: Expression using equals (=)
has components that are of different data types.
at com.sas.rio.MVALocalizedError.throwLocalizedException(MVALocalizedError.java:196)
at com.sas.rio.MVAStatement.executeQuery(MVAStatement.java:583)
at com.sas.analytics.risk.c_midtier.util.JDBCConnectionProxy$JDBCStatementProxy.executeQuery
(JDBCConnectionProxy.java:246)
...
This problem is known to occur when you specify a numeric-type variable as a cross classification.
As a workaround, use character variables for cross classifications, instead of numeric variables.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Risk Dimensions Enterprise Edition | Microsoft® Windows® for x64 | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 5.3_M1 | 5.31 | 9.2 TS2M3 | 9.3 TS1M0 | ||
A fix for this issue for Risk Dimensions Offering 5.31 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I51.html#44077A fix for this issue for SAS Risk Dimensions Server Component 5.3_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/F03.html#44077A fix for this issue for Risk Dimensions 5.3_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/F04.html#44077A fix for this issue for SAS Risk Management for Insurance 2.1_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/F90.html#44077| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-07-01 09:43:50 |
| Date Created: | 2011-08-23 12:21:09 |