Problem Note 48339: "Error: java.lang.RuntimeException...ORA-01795" message when logging on to SAS® Enterprise Case Management
 |  |  |  |  |
If you use Oracle as your Shared Services database, and you are a member of more than one thousand metadata groups, then you cannot log on to SAS Enterprise Case Management. When you try to log on, the following error message is displayed:
Error: java.lang.RuntimeException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/sas/solutions/casemgmt/dao/sql/Search.xml. --- The error occurred while applying a parameter map. --- Check the getOrderedRecordKeys-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
The only workaround to this problem is to redesign your user security model so that users do not belong to more than one thousand metadata groups.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Case Management | Microsoft® Windows® for x64 | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 |
| Microsoft Windows Server 2003 Datacenter Edition | 2.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 2.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 2.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 for x64 | 2.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Microsoft Windows XP Professional | 2.3 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise 32 bit | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Windows 7 Professional 32 bit | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Windows Vista | 2.3 | 9.2 TS2M3 | ||||
| Windows Vista for x64 | 2.3 | 9.2 TS2M3 | ||||
| 64-bit Enabled AIX | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| HP-UX IPF | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Linux for x64 | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
| Solaris for x64 | 2.3 | 6.3_M1 | 9.2 TS2M3 | 9.4 TS1M4 | ||
A fix for this issue for SAS Middle Tier 9.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M92.html#48339A fix for this issue for SAS Management Console 9.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M93.html#48339| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-01-16 11:28:35 |
| Date Created: | 2012-10-31 12:32:30 |