03/14/2023 07:00 AM
Hi ,
We are importing accounts, job is failed below are the logs :
"ecm-worker","2023-03-14T13:43:13.020+00:00","{"log":"2023-03-14 13:43:12,169 [quartzScheduler_Worker-1] DEBUG services.ImportUtilityService - Exception in getNonActiveAccountsToBeDisabled: \n","stream":"stdout","time":"2023-03-14T13:43:12.169672519Z"}" "ecm-worker","2023-03-14T13:43:13.020+00:00","{"log":"groovy.lang.MissingMethodException: No signature of method: static org.apache.commons.collections.CollectionUtils.isNotEmpty() is applicable for argument types: (java.lang.Boolean) values: [true]\n","stream":"stdout","time":"2023-03-14T13:43:12.169680563Z"}" "ecm-worker","2023-03-14T13:43:13.020+00:00","{"log":"Possible solutions: isNotEmpty(java.util.Collection), isEmpty(java.util.Collection)\n","stream":"stdout","time":"2023-03-14T13:43:12.169683343Z"}"
any inputs on the above issue ?
03/17/2023 09:37 AM
Can you share the Import JSON that you are using
03/17/2023 09:50 AM
Salesforce default connector - importing done internally there is no importjson instead
please find below
FIELD_MAPPING_JSON
~~~~~~~~~~~~~~~~~~~~~~
{ "accountfield_mapping": { "accountID": "Id~#~char", "name": "Username~#~char", "customproperty2": "LastName~#~char", "customproperty1": "FirstName~#~char", "displayName": "Name~#~char", "customproperty4": "Email~#~char", "status": "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", "customproperty13": "FederationIdentifier~#~char", "customproperty23": "CommunityNickname~#~char" }, "permissionsetfield_mapping": { "entitlementID": "Id~#~char", "entitlement_value": "Name~#~char", "customproperty2": "LastModifiedDate~#~date", "customproperty4": "UserLicenseId~#~char", "customproperty7": "CreatedDate~#~date", "customproperty8": "CreatedById~#~char", "customproperty9": "LastModifiedById~#~char", "customproperty18": "UserType~#~char", "customproperty19": "SystemModstamp~#~date" }, "profilefield_mapping": { "entitlementID": "Id~#~char", "entitlement_value": "Name~#~char", "customproperty2": "LastModifiedDate~#~date", "customproperty4": "UserLicenseId~#~char", "customproperty7": "CreatedDate~#~date", "customproperty8": "CreatedById~#~char", "customproperty9": "LastModifiedById~#~char", "customproperty18": "UserType~#~char", "customproperty19": "SystemModstamp~#~date" } }
03/17/2023 10:09 AM
Sorry for the typo, I meant the import Field mapping. Can you also share the STATUS_THRESHOLD_CONFIG you have defined.
Though it appears you may need to open a Support ticket for this but I want to verify the STATUS_THRESHOLD_CONFIG you have defined.
03/17/2023 10:13 AM
PFB
{ "statusAndThresholdConfig": { "accountThresholdValue": 1000, "correlateInactiveAccounts": "true", "statusColumn": "customproperty10", "activeStatus": true, "deleteLinks": true, "lockedStatusColumn": "customproperty22", "lockedStatusMapping": { "Locked": [ "1" ], "Unlocked": [ "0" ] } } }
03/17/2023 10:36 AM - edited 03/17/2023 10:37 AM
Can you update the STATUS_THRESHOLD_CONFIG with below value instead and try
"correlateInactiveAccounts": true,
"activeStatus": [
"true"
],
Also adding the salesforce connector guide link for reference