pdm_ldap_import fails with parse error when pdm_ldap_test works.

Products

• CA Service Desk Manager

Issue/Introduction

When the following command is ran, it returns data:

pdm_ldap_test -f "(objectclass=user)(division=xxxx)"

But when we use the below command it errors:

pdm_ldap_import -l "(objectclass=user)(division=xxxx)":

pdm_ldap_import: Method got_record in Ldap_Catcher failed (AHD03053:Bad where clause: Parse error at : "ldap_domain = '' AND (objectclass=user)(division=xxxx)" (Attr not found or not atomic))

Environment

CA Service Desk Manager 17.x.

Resolution

Let's note that the commands here are not using -n because they were run for a single domain. You may use -n if you have multiple domains.

Try removing the parenthesis and make sure the -l (the where clause) is not ambiguous. 

Start from a much more simple example, such as the ldap_db that you have defined in your GUI domain settings.

For example, in this case try tested the following instead:

pdm_ldap_import -l "userid = '111111'"

Then try:

pdm_ldap_import -l "division = 'xxxx'"

And then try the following:

pdm_ldap_import -l "division = 'xxxx' AND memberOf = 'CN=xxxxxx,OU=User Management,OU=xxxxxxxx,DC=xxxxxxxx,DC=local'"

So even if the "test" is working you may need to simplify your where clause and get this working without any parse errors.