Problem Note 48472: The message "Error in the LIBNAME statement" appears in SAS® Data Integration Studio jobs that use the SCD Type 2 Loader transformation
 |  |  |  |  |
SAS Data Integration Studio jobs using the SCD Type 2 Loader transformation might fail with the following error:
ERROR: Error in the LIBNAME statement
This error occurs when the following conditions are true:
- The SCD Type 2 Loader transformation output table is a database management system (DBMS) table.
- Under the Database Options section on the Options tab in the SCD Type 2 Loader properties dialog box, the Use SQL PassThru option is set to Yes.
- The target DBMS supports the DBMSTEMP=YES LIBNAME statement option.
- The DBMS library definition that is associated with the target table has one or more options defined that contain a semicolon (for example, a semicolon that is used in the INIT_STRING= option of an OLE DB LIBNAME statement).
The error is the result of an incorrect substitution of the semicolon that is set in options when you allocate the library ETLSTMP for the storage of temporary table in the DBMS environment.
Currently, there is no solution or workaround for this error.
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 Data Integration Studio | Microsoft® Windows® for x64 | 4.2 | 4.4 | 9.2 TS2M0 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.4 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.4 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.4 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.4 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.4 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP Professional | 4.2 | 4.4 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Windows Vista | 4.2 | 4.4 | 9.2 TS2M0 | 9.3 TS1M1 | ||
| Windows Vista for x64 | 4.2 | 4.4 | 9.2 TS2M0 | 9.3 TS1M1 | ||
A fix for this issue for SAS Data Integration Studio 4.21_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B51.html#48472| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-11-21 10:29:05 |
| Date Created: | 2012-11-15 09:03:48 |