snowflake bulk load string is too long
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have been issues loading anything using the snowflake bulk loader. I did download the latest driver and I have attempted to follow the instructions my IS team has given me, however, it keeps giving me errors and doesn't like any of the data I give it.
Here is a list of the errors I get- I try to eliminate the columns giving me the error just see if I can get anything through.
Output Data (5) DataWrap2ODBC::SendBatch: String '62000' is too long and would be truncated Insert into "TUBEFAB"."RMTRANSACTION"("ITNBR","HOUSE","UPDDT","TRNDT","UPDTM","TCODE","TRQTY","ORDNO","DPTNO","WKCTR","OPSEQ_1","TBCDE","SRLHU","BADGE") Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Error: Output Data (5): DataWrap2ODBC::SendBatch: String '0100' is too long and would be truncated Insert into "RMTRANSACTION"("ITNBR","HOUSE","UPDDT","TRNDT","UPDTM","TCODE","TRQTY","ORDNO","DPTNO","OPSEQ_1","TBCDE","SRLHU","BADGE") Values (?,?,?,?,?,?,?,?,?,?,?,?,?)
Output Data (5) DataWrap2ODBC::SendBatch: String '1160717' is too long and would be truncated Insert into "TUBEFAB"."RMTRANSACTION"("ITNBR","HOUSE","UPDDT","TRNDT","UPDTM","TCODE","TRQTY","ORDNO","DPTNO","TBCDE","SRLHU","BADGE") Values (?,?,?,?,?,?,?,?,?,?,?,?)
Error: Output Data (5): DataWrap2ODBC::SendBatch: Numeric value '7279' is out of range Insert into "TUBEFAB"."RMTRANSACTION"("ITNBR","HOUSE","UPDTM","TCODE","TRQTY","ORDNO","DPTNO","TBCDE","SRLHU","BADGE") Values (?,?,?,?,?,?,?,?,?,?)
I tried to start from ground zero and simplify it so I can get it working before I try any of the data transforming and cleansing that I want to do so this is how I currently have my workflow looking
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI @Daflinders
Seems like it can be related to your data types. Try to increase the size for your string values and see if it works for string values. Let me know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried adjusting the range and it still isn't liking it. It gives me another error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I even tried changing the data type to an 64integer and I still get the same error as shown in my previous comment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Daflinders,
Try and change the Data size in your snowflake table where you are trying to insert the values.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It seems that it is giving me a new error now. I don't know why the the error changed but I'm guessing this is closer to the actual problem? Suggestions?
