Problem Note 53320: Selecting the Analysis and Data tab displays the error "The Result Set type is invalid for the requested operation. SQL Error Code 187"
 |  |  |  |  |
In the SAS® Risk Dimensions® Project Editor, if you select Model ► Analysis and Data, the following Java exception can occur:
==================== MESSAGE KEY ========================
The Result Set type is invalid for the requested operation.
SQL Error Code 187
===========================================================
com.sas.rio.MVASQLException: The Result Set type is invalid for the requested
operation.
at com.sas.rio.MVAResultSet.absolute(MVAResultSet.java:537)
at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sas.analytics.jdbc.ResultSetProxy.invokeMethod(ResultSetProxy.java:77)
at com.sas.analytics.jdbc.ResultSetProxy.invoke(ResultSetProxy.java:53)
at com.sun.proxy.$Proxy2.absolute(Unknown Source)
at
com.sas.analytics.risk.c_midtier.models.iom.INameLists.getIndexInfo(INameLists.java:1166)
at
com.sas.analytics.risk.c_midtier.models.iom.INameLists.getIndexInfo(INameLists.java:1044)
at
com.sas.analytics.risk.c_midtier.models.iom.INameLists.getIndexInfo(INameLists.java:1001)
at
com.sas.analytics.risk.c_midtier.models.iom.INameLists.getNamesDescFromDataset(INameLists.java:962)
at
com.sas.analytics.risk.c_midtier.models.iom.INameLists.getNamesL(INameLists.java:919)
at
com.sas.analytics.risk.c_midtier.models.iom.INameLists.getNames(INameLists.java:900)
at
com.sas.analytics.risk.c_midtier.models.iom.INameLists.getNames(INameLists.java:894)
at
com.sas.analytics.risk.c_midtier.models.iom.INameLists.getPortfolioStatisticNames(INameLists.java:589)
at
com.sas.analytics.risk.c_midtier.models.iom.IEnvironmentRiskObjects.getPortfolioStatisticsNames(IEnvironmentRiskObjects.java:1432)
at
com.sas.analytics.risk.c_swing.components.ProjectEditorPrompt.createAnalysisTab(ProjectEditorPrompt.java:810)
at
com.sas.analytics.risk.c_swing.components.ProjectEditorPrompt.createAnalysisAndDataTab(ProjectEditorPrompt.java:2405)
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 | Windows 7 Enterprise x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 |
| Windows 7 Enterprise 32 bit | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2012 Std | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2012 R2 Std | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2012 Datacenter | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 R2 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows 8.1 Pro 32-bit | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows 8.1 Pro | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows 8.1 Enterprise x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows 8 Pro x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows 8 Pro 32-bit | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows 8 Enterprise x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft Windows 8 Enterprise 32-bit | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Microsoft® Windows® for x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Home Premium 32 bit | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Home Premium x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Professional 32 bit | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Professional x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Ultimate 32 bit | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Windows 7 Ultimate x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| 64-bit Enabled AIX | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| 64-bit Enabled Solaris | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| HP-UX IPF | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Linux for x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
| Solaris for x64 | 6.2_M1 | 6.3 | 9.4 TS1M1 | 9.4 TS1M1 | ||
A fix for this issue for SAS Risk Management for Banking 3.2_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R06.html#53320| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis SAS Reference ==> SQL |
| Date Modified: | 2014-07-09 05:10:31 |
| Date Created: | 2014-06-26 09:45:25 |