Troubleshooting a Data Replication Task

[DataDirect][ODBC Oracle Wire Protocol driver]Fractional truncation. Error in parameter <number>.

The database driver issues a warning message if a Data Replication task replicates all Salesforce objects and tries to write a null value to a numeric field of an Oracle database.

An error message appears while configuring the target for the Data Replication task.

You cannot configure multiple Data Replication tasks to replicate the same source object to the same target object.

For example, you cannot configure two Data Replication tasks to write Salesforce Account data to the SF_ACCOUNT Oracle database table. An error appears when you select the same target connection and target object that is used by another Data Replication task.

If you replicate specific objects for the source connection, the following error appears: Duplicate data replication task for <object name> object with a target prefix of <target prefix>.

The data replication task <name of the other data replication task> is replicating an object whose target prefixed name is same as this one. Change the target connection or enter a different target prefix or remove the object from the task.

To write data from sources with the same name to different target objects in the same target connection, configure different target prefixes.

If you replicate all objects for the source connection, the following error appears: Duplicate Data Replication Task.

The Data Replication Task <name of the other Data Replication Task> is also replicating the same objects from the same source to the same target with the same target prefix as this Data Replication Task. You must change the target or enter a different target prefix.

Numeric data is loaded incorrectly when you run a Data Replication Task that writes Oracle data to a flat file.

When a Data Replication task writes Oracle data with the Number data type to a flat file with the scale as 0, the number is rounded with a precision of 15. The Data Replication application converts the Number data type to Double (15).

To prevent rounding, specify a scale other than 0 for the source data type. When you specify a non zero scale, rounding will not occur because the Data Replication application converts the Number data type to Decimal.