SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 48044: The Lightweight Directory Access Protocol is not supported with in-database procedures

DetailsHotfixAboutRate It

When you use the Lightweight Directory Access Protocol (LDAP) with Base SAS® procedures that are using in-database processing, an error similar to the following might occur:

ERROR: Error during in-database processing.
WARNING: Error during in-database processing.
NOTE: There were 19 observations read from the data set TEST.classjerry.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           0.37 seconds
      cpu time            0.12 seconds


ERROR: General error The UserId, Password or Account is invalid.

When you use the LDAP, the LIBNAME statement requires the use of the "at" sign (@) in the user name. Using the "@" in the user name causes in-database procedures to fail when the string is passed from the engine to the driver.

To work around this issue, do not use LDAP when you use in-database processing with procedures.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASAster Data nCluster on Linux x649.3 TS1M1
DB2 Universal Database on AIX9.3 TS1M1
DB2 Universal Database on Linux x649.3 TS1M1
Greenplum on Linux x649.3 TS1M1
Netezza TwinFin 32bit blade9.3 TS1M1
Netezza TwinFin 32-bit SMP Hosts9.3 TS1M1
Netezza TwinFin 64-bit S-Blades9.3 TS1M1
Netezza TwinFin 64-bit SMP Hosts9.3 TS1M1
Teradata on Linux9.3 TS1M1
z/OS9.3 TS1M1
Z649.3 TS1M1
Microsoft® Windows® for x649.3 TS1M1
Microsoft Windows Server 2003 Datacenter Edition9.3 TS1M1
Microsoft Windows Server 2003 Enterprise Edition9.3 TS1M1
Microsoft Windows Server 2003 Standard Edition9.3 TS1M1
Microsoft Windows Server 2003 for x649.3 TS1M1
Microsoft Windows Server 20089.3 TS1M1
Microsoft Windows Server 2008 for x649.3 TS1M1
Microsoft Windows XP Professional9.3 TS1M1
Windows 7 Enterprise 32 bit9.3 TS1M1
Windows 7 Enterprise x649.3 TS1M1
Windows 7 Home Premium 32 bit9.3 TS1M1
Windows 7 Home Premium x649.3 TS1M1
Windows 7 Professional 32 bit9.3 TS1M1
Windows 7 Professional x649.3 TS1M1
Windows 7 Ultimate 32 bit9.3 TS1M1
Windows 7 Ultimate x649.3 TS1M1
Windows Vista9.3 TS1M1
Windows Vista for x649.3 TS1M1
64-bit Enabled AIX9.3 TS1M1
64-bit Enabled HP-UX9.3 TS1M1
64-bit Enabled Solaris9.3 TS1M1
HP-UX IPF9.3 TS1M1
Linux9.3 TS1M1
Linux for x649.3 TS1M1
Solaris for x649.3 TS1M1
* 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.