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

Last updated on SEPTEMBER 24, 2019

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: <ecid>] [tid: <tid>] Connected from [<IPaddress]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [REQ-91] [REQ] [ecid: <ecid>] [tid: <tid>] [DBNAME: {dbname}] Received Command [SQLRetrieve] from user [<username>@Native Directory]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-4] [SQL] [ecid: <ecid>] [tid: <tid>] [DBNAME: {dbname}] Connection String is generated
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-41] [SQL] [ecid: <ecid>] [tid: <tid>] [DBNAME: {dbname}] Connection String is [DSN=Teradata;UID=...;PWD=...;]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-6] [SQL] [ecid: <ecid>] [tid: <tid>] [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: <ecid>] [tid: <tid>] [DBNAME: {dbname}] ODBC Layer Error: [S1000] ==> [[
________________________________________
]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-14] [SQL] [ecid: <ecid>] [tid: <tid>] [DBNAME: {dbname}] ODBC Layer Error: Native Error code [0]
[2017-06-16T11:57:41.895+02:00] [{dbname}] [NOTIFICATION:16] [SQL-1] [SQL] [ecid: <tid>] [tid: <tid>] [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: <tid>] [tid: <tid>] [DBNAME: {dbname}] Transaction [ 0xf9702de( 0x5943ab95.0xda818 ) ] aborted due to status [1021001]

Changes

Cause

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