tm1 logfile error on ODBC_IM002

Post Reply
ravi
Posts: 138
Joined: Mon Apr 26, 2010 12:39 pm
OLAP Product: cognos
Version: tm1 9.5
Excel Version: 2007

tm1 logfile error on ODBC_IM002

Post 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,
dan.kelleher
Community Contributor
Posts: 128
Joined: Wed Oct 14, 2009 7:46 am
OLAP Product: TM1
Version: 9.4
Excel Version: 11
Location: London

Re: tm1 logfile error on ODBC_IM002

Post 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?
Post Reply