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.
Error during modify existing TI Data Source
- gtonkin
- MVP
- Posts: 1199
- 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
May be worthwhile checking that you are connecting to the 64-bit Oracle/ODBC drivers-assuming you are running 64-bit TM1.