Error during modify existing TI Data Source

Post Reply
hadzri712
Posts: 7
Joined: Mon Jul 31, 2017 7:31 am
OLAP Product: n.a
Version: TM1 10.2.2
Excel Version: MS Office 2010

Error during modify existing TI Data Source

Post by hadzri712 »

Hi,

I encounter error while changing my data source connection at existing TI process.

Currently I am using Oracle 11g database and moving to Oracle 12c database. Client connection has been install/setup and it work fine using normal SQL developer(direct query). Even creating new TI, I able to select and query the new Oracle 12c DB connection/data.

The issue only exist during modify the current existing TI process that connect to data source 11g. Error log as per below.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
15624 [4f] ERROR 2017-08-17 02:17:03.044 TM1.SQLAPI IM003Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraClient12Home1, E:\Oracle\product\12.1.0\client_1\BIN\SQORA32.DLL).
15624 [4f] ERROR 2017-08-17 02:17:03.044 TM1.SQLAPI E16) Cannot connect to ODBC data source "ICSS TEST" IM003Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraClient12Home1, E:\Oracle\product\12.1.0\client_1\BIN\SQORA32.DLL)..
15624 [4f] ERROR 2017-08-17 02:17:03.044 TM1.SQLAPI 08003[Microsoft][ODBC Driver Manager] Connection not open
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Kindly need advice.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Error during modify existing TI Data Source

Post by gtonkin »

May be worthwhile checking that you are connecting to the 64-bit Oracle/ODBC drivers-assuming you are running 64-bit TM1.
Post Reply