Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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 
Labels (2)
2 Replies
Anonymous
Not applicable
Author

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 0683p000009M9p6.pngS' and I changed the schema when I get the csv file from Oracle too
but it never works ... 
Anonymous
Not applicable
Author

I am also facing same error.

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