Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


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

Knowledge Base

Suggest a new Article!