Troubleshooting
- Some Salesforce objects, such as BusinessHours, can be created but not deleted. If you are unable to delete an object, ensure that your account has the required permissions, and that Salesforce allows deletion of that object.
- Whenever possible, use the UPSERT writer mode instead of INSERT to avoid creating duplicate records when re-running a translation involving the Salesforce Writer. Since Salesforce writes are not transactional, this also makes it safer to retry a partially-successful Salesforce Writer translation.
- When using the Salesforce Writer in UPDATE mode, writing attributes with empty values will not update the corresponding record field on Salesforce to a blank value. To blank out values, the Salesforce Bulk API looks for the special value “#N/A”.
- Some attributes, such as LastModifiedById and LastModifiedDate, are read-only. Feature types that have read-only attributes will not be successfully written to Salesforce. Use the “import feature types” function on the writer to import Salesforce feature types with read-only attributes automatically excluded. Avoid using “copy attributes from feature type” on Salesforce Writer feature types.