SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 15353: Filters used in IMPORTAD.SAS sample do not work with Active Directory 2003

DetailsHotfixAboutRate It

The sample program IMPORTAD.SAS that is used to import users from Active Directory will not work with Active Directory 2003.

The following messages may be displayed when running the IMPORTAD.SAS program:

   WARNING: No results found.
   filter=(&(name>='A')(name<='H')(objectClass=group))
   ERROR: Invalid handle specified.
   WARNING: No results found.
   filter=(&(name>='H')(name<='P')(objectClass=group))
   ERROR: Invalid handle specified.
   NOTE: The data set WORK.LDAPGRPS has 363 observations and 7 variables.
   NOTE: DATA statement used (Total process time):

The Active Directory 2003 servers do not accept filter syntax such as:

(&(name>='A')(name<='H')(objectClass=group))

These ERROR and WARNING messages are likely to occur when there are no instances of groups or IDs that will be captured by the filter statements. It is a requirement to have a valid handle before calling LDAPS_FREE.

The IMPORTAD.SAS sample was updated in SAS® 9.1.3 Service Pack 3 (SP3) to work around this limitation. The sample can be modified to fit specific Active Directory implementations.

Select 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 SystemSAS Metadata ServerMicrosoft Windows XP Professional9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows NT Workstation9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows Server 2003 Standard Edition9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows 2000 Server9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows 2000 Professional9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows 2000 Advanced Server9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows 2000 Datacenter Server9.1 TS1M39.1 TS1M3 SP3
* 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.