Customer not Found in modifyuserdatajson

[sandeepgudipudi]

Hi while iam importing users the user is not getting assigned to organization here is modifyuserdatajson. I have a organization with name ABC and iam hardcoding company name as 'ABC'

{
"ADDITIONALTABLES": {
"USERS": "SELECT USERKEY,companyname,customer FROM USERS",
"CUSTOMER": "SELECT CUSTOMERKEY, CUSTOMERNAME FROM customer"
},
"COMPUTEDCOLUMNS": [
"companyname",
"customer"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET companyname = 'ABC'",
"UPDATE NEWUSERDATA SET customer = 'ABC'"
]
}

[rushikeshvartak]

Pass customerkey 

[sandeepgudipudi]

its not working

{
"ADDITIONALTABLES": {
"USERS": "SELECT USERKEY,companyname,customer FROM USERS",
"CUSTOMER": "SELECT CUSTOMERKEY, CUSTOMERNAME FROM customer"
},
"COMPUTEDCOLUMNS": [
"companyname",
"customerkey"

],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET companyname = 'ABC'",
"UPDATE NEWUSERDATA SET customerkey = 6"
]
}

[rushikeshvartak]

Please share logs

[sandeepgudipudi]

attached logs

[This post has been edited by a Moderator to remove the logs as they contained PII. Please mask all sensitive information before sharing logs.]

[rushikeshvartak]

Share request id or line start number

[sandeepgudipudi]

one of the log has request based on username

[rushikeshvartak]

⚠️ Reminder: Mask possible PII such as employee names, email addresses, phone numbers, IP addresses, account details, company-specific URLs, and client names before sharing.⚠️

[sandeepgudipudi]

what it is mean by 'Share request id or line start number?

[rushikeshvartak]

Which request needs to be looked into logs? or share log line from which logs needs to be debugged

[sandeepgudipudi]

Search for the line that mentions "Customer not found'

[rushikeshvartak]

It seems other thread logs are provided here

⚠️ Reminder: Mask possible PII such as employee names, email addresses, phone numbers, IP addresses, account details, company-specific URLs, and client names before sharing.⚠️

[sandeepgudipudi]

Hi i provided the asked logs one log file is the full log history and other one is with specified username l. Here we are importing member of a group and it has only 1 record

[rushikeshvartak]

Please share screenshot where you are able to find customer not found keyword both files i could not locate. also remove emails. urls which are specific to client

[sandeepgudipudi]

here is the attached log again

2024-10-30T17:45:00.069+00:00

ecm-worker

services.ImportSAvDataUserService

quartzScheduler_Worker-8-nsfmk

DEBUG

Customer Not found for entry :

[This post has been edited by a Moderator to remove sensitive information.]

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/error-in-users-import-error-while-processing-data-...

"UPDATE NEWUSERDATA NU JOIN CURRENTCUSTOMER C ON NU.Orgunitid = C.CUSTOMERNAME SET NU.CUSTOMER= C.CUSTOMERNAME"

[sandeepgudipudi]

I tried this but how will this add the customer 'ABC'

[rushikeshvartak]

Add key of it

"UPDATE NEWUSERDATA SET customer = 6

[sandeepgudipudi]

I already tried passing key, Can you give me complete structure 

[rushikeshvartak]

{
"ADDITIONALTABLES": {
"USERS": "SELECT USERKEY,companyname,customer FROM USERS",
"CUSTOMER": "SELECT CUSTOMERKEY, CUSTOMERNAME FROM customer"
},
"COMPUTEDCOLUMNS": [
"companyname",
"customer"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET companyname = 'ABC'",
"UPDATE NEWUSERDATA SET customer = 6"
]
}

[sandeepgudipudi]

still not working, can you test in your environment

[rushikeshvartak]

Please share logs. Its working for me

[rushikeshvartak]

Use below code 

{
"ADDITIONALTABLES": {
"USERS": "SELECT USERKEY,customer FROM USERS",
"CUSTOMER": "SELECT CUSTOMERKEY, CUSTOMERNAME FROM customer"
},
"COMPUTEDCOLUMNS": [
"customer"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA SET customer = 'SSM_Vendor'"
]
}

Logger Keyword - ImportSAvDataUserService

[sandeepgudipudi]

Will this customer organization is going to update for existing user or newly onboarding user

its the same error in logs 

024-10-31T09:28:36-05:00-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-7-nsfmk-DEBUG-Customer Not found for entry : [, , , , null, , , , Guest, null, [], , null, , 2024-10-23T17:01:48Z, ABC, 6]

[rushikeshvartak]

Share customer with 6 key is avaiable 

[sandeepgudipudi]

6 key is  available