Customers using 2023.11-SP02 (2023.11.282) with Snowflake as the target endpoint are requested to upgrade to 2023.11-SP03 (2023.11.468) as soon as possible.
Replication to a Snowflake target from a source table with LOB columns fails with Qlik Replicate 2023.11.282. This is caused by Qlik Replicate attempting to create varchar(0) columns in the attrep_changes table for the LOB columns.
The error seen is:
2024-03-19T13:46:33:290153 [TARGET_APPLY ]I: RetCode: SQL_ERROR SqlState: 42601 NativeError: 1810 Message: SQL compilation error: error line 1 at position 266 Invalid character length: 0. Must be between 1 and 16,777,216. [1022502] (ar_odbc_stmt.c:5090)
Resolution
Upgrade to 2023.11-sp03 (2023.11.468).
Fix Version:
2023.11-SP03 (2023.11.468).
Cause
Product Defect ID: RECOB-8179
Environment
- Qlik Replicate 2023-sp02 (2023.11.282)
- Target endpoint : Snowflake database
