TM1 ODBC Connection not working

[dan.kelleher]

Hi All,

I need some assistance with an issue we are experiencing on an ODBC connection on a Windows Server 2008 Enterprise 64-bit box. I have updated the TNSNAMES.ORA file to include the new data source in the correct location and have created a new system DSN. When I test the connection via the ODBC Data Source Adminstrator, it returns as "Connection successful".

However, when I try to connect via TM1 (TI Process), the connection fails with the following messagebox text:

"Unable to Open Connection to Database."

There is also the following error reported in the log files:

Code: Select all

9132   [dc]   INFO   2014-04-01 10:40:01.703   TM1.SQLAPI         Driver supports SQLFetchScroll
1000   [e7]   ERROR   2014-04-01 11:13:20.999   TM1.SQLAPI   08004[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified

1000   [e7]   ERROR   2014-04-01 11:13:20.999   TM1.SQLAPI   E16) Cannot connect to ODBC data source "XXX"  08004[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
.
1000   [e7]   ERROR   2014-04-01 11:13:20.999   TM1.SQLAPI   08003[Microsoft][ODBC Driver Manager] Connection not open

I can, however connect to other ODBC datasources absolutely fine.

I am using 64-bit ODBC drivers and a 64-bit TM1 server, version 10.2.00100.39992. TNSPing is fine and I can also SELECT * FROM DUAL fine using SQLPlus on the server.

The service is running as a local account.

Any help greatly appreciated.

Thanks,

Dan

[dan.kelleher]

This has been resolved, I believe by updating the connection information to include the fully-qualified DSN entry. Looks like TM1 requires this.

[suman23479]

Hi Dan,

I am receiving the similar issue. Can you please help in this regards??

4393 [23] INFO 2017-05-02 14:07:22.865 TM1.SQLAPI Checking Driver Capabilities for database "XXXX "
4393 [23] INFO 2017-05-02 14:07:22.865 TM1.SQLAPI Driver supports SQLFetchScroll
4393 [23] INFO 2017-05-02 14:07:26.026 TM1.Process Process "sys_Dim_DW": finished executing normally, elapsed time 9.51 seconds
4393 [23] INFO 2017-05-02 14:07:26.029 TM1.Process Process "sys_Check_Program_Dates" run from process "sys_Import_Main" by user "INT/Patrick Waldrop"
4393 [23] INFO 2017-05-02 14:07:26.035 TM1.Process Process "sys_SubsetCreate" run from process "sys_Check_Program_Dates" by user "INT/Patrick Waldrop"
4393 [23] INFO 2017-05-02 14:07:26.105 TM1.Process Process "sys_SubsetCreate": finished executing normally, elapsed time 0.07 seconds
4393 [23] ERROR 2017-05-02 14:07:26.110 TM1.SQLAPI S1C00[IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00
4393 [23] ERROR 2017-05-02 14:07:26.110 TM1.SQLAPI E16) Cannot connect to ODBC data source "XXXX" S1C00[IBM][CLI Driver] CLI0150E Driver not capable.