My Oracle Support Banner

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

Last updated on MAY 10, 2021

Applies to:

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


When loading data to an Essbase v11. cube and the input Database is Teradata release, 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 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]





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

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