Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
SaranyaK
Contributor III
Contributor III

Bulk Insert error

The task that pulls from SQL server into Snowflake is hitting an error after the latest qlik upgrade, not sure if it a setting was changed during upgrade or something that is causing a truncation error on the CLOB column, The column in the SQL server source is defined as Varchar(max) and in the target it is VARCHAR (16384000) and in the table settings, column type is  defined as CLOB.

 

[TARGET_APPLY ]E: RetCode: SQL_ERROR SqlState: 22000 NativeError: 100078 Message: String 'DESCRIPTION  HOTEL PARCEL

A PARCEL XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX...' is too long and would be truncated [1022502] (ar_odbc_stmt.c:4981)
00028096: 2022-03-09T12:33:51 [TARGET_APPLY ]E: Failed to execute bulk insert statement.

Labels (1)
1 Reply
Jill_Masinde
Support
Support

Hello Saranya

Did you get this issue resolved?  This could be related to the version of  Replicate you are running?

V21.11 that has an issue with the formation of the BULK insert statement, where the CLOB column appears to have changed its behavior.

See the link below with similar issue.

https://community.qlik.com/t5/QlikView-Integrations/Getting-Trouble-While-Inserting-Data-In-Bulk/td-...