ORA-00947 Error When Trying To Export Data From Essbase To Oracle Database.

(Doc ID 2353147.1)

Last updated on JANUARY 25, 2018

Applies to:

Hyperion Essbase Administration Services - Version 11.1.2.3.505 and later
Information in this document applies to any platform.

Symptoms

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 [947]
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 '

Cause

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