Troubleshoot Salesforce runtime errors

Use this guide to troubleshoot errors that occur at runtime when you use the Salesforce connector in Workato.

Salesforce trigger failure: 414 URI Too Long

The 414 URI Too Long error occurs when the Salesforce trigger includes an excessive number of selected fields. The recipe stops processing jobs as a result.

You can reduce the number of associated fields to resolve the issue. Use the Related objects and Fields drop-down menus in the trigger configuration to select only the required fields.

Salesforce supports approximately 500-800 fields. The exact number varies based on the field configuration.

Monitor trigger restart fails with DUPLICATE_DEVELOPER_NAME

The DUPLICATE_DEVELOPER_NAME error occurs when a Monitor changes trigger runs once, then fails when you restart the recipe.

For example:

[{"message":"A PlatformEventChannel record with full name CustomChannel21555712__chn already exists. Try using another full name for the channel.","errorCode":"DUPLICATE_DEVELOPER_NAME","fields":[]}]

Salesforce object updates and cached metadata typically trigger this error.

Complete the following steps to resolve the error:

1

Refresh the page and clone the recipe.

2

Create a new recipe with the same trigger. Don't clone the recipe or copy any triggers or actions. Use this new recipe to test the trigger.

3

Create a separate Salesforce connection for the failing recipe.

Complete the following steps in your Salesforce Developer Console if the preceding steps didn't resolve the error:

1

Click the Query Editor tab and select Tooling API.

2

Run the following query to retrieve all Platform Event Channels:

```bash
SELECT Id, DeveloperName, ChannelType, MasterLabel FROM PlatformEventChannel
``` 

3

Identify the CustomChannel{id} that matches the error message.

4

Select the CustomChannel{id} and click Delete row to remove it.

This deletes the existing event channel that conflicts with the trigger and allows the recipe to restart without errors.

Get Report action returns no rows

If the Get Report action returns no rows, open the report in Salesforce and check for groupings with no data. Remove those groupings to resolve the issue.