Errors Related to SBC

You can resolve errors related to Search Before Create (SBC)

SBC Import Fails with "Invalid Cross Reference ID" Error

This error occurs when you perform the following steps:
  1. Perform search by SBC for some object.
  2. Click on Preview&Import.
  3. Click Import to import the entity.

Resolution

This issue occurs if you try to insert some ID field that is incorrect because there is no object with such an ID in Salesforce. This is similar to you trying to define a reference to an Account object, but the Account does not exist. For example, a user works with two Salesforce organizations and maps the reference to an Account into some Reltio attribute. If the to_salesforce mapping is defined for the same set of fields as in the to_reltio mappings, such configuration works only for one Salesforce organization. To ensure that the configuration works for both Salesforce organizations, edit the mapping for the object type and remove all ID fields from the mapping if there is a possibility that the IDs may come from the other Salesforce organization.

SBC Import Fails with Some Non Standard Error about Wrong or Missing Value

This can occur when you perform the following steps:
  1. Perform search by SBC for some object.
  2. Click on Preview&Import.
  3. Click Import to import the entity.

Some error occurs. For example, you see an error that Country is empty but the Country field is provided.

Resolution

Check validation rules by navigating to Setup > Object Manager > Account (or other objects you are working with) > Validation Rules. The validation rules may have absolutely random logic, such as a field that can be null may be checked for a null value and failed if it is true.

SBC Import Fails with the "Country must be Set Before Setting State" Error

This can occur when you perform the following steps:
  1. Perform search by SBC for some object.
  2. Click on Preview&Import.
  3. Click Import to import the entity.

Resolution

In this case, the Country and States picklists most likely are activated for the Salesforce organization but the to_salesforce mapping contains the mapping for Country instead of CountryCode. As a result, the Country value is ignored and the State value is set. You need to update the mapping and define a mapping for CountryCode that is a two letter ISO 3166 code. In Reltio, the Country values may be as country names. Check if RDM is configured for Country. If yes, then use the lookupCode to map codes. The example of the mapping for CountryCode is as follows:

{
    "sfdcAttrName": "CountryCode",
    "value": "=source(configuration/entityTypes/HCP/attributes/Address/attributes/Country).lookupCode()"
}

SBC Import Fails with Some Field is not Writable Error

This can occur when you perform the following steps:
  1. Perform search by SBC for some object.
  2. Click on Preview&Import.
  3. Click Import to import the entity.

Resolution

You cannot edit some fields of an object. For example, you cannot set a value for the Contact Name field directly instead it is auto generated by salesforce. The to_salesforce mapping must not contain fields that cannot be edited. Therefore, remove such fields from the mapping. Refer to https://workbench.developerforce.com/ tool to view the object description and check if a field is creatable/writable.