My Oracle Support Banner

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

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.