Hi everyone, wish you have a happy new year.
I have had a big problem when working with ADS Integrator and now I still cannot fix that problem. I have been stuck with this for 2 days. The problem is “Invalid value in column 2 for type Int8” with the column that has a varchar type (not integer or numeric data type).
More specific, I have a csv file with the name ip_address_string_new with 6 columns, and all columns I have modified it with varchar data type. When I run csv downloader for this csv file, it still runs successfully and nothing happens. But when I run the ADS integrator, the errors folder appear with the ip_address_string_new rejected file and ip_address_string_new exception file. In the ip_address_string_new exception file, it said that “Invalid value in column 2 for type Int8 - '' len 0” like the image below
And In the ip_address_string_new rejected file, there’re some records like the image below. It said that in the column 2 in each record, the ADS Integrator cannot convert the value null into the type Int8, but I just don’t know why this problem appears because I have config the data type for all columns of this file is only varchar. So why ADS Integrator need to convert the value to integer data type?
I have tried many ways by adding some options like replace null value with value “123” by null_value, adding escape_as field or enclosed_by field or remove those adding options but it doesn’t make sense.
Those records below are the records that have been rejected
Here is my metadata for the ip_address_string_new
Please help me fix this or just give me a hint about this. Thank you guys. I really need your help.
Best answer by Joseph HeunView original
You will need to ensure that the correct data types are set within the feed file. This is where the data types for the CSV Downloader are stored.