Page 1 of 1

tm1 logfile error on ODBC_IM002

Posted: Fri Feb 07, 2014 10:00 pm
by ravi
Hi All,

I have noticed in tm1 server log error like below.

8072 [5f] ERROR 2014-02-07 10:18:35.044 TM1.SQLAPI IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
8072 [5f] ERROR 2014-02-07 10:18:35.044 TM1.SQLAPI E16) Cannot connect to ODBC data source "DWPRD" IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
8072 [5f] ERROR 2014-02-07 10:18:35.044 TM1.SQLAPI 08003[Microsoft][ODBC Driver Manager] Connection not open
8072 [5f] ERROR 2014-02-07 10:18:35.044 TM1.SQLAPI IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
8072 [5f] ERROR 2014-02-07 10:18:35.044 TM1.SQLAPI E16) Cannot connect to ODBC data source "DWPRD" IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

There are couple of TI processes which looks for data source for "DWPRD" -
1) My question is I am not excecuting these processes either by manually or scheduled chores.
2) Do not see any process/chores failure due to this issue. But
* It is causing delay in excecuting the others processes and chores
Please advise.
Regards,

Re: tm1 logfile error on ODBC_IM002

Posted: Mon Feb 10, 2014 9:57 am
by dan.kelleher
I think you sometimes get these errors when you open a TI process for editing and there is an issue with the ODBC connection/ SQL. Is this something that may have occurred?