Problem Note 38078: Generating metadata for character variables fails when you use the SQL procedure against a SAS® Scalable Performance Data Server® database
 |  |  |  |  |
Generating metadata for character variables using the SAS® Customer Intelligence Information Map Metadata Generation Plug-in for SAS® Management Console with PROC SQL might fail if the underlying data is held in a SAS Scalable Performance Data Server database instance. An error similar to the following occurs in the SAS® Stored Process Server log:
NOTE: Implicit SQL: select table0.RANDBIN as RANDBIN_1, COUNT (distinct table1.subject1) as COUNT1 from xxxx table1 inner join yyyy table2 on table1.subject2 = table2.subject2 inner join zzzz table0 on table2.subject2 = table0.subject2 group by table0.RANDBIN_1 SPDS_ERROR: Column RANDBIN_1 could not be found in the table identified with the correlation name table0. SPDS_ERROR: SQL passthru expression contained errors.
To work around this problem, choose the SUMMARY procedure to generate metadata rather than PROC SQL.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Plug-ins for SAS Management Console | Microsoft Windows Server 2003 for x64 | 9.2 TS2M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Windows Vista | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Windows Vista for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.2 TS2M2 | ||
| HP-UX IPF | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Linux for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Solaris for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.2 TS2M2 | ||
A fix for this issue for Base SAS 9.21_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A50.html#38078| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-12-10 10:54:44 |
| Date Created: | 2009-12-08 16:05:48 |