Essbase/SQL Interface 11.1.2.1 Cannot Connect to Teradata RDBMS (Doc ID 1348459.1)

Last updated on JULY 29, 2016

Applies to:

Hyperion Essbase - Version 11.1.2.1.000 and later
Information in this document applies to any platform.
*** Checked for Relevance 23-Jul-2013 ***
RDBMS: Teradata v2r12
ODBC Driver: Teradata 12.00.00.06 from Teradata
OS: Windows 2003, 32-bit


Symptoms

Cannot connect to Teradata database from 32-bit Essbase's SQL Interface v11.1.2.1 with the errors.  SQL Interface returns error:

"Failed to Establish Connection with SQL Database Server. See log for more information"

Essbase application log returns error:

[Thu Aug 11 09:16:57 2011] Info(1021013)
ODBC Layer Error: [IM003] ==> [Specified driver could not be loaded due to system error 126 (Teradata).]

[Thu Aug 11 09:16:57 2011] Info(1021014)
ODBC Layer Error: Native Error code [160]

Changes

Essbase v9.3.1 configuration with Teradata works, but using the same supported drivers and settings Essbase v11.1.2.1 returns errors.

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