We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Same attributes not getting imported for all users || Salesforce

Vidhimehta
Regular Contributor
Regular Contributor

Hello All,

We have successfully connected Salesforce instance with Saviynt. However, the employee ID for all users is not getting imported. Out of around 4k users, only 1.2k are correctly mapping, for the remaining the employee ID is not imported and hence not mapped. 

Kindly help with the same. 

17 REPLIES 17

SumathiSomala
All-Star
All-Star

@Vidhimehta ,

Could you please share the ImportUserJSON and are you seeing error in logs?if yes please share the logs and Correlation rule which is configured at endpoint

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Hello Sumathi,

we have used the OTTB connector, so there is no import user json.

below is the log after running the job:

2023-09-26T16:15:05+05:30-ecm-worker----2023-09-26T10:45:05.174457603Z stdout F 2023-09-26 10:45:05,174 [quartzScheduler_Worker-4] DEBUG integration.ExternalConnectionCallService - Key=connectiontype Value=SalesForce
 
2023-09-26T16:03:40+05:30-ecm-worker----2023-09-26T10:33:40.483829878Z stdout F 5A00000C9SP0QAN, 0055A00000C9SPAQA3, 0055A00000C9SPKQA3, 0055A00000C9SPPQA3, 0055A00000C9SPUQA3, 0055A00000C9SPZQA3, 0055A00000C9SPeQAN, 0055A00000C9SPjQAN, 0055A00000C9SPyQAN, 0055A00000C9SQDQA3, 0055A00000C9SQcQAN, 0055A00000C9SS9QAN, 0055A00000C9SSEQA3, 0055A00000C9SSJQA3, 0055A00000C9SSTQA3, 0055A00000C9SSYQA3, 0055A00000C9SSdQAN, 0055A00000C9SSsQAN, 0055A00000C9ST2QAN, 0055A00000C9STMQA3, 0055A00000C9SgaQAF, 0055A00000C9SgfQAF, 0055A00000C9T6xQAF, 0055A00000C9TGiQAN, 0055A00000C9TTrQAN, 0055A00000C9UFgQAN, 0055A00000C9UFlQAN, 0055A00000C9UFvQAN, 0055A00000C9UHNQA3, 0055A00000C9USQQA3, 0055A00000C9UmBQAV, 0055A00000C9UmQQAV, 0055A00000C9VD2QAN, 0055A00000C9VDMQA3, 0055A00000C9VDvQAN, 0055A00000C9VFDQA3, 0055A00000C9VFIQA3, 0055A00000C9VFSQA3, 0055A00000C9VH4QAN, 0055A00000C9VIgQAN, 0055A00000C9VIqQAN, 0055A00000C9VQ6QAN, 0055A00000C9VQaQAN, 0055A00000C9VbEQAV, 0055A00000C9Vd0QAF, 0055A00000C9Vd5QAF, 0055A00000C9W6CQAV, 0055A00000C9W8SQAV, 0055A00000C9W8XQAV, 0055A00000C9W8cQAF, 0055A00000C9WIcQAN, 0055A00000C9X6SQAV, 0055A00000C9X6rQAF, 0055A00000C9X7kQAF, 0055A00000C9XNdQAN, 0055A00000C9XNxQAN, 0055A00000C9XO2QAN, 0055A00000C9XOMQA3, 0055A00000C9XOgQAN, 0055A00000C9XPeQAN, 0055A00000C9XPjQAN, 0055A00000C9XgVQAV, 0055A00000C9XmYQAV, 0055A00000C9XmnQAF, 0055A00000C9Xn2QAF, 0055A00000C9XnMQAV, 0055A00000C9YBxQAN, 0055A00000C9YC7QAN, 0055A00000C9YCCQA3, 0055A00000C9YCRQA3, 0055A00000C9YClQAN, 0055A00000C9YCqQAN, 0055A00000C9YD0QAN, 0055A00000C9YDKQA3, 0055A00000C9YJcQAN, 0055A00000C9YJmQAN, 0055A00000C9YNjQAN, 0055A00000C9YdhQAF, 0055A00000C9YepQAF, 0055A00000C9YjQQAV, 0055A00000C9YokQAF, 0055A00000C9YozQAF, 0055A00000C9Z94QAF, 0055A00000C9Z99QAF, 0055A00000C9ZAMQA3, 0055A00000C9ZAWQA3, 0055A00000C9ZIaQAN, 0055A00000C9ZssQAF, 0055A00000C9ZtWQAV, 0055A00000C9ZtbQAF, 0055A00000C9ZtlQAF, 0055A00000C9ZuAQAV, 0055A00000C9ZuFQAV, 0055A00000C9ZuKQAV, 0055A00000C9ZuUQAV, 0055A00000C9Zv8QAF, 0055A00000C9acqQAB, 0055A00000C9adoQAB, 0055A00000C9aemQAB, 0055A00000C9b7PQAR, 0055A00000C9bH0QAJ, 0055A00000C9bq0QAB, 0055A00000C9bqAQAR, 0055A00000C9d7bQAB, 0055A00000C9dFQQAZ, 0055A00000C9dFaQAJ, 0055A00000C9dFfQAJ, 0055A00000C9dRWQAZ, 0055A00000C9dT3QAJ, 0055A00000C9daYQAR, 0055A00000C9daiQAB, 0055A00000C9daxQAB, 0055A00000C9dctQAB, 0055A00000C9dd8QAB, 0055A00000C9dl7QAB, 0055A00000C9dlCQAR, 0055A00000C9dlHQAR, 0055A00000C9dlMQAR, 0055A00000C9dlRQAR, 0055A00000C9dllQAB, 0055A00000C9dlqQAB, 0055A00000C9dlvQAB, 0055A00000C9dmAQAR, 0055A00000C9ebDQAR, 0055A00000C9ecBQAR, 0055A00000C9ecVQAR, 0055A00000C9h26QAB, 0055A00000C9h2BQAR, 0055A00000C9i2gQAB, 0055A00000C9i3UQAR, 0055A00000C9iCRQAZ, 0055A00000C9iCgQAJ, 0055A00000C9iCqQAJ, 0055A00000C9iCvQAJ, 0055A00000C9iD5QAJ, 0055A00000C9iDAQAZ, 0055A00000C9iDPQAZ, 0055A00000C9iDUQAZ, 0055A00000C9iDeQAJ, 0055A00000C9iDjQAJ, 0055A00000C9iSeQAJ, 0055A00000C9iSoQAJ, 0055A00000C9iT8QAJ, 0055A00000C9iTDQAZ, 0055A00000C9iUaQAJ, 0055A00000C9iZQQAZ, 0055A00000C9jbSQAR, 0055A00000C9jwuQAB, 0055A00000C9jxEQAR, 0055A00000C9jzeQAB, 0055A00000C9kmCQAR, 0055A00000C9kpQQAR, 0055A00000C9lSSQAZ, 0055A00000C9ljxQAB, 0055A00000C9m34QAB, 0055A00000C9mElQAJ, 0055A00000C9n77QAB, 0055A00000C9n7HQAR, 0055A00000C9nIyQAJ, 0055A00000C9nJ3QAJ, 0055A00000C9nJXQAZ, 0055A00000C9nStQAJ, 0055A00000C9nT3QAJ, 0055A00000C9nTDQAZ, 0055A00000C9nTNQAZ, 0055A00000C9nThQAJ, 0055A00000C9nU1QAJ, 0055A00000C9nUQQAZ, 0055A00000C9nUVQAZ, 0055A00000C9nhUQAR, 0055A00000C9nhjQAB, 0055A00000C9ni3QAB, 0055A00000C9ntLQAR, 0055A00000C9ntQQAR, 0055A00000C9ntaQAB, 0055A00000C9ntfQAB, 0055A00000C9ntkQAB, 0055A00000C9ntpQAB, 0055A00000C9o0RQAR, 0055A00000C9ogwQAB, 0055A00000C9oiOQAR, 0055A00000C9okKQAR, 0055A00000C9orGQAR, 0055A00000C9orVQAR, 0055A00000C9oraQAB, 0055A00000C9pSqQAJ, 0055A00000C9pSvQAJ, 0055A00000C9pUIQAZ, 0055A00000C9pcHQAR, 0055A00000C9pcMQAR, 0055A00000C9pqOQAR, 0055A00000C9pqTQAR, 0055A00000C9pr2QAB, 0055A00000C9ptrQAB, 0055A00000C9qSDQAZ, 0055A00000C9qbjQAB, 0055A00000C9r0ZQAR, 0055A00000C9r0eQAB, 0055A00000C9r0oQAB, 0055A00000C9r0yQAB, 0055A00000C9r13QAB, 0055A00000C9r1hQAB, 0055A00000C9r1wQAB, 0055A00000C9r2BQAR, 0055A00000C9r2GQAR, 0055A00000C9r3dQAB, 0055A00000C9rAjQAJ, 0055A00000C9rn2QAB, 0055A00000C9rnCQAR, 0055A00000C9rnHQAR, 0055A00000C9s98QAB, 0055A00000C9sIPQAZ, 0055A00000C9sIUQAZ, 0055A00000C9sIeQAJ, 0055A00000C9sIjQAJ, 0055A00000C9sIoQAJ, 0055A00000C9sItQAJ, 0055A00000C9sIyQAJ, 0055A00000C9sJ3QAJ, 0055A00000C9sJ8QAJ, 0055A00000C9sJDQAZ, 0055A00000C9sJSQAZ, 0055A00000C9sJXQAZ, 0055A00000C9sJcQAJ, 0055A00000C9sJrQAJ, 0055A00000C9sJwQAJ, 0055A00000C9sK6QAJ, 0055A00000C9sKBQAZ, 0055A00000C9sKQQAZ, 0055A00000C9sKVQAZ, 0055A00000C9sKfQAJ, 0055A00000C9sKpQAJ, 0055A00000C9sKzQAJ, 0055A00000C9sL4QAJ, 0055A00000C9sLJQAZ, 0055A00000C9sLYQAZ, 0055A00000C9sLiQAJ, 0055A00000C9sLnQAJ, 0055A00000C9sLxQAJ, 0055A00000C9sM7QAJ, 0055A00000C9sMCQAZ, 0055A00000C9sMHQAZ, 0055A00000C9sMMQAZ, 0055A00000C9sMRQAZ, 0055A00000C9sMWQAZ, 0055A00000C9sMlQAJ, 0055A00000C9sMqQAJ, 0055A00000C9sMvQAJ, 0055A00000C9sN5QAJ, 0055A00000C9sNAQAZ, 0055A00000C9sNFQAZ, 0055A00000C9sNKQAZ, 0055A00000C9sNPQAZ, 0055A00000C9sNeQAJ, 0055A00000C9sTcQAJ, 0055A00000C9sTwQAJ, 0055A00000C9sU1QAJ, 0055A00000C9sUfQAJ, 0055A00000C9sUkQAJ, 0055A00000C9sUuQAJ, 0055A00000C9sV4QAJ, 0055A00000C9sopQAB, 0055A00000C9sozQAB, 0055A00000C9sp4QAB, 0055A00000C9spEQAR, 0055A00000C9spOQAR, 0055A00000C9spTQAR, 0055A00000C9spYQAR, 0055A00000C9ssSQAR, 0055A00000C9sshQAB, 0055A00000C9ssmQAB, 0055A00000C9stuQAB, 0055A00000C9tM3QAJ, 0055A00000C9tM8QAJ, 0055A00000C9tj2QAB, 0055A00000C9tj7QAB, 0055A00000C9tjCQAR, 0055A00000C9ttWQAR, 0055A00000C9ttlQAB, 0055A00000C9ttvQAB, 0055A00000C9tu5QAB, 0055A00000C9tuAQAR, 0055A00000C9tuFQAR, 0055A00000C9tuUQAR, 0055A00000C9tueQAB, 0055A00000C9tuoQAB, 0055A00000C9tv3QAB, 0055A00000C9tvcQAB, 0055A00000C9unyQAB, 0055A00000C9uo8QAB, 0055A00000C9uoIQAR, 0055A00000C9uomQAB, 0055A00000C9upVQAR, 0055A00000C9vsQQAR, 0055A00000C9vv0QAB, 0055A00000C9w07QAB, 0055A00000C9w13QAB, 0055A00000C9w18QAB, 0055A00000C9w2GQAR, 0055A00000C9w2uQAB, 0055A00000C9w34QAB, 0055A00000C9w55QAB, 0055A00000C9wZdQAJ, 0055A00000C9wZnQAJ, 0055A00000C9wZsQAJ, 0055A00000C9we9QAB, 0055A00000C9x26QAB, 0055A00000C9y5aQAB, 0055A00000C9yD0QAJ, 0055A00000C9yRlQAJ, 0055A00000C9yS0QAJ, 0055A00000C9yS5QAJ, 0055A00000C9ySZQAZ, 0055A00000C9yd3QAB, 0055A00000C9yeaQAB, 0055A00000C9yekQAB, 0055A00000C9ygRQAR, 0055A00000C9yqbQAB, 0055A000009lJZcQAM, 0055A00000BsYQ6QAN, 0055A00000BsYRJQA3, 0055A00000BsYROQA3], isApiSuccess:true, jobHistoryMap:[Job-Type:full, Import-Type:accounts, Existing-Accounts:4396, Accounts-Retrieved-From-SalesForce:4396, New-Account-Added:0, Existing-Account-Updated:4396, Accounts-Activated:0, Accounts-Inactivated:0], statusColumn:customproperty12, activeStatus:[true], inactiveStatus:null, deleteLinks:true, correlateInactiveAccounts:null, inactivateAccountsNotInFile:null, setReferenceAccountNull:null, lockedStatusColumn:customproperty22, lockedStatusMapping:[Locked:[1], Unlocked:[0]], inactiveAccountSet:[], actionableAccountsList:[]]
 
2023-09-26T16:02:51+05:30-ecm-worker----2023-09-26T10:32:50.586266343Z stdout F "Salesforce CRM Content User": "UserPermissionsSFContentUser"
 
2023-09-26T16:02:51+05:30-ecm-worker----2023-09-26T10:32:50.58653485Z stdout F 2023-09-26 10:32:50,586 [quartzScheduler_Worker-3] DEBUG integration.ExternalConnectionCallService - Key=connectiontype Value=SalesForce
 
2023-09-26T16:02:51+05:30-ecm-worker----2023-09-26T10:32:50.621423358Z stdout F 2023-09-26 10:32:50,621 [quartzScheduler_Worker-3] DEBUG services.HttpClientUtilityService - connectionType: SalesForce
 
2023-09-26T16:00:05+05:30-ecm-worker----2023-09-26T10:30:05.333157903Z stdout F 2023-09-26 10:30:05,332 [quartzScheduler_Worker-9] DEBUG integration.ExternalConnectionCallService - Key=connectiontype Value=SalesForce

below is the correlation rule:

Vidhimehta_0-1695725782513.png

 

kindly note, we havent changed any details, the same is updating 1.2k users to accounts but for the remaining, custom property 45 is not getting imported.

@Vidhimehta is all 4396 accounts have employee ID in Salesforce instance?

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Vidhimehta
Regular Contributor
Regular Contributor

yes all the accounts have the employee ID in Salesforce.

@Vidhimehta 

Could you please the ACCOUNT_FIELD_QUERY,FIELD_MAPPING_JSON ,STATUS_THRESHOLD_CONFIG parameters

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Hello @SumathiSomala,

Below details:

Account field query:

Id, Username, LastName, FirstName, Name, CompanyName, Email, IsActive, UserRoleId, ProfileId, UserType, ManagerId, LastLoginDate,LastPasswordChangeDate, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, ContactId, AccountId, FederationIdentifier, UserPermissionsSupportUser,Fortive_ID__C

Field Mapping JSon:

{"accountfield_mapping":{
"accountID":"Id~#~char",
"name":"Username~#~char",
"customproperty2":"LastName~#~char",
"customproperty1":"FirstName~#~char",
"displayName":"Name~#~char",
"customproperty3":"CompanyName~#~char",
"customproperty4":"Email~#~char",
"status":"IsActive~#~bool",
"customproperty12":"IsActive~#~bool",
"customproperty5":"UserRoleId~#~char",
"customproperty6":"ProfileId~#~char",
"accounttype":"UserType~#~char",
"customproperty7":"ManagerId~#~char",
"lastlogondate":"LastLoginDate~#~date",
"lastpasswordchange":"LastPasswordChangeDate~#~date",
"CREATED_ON":"CreatedDate~#~date",
"creator":"CreatedById~#~char",
"customproperty8":"LastModifiedDate~#~date",
"updateUser":"LastModifiedById~#~char",
"updatedate":"SystemModstamp~#~date",
"customproperty9":"ContactId~#~char",
"customproperty10":"AccountId~#~char",
"customproperty13":"FederationIdentifier~#~char",
"customproperty20":"UserPermissionsSupportUser~#~bool",
"customproperty21":"featureLicense~#~char",
"customproperty45":"Fortive_ID__C~#~char"
},
"profilefield_mapping": {
"entitlementID": "Id~#~char",
"entitlement_value": "Name~#~char",
"customproperty4": "UserLicenseId~#~char",
"customproperty1": "UserType~#~char",
"description": "Description~#~char",
"customproperty7": "CreatedDate~#~date",
"customproperty8": "CreatedById~#~char",
"customproperty2": "LastModifiedDate~#~date",
"customproperty9": "LastModifiedById~#~char",
"updatedate": "SystemModstamp~#~date"
}
}

Status Threshold Configuration:

{"statusAndThresholdConfig":{"accountThresholdValue":100,"statusColumn":"customproperty12","activeStatus":["true"],"deleteLinks":true,"lockedStatusColumn":"customproperty22","lockedStatusMapping":{"Locked":["1"],"Unlocked":["0"]}}}

@Vidhimehta all configs are seems to be correct.

Sometimes data truncations may occur.

Could you please increase the accountThresholdValue and run the account import job


{"statusAndThresholdConfig":{"accountThresholdValue":100,"statusColumn":"customproperty12","activeStatus":["true"],"deleteLinks":true,"lockedStatusColumn":"customproperty22","lockedStatusMapping":{"Locked":["1"],"Unlocked":["0"]}}}

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Hello @SumathiSomala,

We tried to increase the threshold to 299, still facing the same issue. 

@Vidhimehta can you confirm if the other attributes of the impacted accounts are getting imported successfully? Is the issue occurring only with employee id attribute for the impacted accounts?

Vidhimehta
Regular Contributor
Regular Contributor

Hi @Dhruv_S 

Now the attributes are getting imported however the user correlation is not mapping all the active accounts to the users. the correlation rule uses the Fortive ID which is mapped to custom property 45. we have done the same for another instance and it is showing correct data.

 

@Vidhimehta ,

Thanks for the update. Please confirm if the original issue of employee id not getting imported is resolved. If you share the solution of the original issue, it will be helpful for others future such issues.

Regarding the account correlation issue, I can see from the screenshot that you are co-relating username attribute with custom property 45. However it should be mapped with Fortive ID as per your above comments. Please check once and confirm.


Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.

Vidhimehta
Regular Contributor
Regular Contributor

@Dhruv_S 

the data got imported itself, not sure what had changed so cant provide an exact solution. 

about the correlation, it is correct as the username is the Fortive ID and custom property 45 is mapped to Fortive ID in the application user data table. 

kindly check if you can help on why all accounts are not getting correlated.

Hi @Vidhimehta , could you please open an Freshservice ticket along with details like logs, rule details screenshot. Support team will assist you further.

Link:-https://saviyntsupport.saviynt.com

Regards,

Dhruv Sharma

Vidhimehta
Regular Contributor
Regular Contributor

@Dhruv_S 

my profile shows as restricted requestor and am not able to raise the request. please do help on the same.

 

regards,

Vidhi

Please reach out to CSM/TAM /Saviynt support team. They will raise a FD ticket on your behalf.

Vidhimehta
Regular Contributor
Regular Contributor

@Dhruv_S y

Kindly share the contact for the respective team to raise the ticket.

Hi Vidhi, please email me directly and I will request Fresh Service access for you in order to open tickets.

Thanks!