TM1 Forum

Hello Everyone,

I would like to know if anyone knows about a TI Prolog command that I can use to test if my ODBC Connection works before I start running the Process. The problem is that I clear out all my data in the Prolog section and then when the process continues it sometimes happen that the process was not able to connect to the ODBC datasource.

This leaves me with cubes with no data in and very frustrated clients!!

Thank you!

I guess you could always set the odbc as the datasource in the front and add a very simple select * from a say a small table. It's a prolog test but it should test your odbc connection.

par3 wrote: I would like to know if anyone knows about a TI Prolog command that I can use to test if my ODBC Connection works before I start running the Process. The problem is that I clear out all my data in the Prolog section and then when the process continues it sometimes happen that the process was not able to connect to the ODBC datasource.

This leaves me with cubes with no data in and very frustrated clients!!

I use a pair of processes. (Though with the execute process command in version 9 I could get away with using just one plus some parameters, but that's neither here nor there.)

The first process, which runs a very simple and fast scalar query, sets a parameter in our chore control cube to "N" in its Prolog. The Data tab, which will only be executed if that value is returned, contains a CellPutS statement which sets the control cube value to "Y".

The second process, which does the actual work, checks the control cube and will only execute if the value is Y, otherwise it just quits.