E16) Cannot connect to ODBC data source "XXXX" S1C00[IBM][CLI Driver] CLI0150E Driver not capable.

[suman23479]

Hi Team,

I am receiving the error below in TM1SERVER.LOG file after migrating the TM1 instance from Dev to Production.
The node and databases are correctly catalogue in TM1 Server (AIX Environment)
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.

[tomok]

Any time you get an error message about ODBC drivers, etc., this means TM1 is complaining that you are running a query that your ODBC connection/driver can't support. I would take a look at the ODBC setups in the two instances (DEV and PROD) and find out what is different and fix. There is nothing you can do in TM1 to fix this.

[suman23479]

There is no diff in HOSTNAME. In dev it is FQDN and in Prod it is IP.
Is that make sense? Changing in prod will break other tm1 TI process which uses IP address.
Prod
Node name = CNDWSRV
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = 10.67.10.15
Service name = 50000

Dev
Node 3 entry:
Node name = DVDWSRV
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = adadevdwdb01.int.chickasaw.net
Service name = 50000