When you perform an incremental run with a Salesforce source and a database target, the task might fail if the source and target metadata do not match.
The task can fail because the data type in the Salesforce field and data type for the database target column do not match. The task can also fail if the precision or scale for a Salesforce field increases and the database column might not be able to store the value.
To adjust the target column for changes to source metadata, you can use the AutoAlterColumnType custom configuration property. When you use this property, the replication task modifies the target column metadata to match the source. Set the AutoAlterColumnType custom configuration property for the Secure Agent that runs the replication task.
You cannot use the AutoAlterColumnType property in all situations. If the AutoAlterColumnType property does not resolve a mismatch, you might need to reset the target and reload.
The following table includes a few examples of metadata differences and possible approaches to take:
Source and Target Metadata Mismatch
Action
Increase in precision
Use AutoAlterColumnType.
Decrease in precision
Reset target and reload.
Change in data type
Reset target and reload.
Additional column
No action required. All load types can resolve this issue.
Deleted column
No action required. All load types can resolve this issue.
Setting the AutoAlterColumnType property
Set the AutoAlterColumnType custom configuration property so the database target column adjusts when the data type, precision, or scale of a Salesforce source field changes. Set this property for the Secure Agent that runs the replication task.
1Click Configure > Runtime Environments.
2Click on the Secure Agent that runs the replication task and select Edit Secure Agent.
3Under Custom Configuration Details, click the Add icon and enter the following values: