SQL Interface Problem Loading Data From Teradata Version 15.10: "ODBC Layer Error: Native Error code [0]". (Doc ID 2290506.1)

Last updated on JULY 28, 2017

Applies to:

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

Symptoms

When loading data to an Essbase v11.1.2.4.000 cube and the input Database is Teradata release 15.10.004.005, it errors with:

[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [TCP-59] [TCP] [ecid: 1497261425434,0] [tid: 5468] Connected from [::ffff:10.242.159.203]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [REQ-91] [REQ] [ecid: 1497261425434,0] [tid: 5468] [DBNAME: {dbname}] Received Command [SQLRetrieve] from user [hypadmin@Native Directory]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-4] [SQL] [ecid: 1497261425434,0] [tid: 5468] [DBNAME: {dbname}] Connection String is generated
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-41] [SQL] [ecid: 1497261425434,0] [tid: 5468] [DBNAME: {dbname}] Connection String is [DSN=Teradata;UID=...;PWD=...;]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-6] [SQL] [ecid: 1497261425434,0] [tid: 5468] [DBNAME: {dbname}] SELECT Statement [SELECT * FROM xxx.xxx WHERE struttura='xxx'] is generated
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-13] [SQL] [ecid: 1497261425434,0] [tid: 5468] [DBNAME: {dbname}] ODBC Layer Error: [S1000] ==> [[
________________________________________
]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-14] [SQL] [ecid: 1497261425434,0] [tid: 5468] [DBNAME: {dbname}] ODBC Layer Error: Native Error code [0]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-1] [SQL] [ecid: 1497261425434,0] [tid: 5468] [DBNAME: {dbname}] Failed to Establish Connection With SQL Database Server. See log for more information
[2017-06-16T11:57:41.895+02:00] [{dbname}] [WARNING:1] [TMG-14] [TMG] [ecid: 1497261425434,0] [tid: 5468] [DBNAME: {dbname}] Transaction [ 0xf9702de( 0x5943ab95.0xda818 ) ] aborted due to status [1021001]

 

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