Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Synchronization with Oracle Serving as the Source/ Full Synchronization Error: has date/datetime: *** which is outside of dest allowed range
Updated on 2022-12-30 GMT+08:00
View PDF
Share

Full Synchronization Error: has date/datetime: *** which is outside of dest allowed range

Scenarios

During a full synchronization from Oracle to MySQL, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: java.lang.InterruptedException: Database: ***, Table: ***, Column: *** has date/datetime: *** 0:0:0 which is outside of dest allowed range.

Possible Causes

Oracle and MySQL heterogeneous databases support different time types. You can run the following SQL statement in the Oracle database to view data:

select to_char(column_name, 'SYYYY-MM-DD') from table_name;

Solution

Contact Huawei technical support. After the fault is rectified, DRS writes data based on the following rules:

  • If the destination database stores DATE data, 0000-01-01 00:00:00 is written.
  • If the destination database stores TIMESTAMP data, 1970-01-01 00:00:01 is written.