ESSBASE: Unable to Export Data from Essbase to Oracle Database. Error "ORA-00947: not enough values"
(Doc ID 2353147.1)
Last updated on APRIL 07, 2021
Applies to:Hyperion Essbase Administration Services - Version 18.104.22.168.505 and later
Information in this document applies to any platform.
When attempting to Export Data from Essbase Application to Oracle Database Table, the following Error occur:
Error in exporting data to table xxxxx.xxxxxxx. ORA-00947: not enough values error returned.
Connection String is [DSN=xxxxxx;UID=...;PWD=...;]
Connection With SQL Database Server is Established
ODBC Layer Error: [21S01] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00947: not enough values]
ODBC Layer Error: Native Error code 
Unable to export data to SQL table [xxxxxx.xxxxxxxx]. Check the Essbase server log and the system console to determine the cause of the problem '
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