Long Oracle statements (longer than 32K) for Table with 989 Columns

[hitlbs70]

Hello Team,

We encountered an issue in Qlik Replicate while processing CDC changes from an Oracle source table.
The table has approximately 989 columns, and during INSERT processing, the generated SQL/DML statement size becomes about 33,654 bytes.

As a result, Qlik Replicate fails with an error related to:

03028348: 2026-05-07T01:59:59 [ASSERTION ]W: Long Oracle statements (longer than 32K) cannot be applied, causing a data error ORA-01460; please use TARGET_APPLY TRACE mode for more information (oracle_endpoint_apply.c:2138)
03028348: 2026-05-07T01:59:59 [TARGET_APPLY ]T: A statement for table 'XXXX.XX_XXX_XXXXXX' is longer than 32K (its size is '33654'), it results in a data error (oracle_endpoint_apply.c:2147)
03028348: 2026-05-07T01:59:59 [TARGET_APPLY ]T: Begin transaction, current record id '13' (endpointshell.c:4790)
03028348: 2026-05-07T01:59:59 [TARGET_APPLY ]T: A statement for table 'XXXX.XX_XXX_XXXXXX' is longer than 32K (its size is '33654'), it results in a data error (oracle_endpoint_apply.c:2147)
03028348: 2026-05-07T01:59:59 [TARGET_APPLY ]T: Begin transaction, current record id '25' (endpointshell.c:4790)
03028348: 2026-05-07T01:59:59 [TARGET_APPLY ]T: Begin transaction, current record id '37' (endpointshell.c:4790)
03028348: 2026-05-07T02:00:00 [TARGET_APPLY ]T: Execute cdc events, number of events 4 (oracle_endpoint_apply.c:2017)
03028348: 2026-05-07T02:00:00 [TARGET_APPLY ]T: ORA-01460: unimplemented or unreasonable conversion requested [1020417] (oracle_endpoint_apply.c:2026)
03028348: 2026-05-07T02:00:00 [TARGET_APPLY ]W: A data error was encountered. Refer to the 'attrep_apply_exceptions' table for details. (endpointshell.c:7163)
03028348: 2026-05-07T02:00:00 [TARGET_APPLY ]T: Failed to execute statement.Error is : 'ORA-01460: unimplemented or unreasonable conversion requested ', stream position 'none'.
~{AQAAAOnhIF9t9zw12F5yptqyDNp8VsZD3FbyLw1hAOoZF06QsZioTtQO.....※ The full task log is very large

(endpointshell.c:7164)
03028348: 2026-05-07T02:00:00 [TARGET_APPLY ]T: ORA-01460: unimplemented or unreasonable conversion requested [1020417] (oracle_endpoint_apply.c:2026)
03028348: 2026-05-07T02:00:04 [TARGET_APPLY ]T: Begin transaction, current record id '49' (endpointshell.c:4790)

Based on our analysis, the issue appears to be caused by the INSERT statement size exceeding the 32K limit.

Environment
Qlik Replicate : 2022.5.0.395
Source, Target DB: Oracle 19c
Replication mode: CDC only
Table column count: approximately 989 columns
INSERT statement size: approximately 33,654 bytes
Error: Long Oracle statements longer than 32K

Is there any supported way in Qlik Replicate to process Oracle DML statements larger than 32K?
Is this a known limitation of Qlik Replicate?

Thank you.

[john_wang]

Hello @hitlbs70 ,

We've a discussion before, see Column Filter.

Hope it helps.

John.

[hitlbs70]

Hello, @john_wang 

Thank you for your response.

I have reviewed the Column Filter document.

However, the same transaction is replicated successfully by another CDC solution, and the issue occurs only in Qlik Replicate.

Could you please confirm whether this is a current Qlik Replicate limitation?
If so, is there any plan to improve this behavior in a future release?

Thank you.

[john_wang]

Hello @hitlbs70 ,

Thanks for the update.

Qlik Replicate 2022.5 reached End of Support (EOS) two years ago; please refer to the documentation here for details.

I would suggest testing the scenario on a currently supported version. Replicate 2025.11 is highly recommended.

Regards,

John.