Usage Note 17289: "java.lang.IllegalArgumentException: Unable to open data set: WORK.VIEW0"
 |  |  |  |  |
When creating a query in SAS Human Captial Management 3.1 (HCM), if you define a filter that is based on a column generated with a SUBSTR function, you may experience the following error message:
"java.lang.IllegalArgumentException:
Unable to open data set: WORK.VIEW0"
It is important to make sure that when creating calculated columns with the SUBSTR function, that the new column be defined as "character" in the query properties page.
Select 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 Human Capital Management | Microsoft Windows NT Workstation | 3.1 | |||
| Solaris | 3.1 | |||||
| Microsoft Windows 2000 Professional | 3.1 | |||||
| 64-bit Enabled Solaris | 3.1 | |||||
| HP-UX | 3.1 | |||||
| 64-bit Enabled HP-UX | 3.1 | |||||
| AIX | 3.1 | |||||
| 64-bit Enabled AIX | 3.1 | |||||
A fix for this issue for HR Vision 3.1 is available at:
http://www.sas.com/techsup/download/hotfix/hr_vision31.html#017289| Type: | Usage Note |
| Priority: | medium |
| Date Modified: | 2006-03-30 09:08:38 |
| Date Created: | 2006-03-17 16:02:08 |