and more in a single search tool across platforms. Read the announcement here. |
09/06/2022 06:29 AM
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.
09/06/2022 07:54 AM
Can you share your object filter & account mapping json
09/07/2022 12:16 AM
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
]
09/26/2022 04:17 AM
Any idea what might cause this?
We have Freshdesk ticket open but we are not getting any answers from there either.
09/26/2022 05:39 AM - edited 09/26/2022 07:09 AM
Does import status is success?
Can you share logs?
Run below check
select distinct status from accounts where endpointkey= 1111