Data Conversion Error while CDC and not in Full Load
Hello Team,
We are using Oracle as source and Synapse as target .
While fullloading a table we dont get an error of any data conversion but while Full load and Apply Changes we get this error , any suggestions ?
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row starting at byte offset 0, column 8 (NUM_MODIFY_TRANS_ID). Underlying data description: /folder/12/5/LOAD0000019B.csv.gz. Line: 1 Column: -1
Seems like a data related issue. Try to determine the table & column involved and check the data at the source. Elevating logging for source_capture & target_apply may help with this (these are the logging items related to the change processing phase of the task). Be careful as the task logs can get large. You might consider putting this table into a separate task to do this testing which may help limit the size of the log and the amount of time you need it to run with logging elevated.
You can also set internal parameters on the target endpoint so that you can inspect the CSV file to help identify the table/column/data. Don't forget to disable these once you're done as obviously they will consume disk space as well:
