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

hitlbs70 — Thu, 07 May 2026 00:17:17 GMT

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.

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

john_wang — Thu, 07 May 2026 01:48:14 GMT

Hello @hitlbs70 ,

We've a discussion before, see Column Filter.

Hope it helps.

John.

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

hitlbs70 — Thu, 07 May 2026 04:23:59 GMT

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.

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

john_wang — Thu, 07 May 2026 22:57:40 GMT

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.

topic Re: Long Oracle statements (longer than 32K) for Table with 989 Columns in Qlik Replicate

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

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

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

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