Qlik Replicate Oracle Error on column with to long name

[Greg_Pagan]

We received and Oracle error that indicates that our Oracle column name exceeded 30 characters by 5 which is the limit for Column names.  Is there any way to over ride the length or to shorten it before the error is received?

Here is the error:

Table 'GBD_EXPERIENCE.EXP_COV_TYPE_GROUPING_FACTC' cannot be captured because it contains column INCURRED_CLAIMS_4_PRC_ADJ_NON_COVID with too long name 35 bytes  

We are running QLIK Replication from November 2022 and Oracle 19.  Full log is attached

[Dineshan · Accepted solution]

Hello @Greg_Pagan ,

Can you try setting internal parameter skipValidationLongNames and set its value to true (default is false). This is a limitation while using Oracle as a source endpoint.

Thank you,

Dinesh

[SwathiPulagam · Accepted solution]

Hi @Greg_Pagan ,

You can use the internal parameter "skipValidationLongNames" in the Oracle source endpoint.

Below is the community post for your reference:

https://community.qlik.com/t5/Qlik-Replicate/Limitations-and-considerations-Oracle/td-p/1878009

Thanks,

Swathi

[SwathiPulagam · Accepted solution]

Hi @Greg_Pagan ,

You can overcome this oracle limitation if you have the Goldengate license:

Below is the community article for your reference:

https://community.qlik.com/t5/Official-Support-Articles/Replicate-Oracle-source-Long-Object-Names-ex...

Thanks,

Swathi

[SushilKumar · Accepted solution]

Hello team,

Would like to shed some light on the above discussion as well. All above comments are True . Its A Oracle database limitation. you may find more information on the Shared oracle Documentation links.

 As stated in the docs, the maximum length of object name (tables, columns, triggers, packages, etc.) is 30 bytes:

http://docs.oracle.com/database/121/SQLRF/sql_elements008.htm#SQLRF51129

The only exceptions are database names (8 byte limit) and database links (128 bytes).

As of Oracle Database 12.2, the maximum length of names increased to 128 bytes (provided compatible is set to 12.2 or higher). Database names are still limited to 8 bytes. And the names of disk groups, pluggable databases (PDBs), rollback segments, tablespaces, and tablespace sets are limited to 30 bytes.

http://docs.oracle.com/database/122/SQLRF/Database-Object-Names-and-Qualifiers.htm#SQLRF51129

Regards,

Sushil Kumar