Usage Note 12706: The query View Results feature may have problems with joins and/or
filters
In SAS Human Capital Management 3.1 (HCM, HRV, HR Vision) you might
experience a problem viewing a query with the View Results feature for
queries containing Joins and Filters. The following may appear:
Error: The query did not execute successfully. Please contact your
administrator for assistance. SAS was unable to build the table
containing the results of this query.
The SAS Log would contain an error like the following:
ERROR: The following columns were not found in the contributing
tables: EDATE1.
message=ERROR: SQL View WORK.QTB774080 could not be processed.
returnRC=1
A Technical Support hot fix for this issue is available at:
http://www.sas.com/techsup/download/hotfix/hr_vision31.html#012706
Operating System and Release Information
| SAS System | SAS Human Capital Management | Microsoft Windows 2000 Professional | 3.1 | | | |
| Microsoft Windows NT Workstation | 3.1 | | | |
| HP-UX | 3.1 | | | |
| 64-bit Enabled Solaris | 3.1 | | | |
| Solaris | 3.1 | | | |
| 64-bit Enabled HP-UX | 3.1 | | | |
| AIX | 3.1 | | | |
| 64-bit Enabled AIX | 3.1 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | medium |
| Date Modified: | 2004-07-12 16:12:50 |
| Date Created: | 2004-06-25 15:58:40 |
