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 AUGUST 17, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.