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