Salesforce connection aggregation error

nandiniks · February 3, 2025, 4:38pm

Hi All,

Connector: Salesforce

Attribute: cafsl__Link_to_CPQ_User__c

Need to pull above attribute into salesforce instance. In Schema i have added the attribute as below
cafsl__Link_to_CPQ_User__c__c

The aggregation gives the error as below.

sailpoint.connector.InvalidConfigurationException: [ InvalidConfigurationException ]
[ Possible suggestions ] Make sure custom attributes are valid and make sure that ‘__c’ must be added after each custom field name in the application configuration.
[ Error details ] INVALID_FIELD:
ReceivesInfoEmails , ManagerId , cafsl__Link_to_CPQ_User__c__C, (SELECT
^
ERROR at Row:1:Column:571
No such column ‘cafsl__Link_to_CPQ_User__c__C’ on entity ‘User’. If you are attempting to use a custom field, be sure to append the ‘__c’ after the custom field name. Please reference your WSDL or the describe call for the appropriate names. Show Less

Can anyone please help on this request?

Nandini

BenNelson · February 3, 2025, 6:37pm

Did you add the attribute through the UI or the API? I have had similar issues if I didn’t add it to the schema through the API. I would take a look to see how your schema looks from the API and see if it is as you expect.

nandiniks · February 4, 2025, 4:14am

[
{
“nativeObjectType”: “User”,
“identityAttribute”: “Id”,
“displayAttribute”: “Username”,
“hierarchyAttribute”: null,
“includePermissions”: false,
“features”: ,
“configuration”: {},
“attributes”: [
{
“name”: “Id”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Alias”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “City”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “CommunityNickname”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “CompanyName”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “CallCenterId”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Country”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Department”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Email”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Division”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “EmployeeNumber”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Extension”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Street”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Fax”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “IsActive”,
“type”: “BOOLEAN”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “IsFrozen”,
“type”: “BOOLEAN”,
“schema”: null,
“description”: “Flag that indicates if the user is frozen in Salesforce.”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Username”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “FirstName”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “LastName”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “EmailEncodingKey”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Name”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “UserPermissionsMarketingUser”,
“type”: “BOOLEAN”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “UserPermissionsOfflineUser”,
“type”: “BOOLEAN”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “UserPermissionsSFContentUser”,
“type”: “BOOLEAN”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Phone”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “ProfileId”,
“type”: “STRING”,
“schema”: {
“type”: “CONNECTOR_SCHEMA”,
“id”: “f91cfefb31664187b9d6594329941ad5”,
“name”: “group”
},
“description”: null,
“isMulti”: false,
“isEntitlement”: true,
“isGroup”: true
},
{
“name”: “ProfileName”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “PublicGroups”,
“type”: “STRING”,
“schema”: {
“type”: “CONNECTOR_SCHEMA”,
“id”: “fcbc91c063d04d84b9ff4547bea44124”,
“name”: “PublicGroups”
},
“description”: null,
“isMulti”: true,
“isEntitlement”: true,
“isGroup”: true
},
{
“name”: “ReceivesAdminInfoEmails”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Role”,
“type”: “STRING”,
“schema”: {
“type”: “CONNECTOR_SCHEMA”,
“id”: “960ddf482f634ec9841f593244a67d1c”,
“name”: “Role”
},
“description”: null,
“isMulti”: false,
“isEntitlement”: true,
“isGroup”: true
},
{
“name”: “UserType”,
“type”: “STRING”,
“schema”: null,
“description”: “This is user type of salesforce user i.e Standard, Partner, AutomatedProcess.”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “State”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “FederationIdentifier”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “UserPermissionsInteractionUser”,
“type”: “BOOLEAN”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “TimeZoneSidKey”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “LocaleSidKey”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “LanguageLocaleKey”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “LastLoginDate”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Title”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “ReceivesInfoEmails”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “PermissionSet”,
“type”: “STRING”,
“schema”: {
“type”: “CONNECTOR_SCHEMA”,
“id”: “0fc59a5c8cf94089895aa6c05d6ca553”,
“name”: “PermissionSet”
},
“description”: null,
“isMulti”: true,
“isEntitlement”: true,
“isGroup”: true
},
{
“name”: “ManagerId”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “PermissionSetGroup”,
“type”: “STRING”,
“schema”: {
“type”: “CONNECTOR_SCHEMA”,
“id”: “339283f3a0ec4c6dbf1cded1cccf1efb”,
“name”: “PermissionSetGroup”
},
“description”: “PermissionSetGroup”,
“isMulti”: true,
“isEntitlement”: true,
“isGroup”: true
},
{
“name”: “cafsl__User__c”,
“type”: “STRING”,
“schema”: null,
“description”: “Link to CPQ User”,
“isMulti”: true,
“isEntitlement”: true,
“isGroup”: false
}
],
“id”: “060e5ae52a6341b2b63baecc16cdcd15”,
“name”: “account”,
“created”: “2024-07-10T09:54:36.183Z”,
“modified”: “2025-02-04T04:04:22.779Z”
},
{
“nativeObjectType”: “Profile”,
“identityAttribute”: “Id”,
“displayAttribute”: “Name”,
“hierarchyAttribute”: null,
“includePermissions”: true,
“features”: [
“NO_PERMISSIONS_PROVISIONING”
],
“configuration”: {},
“attributes”: [
{
“name”: “Id”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Name”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Description”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “UserType”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
}
],
“id”: “f91cfefb31664187b9d6594329941ad5”,
“name”: “group”,
“created”: “2024-07-10T09:54:36.183Z”,
“modified”: “2024-07-10T09:54:36.459Z”
},
{
“nativeObjectType”: “Role”,
“identityAttribute”: “Id”,
“displayAttribute”: “Name”,
“hierarchyAttribute”: “ParentRoleId”,
“includePermissions”: false,
“features”: ,
“configuration”: {},
“attributes”: [
{
“name”: “Id”,
“type”: “STRING”,
“schema”: null,
“description”: “The Role’s unique identifier”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Name”,
“type”: “STRING”,
“schema”: null,
“description”: “The Role’s name”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “CaseAccessForAccountOwner”,
“type”: “STRING”,
“schema”: null,
“description”: “The case access level for the account owner”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “ContactAccessForAccountOwner”,
“type”: “STRING”,
“schema”: null,
“description”: “The contact access level for the account owner”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “OpportunityAccessForAccountOwner”,
“type”: “STRING”,
“schema”: null,
“description”: “The opportunity access level for the account owner”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “ParentRoleId”,
“type”: “STRING”,
“schema”: null,
“description”: “Unique identifier for the Role’s parent Role”,
“isMulti”: true,
“isEntitlement”: false,
“isGroup”: false
}
],
“id”: “960ddf482f634ec9841f593244a67d1c”,
“name”: “Role”,
“created”: “2024-07-10T09:54:36.183Z”,
“modified”: “2024-07-10T09:54:36.183Z”
},
{
“nativeObjectType”: “PublicGroups”,
“identityAttribute”: “Id”,
“displayAttribute”: “Name”,
“hierarchyAttribute”: null,
“includePermissions”: false,
“features”: ,
“configuration”: {},
“attributes”: [
{
“name”: “Id”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Name”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “DeveloperName”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “DoesIncludeBosses”,
“type”: “BOOLEAN”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “OwnerId”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
}
],
“id”: “fcbc91c063d04d84b9ff4547bea44124”,
“name”: “PublicGroups”,
“created”: “2024-07-10T09:54:36.183Z”,
“modified”: “2024-07-10T09:54:36.183Z”
},
{
“nativeObjectType”: “PermissionSet”,
“identityAttribute”: “Name”,
“displayAttribute”: “Name”,
“hierarchyAttribute”: null,
“includePermissions”: false,
“features”: ,
“configuration”: {
“descriptionAttribute”: “Description”
},
“attributes”: [
{
“name”: “Name”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Label”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Description”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
}
],
“id”: “0fc59a5c8cf94089895aa6c05d6ca553”,
“name”: “PermissionSet”,
“created”: “2024-07-10T09:54:36.183Z”,
“modified”: “2024-07-10T09:54:36.183Z”
},
{
“nativeObjectType”: “PermissionSetGroup”,
“identityAttribute”: “Id”,
“displayAttribute”: “MasterLabel”,
“hierarchyAttribute”: null,
“includePermissions”: false,
“features”: ,
“configuration”: {
“descriptionAttribute”: “Description”
},
“attributes”: [
{
“name”: “Id”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “MasterLabel”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Description”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
}
],
“id”: “339283f3a0ec4c6dbf1cded1cccf1efb”,
“name”: “PermissionSetGroup”,
“created”: “2024-07-10T09:54:36.183Z”,
“modified”: “2024-07-10T09:54:36.183Z”
},
{
“nativeObjectType”: “PermissionSetLicense”,
“identityAttribute”: “Id”,
“displayAttribute”: “MasterLabel”,
“hierarchyAttribute”: null,
“includePermissions”: false,
“features”: ,
“configuration”: {},
“attributes”: [
{
“name”: “Id”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “MasterLabel”,
“type”: “STRING”,
“schema”: null,
“description”: null,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
}
],
“id”: “fe088ca75e2440b699ec60dc8e1f9826”,
“name”: “PermissionSetLicense”,
“created”: “2024-07-10T09:54:36.183Z”,
“modified”: “2024-07-10T09:54:36.183Z”
},
{
“nativeObjectType”: “ManagedPackage”,
“identityAttribute”: “Id”,
“displayAttribute”: “NamespacePrefix”,
“hierarchyAttribute”: null,
“includePermissions”: false,
“features”: ,
“configuration”: {},
“attributes”: [
{
“name”: “Id”,
“type”: “STRING”,
“schema”: null,
“description”: “Managed Package Id.”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “NamespacePrefix”,
“type”: “STRING”,
“schema”: null,
“description”: “Managed Package NamespacePrefix.”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
}
],
“id”: “c8a19acc0b9548eabd9b011112e7c2bf”,
“name”: “ManagedPackage”,
“created”: “2024-07-10T09:54:36.183Z”,
“modified”: “2024-07-10T09:54:36.183Z”
},
{
“nativeObjectType”: “CollaborationGroup”,
“identityAttribute”: “Id”,
“displayAttribute”: “Name”,
“hierarchyAttribute”: null,
“includePermissions”: false,
“features”: ,
“configuration”: {},
“attributes”: [
{
“name”: “Id”,
“type”: “STRING”,
“schema”: null,
“description”: “Collaboration Group Id.”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Name”,
“type”: “STRING”,
“schema”: null,
“description”: “Collaboration Group Name.”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “CollaborationType”,
“type”: “STRING”,
“schema”: null,
“description”: “Collaboration Group Type.”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
}
],
“id”: “31783bf7defd4002a514fb1ae0cd053d”,
“name”: “CollaborationGroup”,
“created”: “2024-07-10T09:54:36.183Z”,
“modified”: “2024-07-10T09:54:36.183Z”
},
{
“nativeObjectType”: “DelegateGroup”,
“identityAttribute”: “Id”,
“displayAttribute”: “Name”,
“hierarchyAttribute”: null,
“includePermissions”: false,
“features”: ,
“configuration”: {},
“attributes”: [
{
“name”: “Id”,
“type”: “STRING”,
“schema”: null,
“description”: “The Delegate Group’s unique identifier”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “DeveloperName”,
“type”: “STRING”,
“schema”: null,
“description”: “The unique developer name for the delegate group”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “IsLoginAccessEnabled”,
“type”: “BOOLEAN”,
“schema”: null,
“description”: “Indicates if login access is enabled for the developer group”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
},
{
“name”: “Name”,
“type”: “STRING”,
“schema”: null,
“description”: “The developer group’s unique label”,
“isMulti”: false,
“isEntitlement”: false,
“isGroup”: false
}
],
}
]

@BenNelson please see if this was what you were looking for, I did add the attribute cafsl__User__c via UI only.

officialamitguptaa · February 4, 2025, 6:15am

@nandiniks -

To resolve the error and successfully pull the cafsl__Link_to_CPQ_User__c attribute into Salesforce via SailPoint Identity Now, follow these steps:

Issue Analysis

The error occurs because the Salesforce connector is looking for a field named cafsl__Link_to_CPQ_User__c__C, which does not exist. The root cause is an extra __c appended in the schema configuration, resulting in a duplicate suffix (__c__c). Salesforce custom fields only require one __c suffix in their API name.

Solution

Correct the Schema Attribute Name
In SailPoint Identity Now, update the schema attribute from:
```
cafsl__Link_to_CPQ_User__c__c
```
to the exact Salesforce API name:
```
cafsl__Link_to_CPQ_User__c
```
This ensures the connector references the correct field in Salesforce.
Verify the Field Exists in Salesforce
Confirm the custom field cafsl__Link_to_CPQ_User__c exists on the User object in Salesforce:
- Go to Setup → Object Manager → User → Fields & Relationships.
- Ensure the field is listed and its API name matches exactly (case-insensitive but avoid typos).
Check Field-Level Security (FLS)
Ensure the Salesforce integration user profile has read access to the field:
- Navigate to the Profile assigned to the integration user.
- Under Field Permissions, verify cafsl__Link_to_CPQ_User__c is visible and readable.
Test the Configuration
Run a SOQL query in Salesforce to validate the field:
```
SELECT Id, Username, cafsl__Link_to_CPQ_User__c FROM User LIMIT 1
```
If the query succeeds, the field is accessible.

By correcting the schema and validating permissions, the aggregation should work as expected.

Hope this helps

nandiniks · February 6, 2025, 4:34am

@officialamitguptaa Thank you so much, This explanation helped a lot and we diagnised the issue where it exists. Taking this investigation to next level.
Appreciate your response on this query. Much helpful.