[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
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:MI
S' and I changed the schema when I get the csv file from Oracle too
but it never works ...