My Oracle Support Banner

Essbase Error 1021013: ODBC Layer Error: [S1000] ==> [[Oracle][ODBC SQL Server Wire Protocol driver] The DataDirect product you are attempting to access has been provided to you by Oracle for exclusive use with Oracle. (Doc ID 2820176.1)

Last updated on NOVEMBER 12, 2021

Applies to:

Hyperion Essbase - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

On Essbase 11.1.2.4.043, when attempting to perform a data export to a SQL server the following error occurs.

ERROR
-----------------------
ODBC Layer Error: [S1000] ==> [[Oracle][ODBC SQL Server Wire Protocol driver]The DataDirect product you are attempting to access has been provided to you by Oracle for exclusive use with Oracle. You are not licensed to use this product with any application other than Oracle. If you would like to purchase this product for some other use, please call 800-876-3101 or visit DataDirect at www.datadirect.com ]

The log entries are showing the following:

[Wed Oct 6 14:38:03 2021]Local/APP-NAME///TRANSACTION-ID/Info(1042059)
Connected from [::ffff:IP-ADDRESS]

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Info(1013091)
Received Command [Calculate] from user [USERID]

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Info(1013167)
Received Command [Calculate] from user [USERID] using [CALCNAME.csc]

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Info(1021004)
Connection String is generated

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Info(1021041)
Connection String is [DSN=CAPS;UID=...;PWD=...;]

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Info(1021013)
ODBC Layer Error: [S1000] ==> [[Oracle][ODBC SQL Server Wire Protocol driver]The DataDirect product you are attempting to access has been provided to you by Oracle for exclusive use with Oracle. You are not licensed to use this product with any application other than Oracle. If you would like to purchase this product for some other use, please call 800-876-3101 or visit DataDirect at www.datadirect.com ]

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Info(1021014)
ODBC Layer Error: Native Error code [6091]

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Error(1012085)
Unable to export data to SQL table [TABLE-NAME]. Check the Essbase server log and the system console to determine the cause of the problem.

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Info(1021002)
SQL Connection is Freed

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Warning(1080014)
Transaction [ 0x16e0003( 0x615ded0b.0x7425c ) ] aborted due to status [1012085].

[Wed Oct 6 14:38:03 2021]Local/APP-NAME/DB-NAME/USERID/TRANSACTION-ID/Info(1012579)
Total Calc Elapsed Time for [CALCNAME.csc] : [0.015] seconds

 

 

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.