Name-Length Limitations For database Contraints In ODI and Related Technologies (Doc ID 424427.1)

Last updated on JUNE 16, 2022

Applies to:

Goal

In all standard prepackaged Control Knowledge Modules in ODI, the error table, (E$_ ) CONS_NAME column for storing constraint names is 35 characters long by default.

This does not pose any problem when inserting the constraint from the ODI Designer as the GUI constraint field limit is 35.

No problems will be encountered with Oracle and Teradata Datastores as these Databases impose limiting values of less than 35.

However, this is not the case when using Microsoft SQLServer using a table with a constraint name which exceeds 35 characters in length. In this case an error message will be signalled when populating the E$_ table during execution of an Integration Interface.

Is there a workaround ?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.