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

Last updated on JULY 28, 2017

Applies to:

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