Getting error while importing accounts from AD

[TheSaviyntBoy]

Hi,

I am facing an issue while importing the accounts from AD. The connection is successful but the import job is failing with the error: 

Got Exception while performing ctx.search: javax.naming.NameNotFoundException: [LDAP: error code 32 - 0000208D: NameErr: DSID-0310028D, problem 2001 (NO_OBJECT), data 0

ACCOUNT_ATTRIBUTE:

[
CUSTOMPROPERTY1::cn#String,
CUSTOMPROPERTY30::userAccountControl#String,
CUSTOMPROPERTY2::userPrincipalName#String,
CUSTOMPROPERTY28::primaryGroupID#String,
LASTLOGONDATE::lastLogon#millisec,
DISPLAYNAME::name#String,
CUSTOMPROPERTY25::company#String,
CUSTOMPROPERTY20::employeeID#String,
CUSTOMPROPERTY3::sn#String,
COMMENTS::distinguishedName#String,
CUSTOMPROPERTY4::homeDirectory#String,
LASTPASSWORDCHANGE::pwdLastSet#millisec,
CUSTOMPROPERTY5::co#String,
CUSTOMPROPERTY6::employeeNumber#String,
CUSTOMPROPERTY7::givenName#String,
CUSTOMPROPERTY8::title#String,
CUSTOMPROPERTY9::telephoneNumber#String,
CUSTOMPROPERTY10::c#String,
DESCRIPTION::description#String,
CUSTOMPROPERTY11::uSNCreated#String,
VALIDTHROUGH::accountExpires#millisec,
CUSTOMPROPERTY12::logonCount#String,
CUSTOMPROPERTY13::physicalDeliveryOfficeName#String,
UPDATEDATE::whenChanged#date,
CUSTOMPROPERTY14::extensionAttribute1#String,
CUSTOMPROPERTY15::extensionAttribute2#String,
CUSTOMPROPERTY16::streetAddress#String,
CUSTOMPROPERTY17::mailNickname#String,
CUSTOMPROPERTY18::department#String,
CUSTOMPROPERTY19::countryCode#String,
NAME::sAMAccountName#String,
CUSTOMPROPERTY21::manager#String,
CUSTOMPROPERTY22::homePhone#String,
CUSTOMPROPERTY23::mobile#String,
CREATED_ON::whenCreated#date,
ACCOUNTCLASS::objectClass#String,
ACCOUNTID::objectGUID#Binary,
CUSTOMPROPERTY24::userAccountControl#String,
CUSTOMPROPERTY27::objectSid#Binary,
RECONCILATION_FIELD::CUSTOMPROPERTY26,
CUSTOMPROPERTY26::objectGUID#Binary,
CUSTOMPROPERTY29::st#String
]

SEARCHFILTER: OU=users,DC=domain,DC=local

OBJECTFILTER: (&(objectCategory=person)(objectClass=user)(sAMAccountName=svc*))

What can be causing this issue?

Thank you. 

[naveenss]

Hi @TheSaviyntBoy  can you pls share the full logs?

[TheSaviyntBoy]

Hi @naveenss,

Here are the logs. They are generated after the changes which were suggested by @Raghu 

Thank you

[Raghu]

try to change and check it below attributes

ACCOUNTID::sAMAccountName#String,
RECONCILATION_FIELD::CUSTOMPROPERTY26,
CUSTOMPROPERTY26::objectGUID#String

[TheSaviyntBoy]

Hi @Raghu,

Did the changes but it gave the same error.

Thank you

[SumathiSomala]

@TheSaviyntBoy try below mapping

name::sAMAccountName#String,
ACCOUNTID::objectGUID#Binary,
RECONCILATION_FIELD::ACCOUNTID,

[TheSaviyntBoy]

Hi @SumathiSomala 

Tried the suggestion but giving the same error. Maybe it was the issue of searchfilter, but I cross checked it.

[Raghu]

try below

SEARCHFILTER: DC=domain,DC=local and exiting use your first thread attribute's

[TheSaviyntBoy]

I tried with that search filter and it is working, so probably the issue is with "OU=Users"? Also what do you mean by "exiting use your first thread attribute's"?

Thank you

[Raghu · Accepted solution]

Anyway it is working means with DC=domain,DC=local , we are good,

ACCOUNT_ATTRIBUTE:

[
CUSTOMPROPERTY1::cn#String,
CUSTOMPROPERTY30::userAccountControl#String,
CUSTOMPROPERTY2::userPrincipalName#String,
CUSTOMPROPERTY28::primaryGroupID#String,
LASTLOGONDATE::lastLogon#millisec,
DISPLAYNAME::name#String,
CUSTOMPROPERTY25::company#String,
CUSTOMPROPERTY20::employeeID#String,
CUSTOMPROPERTY3::sn#String,
COMMENTS::distinguishedName#String,
CUSTOMPROPERTY4::homeDirectory#String,
LASTPASSWORDCHANGE::pwdLastSet#millisec,
CUSTOMPROPERTY5::co#String,
CUSTOMPROPERTY6::employeeNumber#String,
CUSTOMPROPERTY7::givenName#String,
CUSTOMPROPERTY8::title#String,
CUSTOMPROPERTY9::telephoneNumber#String,
CUSTOMPROPERTY10::c#String,
DESCRIPTION::description#String,
CUSTOMPROPERTY11::uSNCreated#String,
VALIDTHROUGH::accountExpires#millisec,
CUSTOMPROPERTY12::logonCount#String,
CUSTOMPROPERTY13::physicalDeliveryOfficeName#String,
UPDATEDATE::whenChanged#date,
CUSTOMPROPERTY14::extensionAttribute1#String,
CUSTOMPROPERTY15::extensionAttribute2#String,
CUSTOMPROPERTY16::streetAddress#String,
CUSTOMPROPERTY17::mailNickname#String,
CUSTOMPROPERTY18::department#String,
CUSTOMPROPERTY19::countryCode#String,
NAME::sAMAccountName#String,
CUSTOMPROPERTY21::manager#String,
CUSTOMPROPERTY22::homePhone#String,
CUSTOMPROPERTY23::mobile#String,
CREATED_ON::whenCreated#date,
ACCOUNTCLASS::objectClass#String,
ACCOUNTID::objectGUID#Binary,
CUSTOMPROPERTY24::userAccountControl#String,
CUSTOMPROPERTY27::objectSid#Binary,
RECONCILATION_FIELD::CUSTOMPROPERTY26,
CUSTOMPROPERTY26::objectGUID#Binary,
CUSTOMPROPERTY29::st#String
]

[TheSaviyntBoy]

There was an issue with the searchFilter as well as with the ACCOUNT_ATTRIBUTE mapping. Thank you. 

[rushikeshvartak]

Does attribute contains special character ?