topic Re: [resolved] ERROR: insufficient data left in message in Talend Studio

[resolved] ERROR: insufficient data left in message

Anonymous — Sat, 16 Nov 2024 10:58:07 GMT

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

Anonymous — Mon, 02 Nov 2015 17:53:31 GMT

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 ...

Re: [resolved] ERROR: insufficient data left in message

Anonymous — Wed, 26 Sep 2018 10:59:36 GMT

I am also facing same error.

can you please help me with this.How you resolved this error??