Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

AD Account import is skipping accounts in sub OUs

KasperT
New Contributor III
New Contributor III

Hi all,

I have configured Active Directory connection and when I run account import job, it is not importing accounts from sub OUs. The logs of the job shows much more accounts in numbers than I can validate from Accounts list.

Here are some log markings we found from Application logs (Only parts from the logs. Censored and cleaned data):

Account name 'accountnamehere' not found. Skipping

In multiple places inside ACCOUNTS: INSERT INTO ACCOUNTS SET it says this:

- status=1 ON DUPLICATE KEY UPDATE JOBID='jobidhere'

 

Anyone have any clue to what might cause this type of behavior?

I'm happy to provide more information about my implementation.

I understand that there is not much information to understand the issue, reason being my lack of Saviynt knowledge. I'm opening this post because we troubleshooted this issue with senior and could not find reason or solution.

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

Can you share your object filter & account mapping json


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Object filter:

(&(objectCategory=person)(objectClass=user))

Account attribute:

[
CUSTOMPROPERTY1::physicalDeliveryOfficeName#String,
CUSTOMPROPERTY2::department#String,
CUSTOMPROPERTY3::extensionAttribute5#String,
CUSTOMPROPERTY4::employeeID#String,
CUSTOMPROPERTY5::extensionAttribute2#Number,
CUSTOMPROPERTY6::givenName#String,
CUSTOMPROPERTY7::initials#String,
CUSTOMPROPERTY8::middleName#String,
CUSTOMPROPERTY9::sn#String,
CUSTOMPROPERTY10::extensionAttribute3#Number,
CUSTOMPROPERTY11::extensionAttribute4#String,
CUSTOMPROPERTY12::title#String,
CUSTOMPROPERTY13::userPrincipalName#String,
DISPLAYNAME::displayname#String,
CUSTOMPROPERTY14::cn#String,
CUSTOMPROPERTY15::name#String,
NAME::sAMAccountname#String,
CUSTOMPROPERTY16::mail#String,
CUSTOMPROPERTY17::extensionAttribute1#String,
CUSTOMPROPERTY18::division#String,
CUSTOMPROPERTY19::company#String,
CUSTOMPROPERTY20::telephoneNumber#String,
CUSTOMPROPERTY21::mobile#String,
CUSTOMPROPERTY22::otherMobile#String,
CUSTOMPROPERTY23::manager#String,
CUSTOMPROPERTY24::objectGUID#Binary,
CUSTOMPROPERTY25::userAccountControl#String,
ACCOUNTID::distinguishedName#String,
ACCOUNTCLASS::objectClass#String,
STATUS::userAccountControl#Number,
UPDATEDATE::whenChanged#date,
CREATED_ON::whenCreated#date,
LASTPASSWORDCHANGE::pwdLastSet#millisec,
LASTLOGONDATE::lastLogonTimestamp#millisec,
DESCRIPTION::description#String,
CUSTOMPROPERTY26::distinguishedName#String,
RECONCILATION_FIELD::CUSTOMPROPERTY24
]

Any idea what might cause this?

We have Freshdesk ticket open but we are not getting any answers from there either.

Does import status is success? 

Can you share logs? 

Run below check

select distinct status from accounts where endpointkey= 1111


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.