Hello,
My OLAP is on a server and connected to a DB. Sometimes the OLAP stops working and no data is available from the DB.
I wrote a script in Perl, which checks if the OLAP service is stopped or not. If so, I restart it with "net start" command. It works!
The problem is, that OLAP can be in a "NOT RESPONDING" mode, which I don't know how to "catch" this status and restart it.
Please help.
(Opening a session between client and OLAP server won't work, since sometimes the phisycal port can be created, but the OLAP server may have logical problem)
Please help me find a way to know if my OLAP server is in a "not responding" status.
Thank you in advance,
shmupi