COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: Gollapudi on 17 Oct 2012 07:21:24 PM

Title: How do I identify if DB is Down and QUIT TI Process
Post by: Gollapudi on 17 Oct 2012 07:21:24 PM
Hi,

I have couple of TI process involved in updating a Dimension on daily basis..
one of them unwinds the hierarchies of dimension and then it fires another TI Process which fires an SQL Query to Oracle Database for the updated values.
Another will Construct the Hierarchies, it works fine if Database responds well.

But, in-case if DB is down...

1st TI Process will unwind the Hierarchies
2nd TI Process Will fail
3rd TI Process will construct Hierarchies and all goes under "Unknown"/"Orphans" level. :(

So now I am looking for some TI function or Technic where I can check the status of DB if its Up and running, if not wanted to Stop TI process (PROCESSQUIT) before its gonna unwind the dimension.

Appreciate your thoughts.