One Star

[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 
1 REPLY
One Star

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