Oracle Connector

Back Next

Troubleshooting a replication task

[DataDirect][ODBC Oracle Wire Protocol driver]Fractional truncation. Error in parameter <number>.: The database driver issues a warning message if a
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 replication task.: You cannot configure multiple
replication
tasks to replicate the same source object to the same target object.; For example, you cannot configure two
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
replication
task.

If you replicate specific objects for the source connection, the following error appears: Duplicate replication task for <object name> object with a target prefix of <target prefix>.: An error occurs when you run two
replication
tasks to replicate two objects whose target prefixed name is the same. You must change the target connection, 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, you must configure different target prefixes.

If you replicate all objects for the source connection, the following error appears: Duplicate replication task.: An error occurs when you run two
replication
tasks to replicate the same object from the same source to the same target with the same target prefix. You must change the target or enter a different target prefix.

Numeric data is loaded incorrectly when you run a replication task that writes Oracle data to a flat file.: When a
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
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
replication
application converts the Number data type to Decimal.