[resolved] ERROR: insufficient data left in message
Hello, I tried to transfer my table in Oracle to S3 then finally to Redshift. And I got a msg ERROR: insufficient data left in message during my COPY cmd from S3 to Redshift. What's confusing is that my reporting works in SQLWorkbench, I copied what I did in SQLWorkbench into tRedshiftRow. This method works well when it's a small table, but then when I tried with a table has 424 954 lines records, 291.49MB, it works no longer. I don't know what's the possible reason can this be. Can you help me ? Thanks a lot. Sylvanas
Re: [resolved] ERROR: insufficient data left in message
Hello, I tested with half of the colone, I tested with only one row but always got the same error : insuficient data ... I changed the TIMEFORMAT AS 'DD-MM-YYYY HH:MIS' and I changed the schema when I get the csv file from Oracle too but it never works ...