topic Re: Getting Trouble While Inserting Data In Bulk in QlikView

Getting Trouble While Inserting Data In Bulk

markast — Mon, 26 Jan 2026 16:26:21 GMT

Hello all, The task that pulls from the SQL server into Snowflake is hitting an error after the latest qlik upgrade, not sure if it is a setting that was changed during the 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) https://omegle.site/

00028096: 2022-03-09T12:33:51 [TARGET_APPLY ]E: Failed to execute bulk insert statement. Reply to me if you know the solution.

Re: Getting Trouble While Inserting Data In Bulk

Lucas_Gatling — Mon, 06 Jun 2022 19:58:29 GMT

@markast what version of Replicate are you on?

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

Re: Getting Trouble While Inserting Data In Bulk

EDJ — Thu, 13 Oct 2022 15:25:20 GMT

Is this issue with formation of the BULK insert statement resolved in Replicate V22.5? Is there a workaround or solution when using V21.11?