Welcome Guest! Log in


Symptom

Possible symptoms include:

  • When working with Oracle tables or stages, the object names generated by Stambia are truncated to 30 characters
  • When building a Package or Delivery containing Oracle metadata, there is an "Error during Compilation"
    Error during Compilation (compilation.compilationD)
    Watch console for more details
    There are at least 2 steps with the same name 'Drop Table - L1_SOME_PRETTY_LONG_TABLENAME_' in a subprocess. Check the steps /My mapping/L1-SOME_PRETTY_LONG_TABLENAME-Load/Drop Table
  • At execution time, Oracle raises an error "ORA-00972: identifier is too long"

Solution

First, a brief explanation:

Oracle Database versions 8.x, 9.x, 10.x, 11.x, 12.0, 12.1 have a limitation of 30 bytes for object names, including table names.

Oracle Database version 12.2 and above support object names of 128 bytes.

Stambia generates work tables with a truncation when necessary. There can be rare and complex situations where this truncation is not completely done.

In such cases, possible solutions include :

  • Defining shorter Load / Integration Masks for Temporary Objects in the Metadata
  • Disabling the truncation if you are working with Oracle Database 12.2 or above
    • Set the Object Truncation Size to 128 in the Temporary Objects in the Metadata
    • Starting with the templates.specific release of March 2020 : set the "Database Major Version" to match your version (for example 12.2), this will disable object name truncation

You have no rights to post comments

Knowledge Base

Suggest a new Article!