Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/10/2024 08:03 AM
When importing Salesforce Access it is failing due to the following error:
Error in getResultId | Cannot get property 'result' on null object |
Due to the above error I believe it is also what is causing issues with provisioning new users.
Error in creating user = Erro |
See logs attached
07/10/2024 08:43 AM
07/10/2024 08:48 AM
The test connection works fine in fact it pulls in all the accounts no problem but access is where it errors. Its not an error to where nothing gets pulled in the entitlements still come in as well but I cant pinpoint what is causing the error to show up.
07/10/2024 08:56 AM
07/10/2024 10:15 AM
object_to_be_imported : Profile,Group,PermissionSet,Role,Territory,PermissionSetLicense,FeatureLicense,Folder,Document,Attachment,PermissionSetGroup,PackageLicense
createaccoutnjson: {
"Username": "${user.email.toLowerCase()}".qa,
"Alias": "${user.firstname.toString().substring(0,1)}${user.lastname.toString().substring(0,4)}",
"LastName": "${user.lastname}",
"FirstName": "${user.firstname}",
"CompanyName": "${user.orgunitid}",
"Department": "${user.departmentname}",
"Title": "${user.title}",
"Street": "${user.street}",
"City": "${user.city}",
"State": "${user.state}",
"PostalCode": "${user.customproperty19}",
"Country": "${user.country}",
"Email": "${user.email.toLowerCase()}",
"EmailPreferencesAutoBcc": true,
"EmailPreferencesAutoBccStayInTouch": false,
"EmailPreferencesStayInTouchReminder": true,
"FederationIdentifier": "${user.email.toLowerCase()}",
"Phone": "${user.secondaryPhone}",
"MobilePhone": "${user.phonenumber}",
"CommunityNickname": "${user.lastname}",
"IsActive": true,
"TimeZoneSidKey": "America/New_York",
"LocaleSidKey": "en_US",
"ReceivesInfoEmails": true,
"ReceivesAdminInfoEmails": true,
"EmailEncodingKey": "ISO-8859-1",
"LanguageLocaleKey": "en_US",
"EmployeeNumber": "${user.employeeid}",
"ProfileId":"${profileId}",
"UserPermissionsMarketingUser": false,
"UserPermissionsOfflineUser": false,
"UserPermissionsAvantgoUser": false,
"UserPermissionsCallCenterAutoLogin": false,
"UserPermissionsMobileUser": false,
"UserPermissionsSFContentUser": false,
"UserPermissionsInteractionUser": false,
"UserPermissionsSupportUser": false,
"ManagerId": "${managerAccount==null?'':managerAccount.accountID}"
}
fieldmapping:
{
"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",
"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",
"customproperty30": "IsActive~#~bool"
},
"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"
}
}
}
statusthresholdconfig:
{
"statusAndThresholdConfig": {
"accountThresholdValue": 50,
"correlateInactiveAccounts": true,
"statusColumn": "customproperty30",
"activeStatus": [
"true"
],
"deleteLinks": true,
"lockedStatusColumn": "customproperty22",
"lockedStatusMapping": {
"Locked": [
"1"
],
"Unlocked": [
"0"
]
}
}
}
07/10/2024 10:20 AM
"Username": "${user.email.toLowerCase()}".qa,
This is wrong
"Username": "${user.email.toLowerCase().concat('.qa')}"
07/10/2024 12:50 PM
That fixed my provisioning issue but I am still receiving an error when I do a an access import for salesforce.
07/10/2024 12:53 PM
Try below objects
Profile,Group,PermissionSet,Role,Territory,PermissionSetLicense,FeatureLicense,Folder,CustomAndStandardObject,Document,Attachment,Account,Lead, Opportunity,Contact,Campaign,Case
07/10/2024 05:58 PM
I made the change and still getting the same results
07/10/2024 09:03 PM
Try with less objects and validate