Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Greg_Pagan
Contributor III
Contributor III

Qlik Replicate Oracle Error on column with to long name

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

Labels (1)
4 Solutions

Accepted Solutions
Dineshan
Support
Support

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

View solution in original post

SwathiPulagam
Support
Support

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

View solution in original post

SwathiPulagam
Support
Support

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

View solution in original post

SushilKumar
Support
Support

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

View solution in original post

4 Replies
Dineshan
Support
Support

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
Support
Support

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
Support
Support

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
Support
Support

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