My Oracle Support Banner

'ORA-00972: identifier is too long' Error while Loading Data from Oracle in to Essbase Table (Doc ID 1309360.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 10.1.3.5.5 and later
Information in this document applies to any platform.

Symptoms

When loading data from Oracle to Essbase using ODI, the Interface Load data (or metadata) into Essbase step fails:

java.sql.SQLException: ORA-00972: identifier is too long


Specifically, the code that failed with this error is selecting from Oracle source table:


This is due to the length of the long Essbase column which is >32 characters.

We tried changing the short description for this Essbase column in the Model but it still fails. We do not have an option of reducing the length of the column in the Essbase because of other business complications.

Is there a a workaround wherein the target Essbase column "VERY_LONG_COLUMN_NAME_ON_ESSBASE" can be retained for its length and still be mapped and get loaded?

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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