My Oracle Support Banner

ESSBASE: Unable to Export Data from Essbase to Oracle Database. Error "ORA-00947: not enough values" (Doc ID 2353147.1)

Last updated on JULY 26, 2022

Applies to:

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

Symptoms

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 [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.