ORA-00947 Error When Trying To Export Data From Essbase To Oracle Database.
Last updated on JANUARY 25, 2018
Applies to:Hyperion Essbase Administration Services - Version 22.214.171.124.505 and later
Information in this document applies to any platform.
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 '
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms