Hi,
I'd like to run a delta copy using the new metadata-driven copy task that is currently in preview. In my Oracle source table I have a column of data type TIMESTAMP which contains values like this: 2021-06-30 23:59:59.100000
The target table shall be auto-generated on Azure SQL and the automatic mapping within the menu shows me that a datetime field will be generated for this column. I finished the whole guided menu for the metadata driven copy task without problems, i.e. I also ran the 2 SQL commands provided at the end to generate the MainControlTable and also the stored procedure.
However when I start the debug run, I get an error and clicking through various processes the original problem is shown:
Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [22008] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01843: not a valid month,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [22008] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-01843: not a valid month,Source=msora28.dll,'
I am not sure which date could cause the problem. For specifying the "water mark column value start" one can only select a date from the date picker, which I set to a date before my first MODIFIEDDATE values start. Unfortunately it is not possible to specify another column which contains the UNIX timestamp.
For testing the validity of the origin table I also tried running a simple, traditional copy job with ADF to create a target table in the destination and it works perfectly by copying all data to the created target table.