Architecting, installing and maintaining your SAS environment

Error while retrieving Active Directory Users

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

Error while retrieving Active Directory Users

Hi Community,

 

When I'm trying to retrieve the users from the Active Directory, I'm getting the following error, where as the output is returning me 1 record with empty data in all the columns.

 

filter=(&(&(displayName>=O)(displayName<=Q))  (distinguishedName=*)  )
ERROR: LDAP server operations error.  ERROR: LDAP server reports additionally: 000020D6: SvcErr: DSID-031007DB, problem 5012 (DIR_ER
ROR), data 0

 Attached is the code, plz refer that and guide me.

 

The code is sample code of "importad.sas"

 

Kind Regards

Balraj

 


Accepted Solutions
Solution
‎04-07-2016 07:10 AM
Super User
Posts: 7,863

Re: Error while retrieving Active Directory Users

By entering the codes of your error message

000020D6: SvcErr: DSID-031007DB, problem 5012 (DIR_ERROR)

in google, I found https://communities.bmc.com/thread/52803?tstart=0 which has the exact same message and a possible solution.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎04-07-2016 07:10 AM
Super User
Posts: 7,863

Re: Error while retrieving Active Directory Users

By entering the codes of your error message

000020D6: SvcErr: DSID-031007DB, problem 5012 (DIR_ERROR)

in google, I found https://communities.bmc.com/thread/52803?tstart=0 which has the exact same message and a possible solution.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Frequent Contributor
Posts: 80

Re: Error while retrieving Active Directory Users

Posted in reply to KurtBremser

Hi @KurtBremser, awesome. It worked. Now i'm getting this warnings and returning 0 records.

WARNING: No results found.
filter=(&(&(displayName>=E)(displayName<=G))  (distinguishedName=*)  )
WARNING: No results found.
filter=(&(&(displayName>=G)(displayName<=I))  (distinguishedName=*)  )

Please guide me

 

Kind Regards

Balraj

Super User
Posts: 7,863

Re: Error while retrieving Active Directory Users

Have not had to synchronize with LDAP yet, so I don't know where these messages might originate. One reason could be that your LDAP parameters (base DN and so on) don't point at the right spot in your LDAP directory strcuture, so no items are found. Check with your LDAP administrator.

And: the LDAP admin can turn on tracing on the LDAP server so (s)he can watch which queries you send to it.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
PROC Star
Posts: 1,167

Re: Error while retrieving Active Directory Users

I had to do this a few years ago.

 

What I found is that the SAS code provided is more of a "guideline", in that there are a tremendous number of ways to set up Active Directory. The provided SAS code demonstrates how it can work, but the fields and comparison values might be quite different.

 

Also, at the point when I was doing it, Active Directory got quite grumpy when asked to return a large number of results, and didn't do anything.

 

What I did was to use PowerShell to explore the Active Directory environment, understand what all of my quries had to be, etc. Then migrating those queries into SAS wasn't too bad. Even with that, it was a frustrating excercise.

 

Hope this helps,

  Tom

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1209 views
  • 5 likes
  • 3 in conversation