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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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??