topic 30 byte limit on column name in Qlik Replicate

30 byte limit on column name

tjahncke — Fri, 04 Apr 2025 17:51:21 GMT

Since Oracle 12.2 128 byte column name is now supported. When will Qlik replicate support beyond 30 bytes for a column name.

Re: 30 byte limit on column name

Dana_Baldwin — Fri, 04 Apr 2025 18:22:49 GMT

Hi @tjahncke

Please refer to this community knowledge article on this topic: Replicate - Oracle source: Long Object Names excee... - Qlik Community - 1961484

Thanks,

Dana

Re: 30 byte limit on column name

aidanor89 — Tue, 08 Apr 2025 13:19:07 GMT

Hey Dana

Is there a version of Qlik Replicate that supports this change on Oracle.

I understand it is called out as a limitation on Oracle but is there potentially a change to Qlik in the works to support that change?

The only options seem to be the 2 below so if you don't have goldengate license it will be impossible to work around unless you can influence the Oracle dev side.

(1) Add internal parameter skipValidationLongNames (see above) in endpoint

(2) It also requires a parameter called "enable_goldengate_replication" is enabled in Oracle. This can only be done by end user and their DBA:

alter system set ENABLE_GOLDENGATE_REPLICATION=true;

Kind regards

Aidan

Re: 30 byte limit on column name

Dana_Baldwin — Tue, 08 Apr 2025 15:46:46 GMT

Hi @aidanor89

No, the issue is on Oracle's side - they only write the longer object names to the redo log when Golden Gate is enabled on the database, which requires a license from them. If it's not in the redo log, Qlik Replicate can't read it.

Thanks,

Dana