Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Salesforce Access Import Failure and New account error

cdavis2
Regular Contributor II
Regular Contributor II

When importing Salesforce Access it is failing due to the following error:

 

Error in getResultIdCannot 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

9 REPLIES 9

rushikeshvartak
All-Star
All-Star
  • Does connection is working.
  • Does it working on postman ?

Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

cdavis2
Regular Contributor II
Regular Contributor II

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.

  • Please share connection configs

Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

cdavis2
Regular Contributor II
Regular Contributor II

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"
]
}
}
}

"Username": "${user.email.toLowerCase()}".qa,

This is wrong 

"Username": "${user.email.toLowerCase().concat('.qa')}"


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

cdavis2
Regular Contributor II
Regular Contributor II

That fixed my provisioning issue but I am still receiving an error when I do a an access import for salesforce. 

Try below objects

Profile,Group,PermissionSet,Role,Territory,PermissionSetLicense,FeatureLicense,Folder,CustomAndStandardObject,Document,Attachment,Account,Lead, Opportunity,Contact,Campaign,Case


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

cdavis2
Regular Contributor II
Regular Contributor II

I made the change and still getting the same results

Try with less objects and validate


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.