Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
ORA-01406 during Dimension build — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA-01406 during Dimension build

Received Response
edited Aug 2, 2018 2:36AM in Essbase 3 comments


ORA-01406 during Dimension build


I am trying to build a dimension from an Oracle table using an sql rules file. When I set up the database connection and hit "OK/Retrieve" it brings in all the colums correctly, but does not bring in any data.

When I try to run the build, I get the following error:

EssOCI is enabled to extract data from the Oracle database

SELECT Statement [SELECT * FROM ________________] is generated

EssOCI is initializing the connection to Oracle database on server [__________________:1521/__________

EssOCI succeeded to connect to Oracle database

Connection With SQL Database Server is Established

Error happened while EssOCI retrieved data with error message [ORA-01406: fetched column value was truncated

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!