User Communication of Outages

Post Reply
kkmk
Posts: 73
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

User Communication of Outages

Post by kkmk »

Hi,

I want to inform the users about the outages of TM1 application. How can i automate this outage, and this I want to update to our TM1 webpage? How to write a process to check the outage?

Thanks
KKMK
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: User Communication of Outages

Post by jim wood »

I guess you could deploy a file to a directory before closing the service down using a process. If you're good with web code you could pick up the file content and update time / date and deploy it to your site. You could even generate an email from a process. Thinking as I type, I guess you could use a batch file to stop the service and kick of the processes I just mentioned.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: User Communication of Outages

Post by tomok »

kkmk wrote:Hi,

I want to inform the users about the outages of TM1 application. How can i automate this outage, and this I want to update to our TM1 webpage? How to write a process to check the outage?

Thanks
KKMK
Let's see, you want to notify users when TM1 is down, using TM1 (which by the way is down)?. Do you see the irony?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: User Communication of Outages

Post by jim wood »

Good point sir. The suggestions I made above were based on the assumption that we were talking about planned outages. I guess we could do with further clarification,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
George Regateiro
MVP
Posts: 326
Joined: Fri May 16, 2008 3:35 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007 SP3
Location: Tampa FL USA

Re: User Communication of Outages

Post by George Regateiro »

For unplanned outages we have the following.

A custom service written on the server the does a scheduled check of if the service is running? If yes it tries to login to TM1. If the service is down or the application cannot login to the server then it automates the use of the APP_OFFLINE.htm (google search will get you up to speed on how it works in IIS). This will take the webservers offline (with a published message) and will blast an email to the admins to see if further communication is needed.

For planned downtime's we use the APP_OFFLINE functionality to with parameters to give the users a time frame when accessing TM1Web.

We do not automate emails to the users since we want to control that communication.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: User Communication of Outages

Post by jim wood »

Nice solution George. Are you using another TM1 service for that or are you using a batch script or something of the sort?
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
George Regateiro
MVP
Posts: 326
Joined: Fri May 16, 2008 3:35 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007 SP3
Location: Tampa FL USA

Re: User Communication of Outages

Post by George Regateiro »

The service was written in .NET (with the classic API for the login part). If starting from scratch it may be easier to use the .NET API since it is out of the box more friendly and since all it does is login the limitations of the .NET API don't come into play. You can probably do it through batch scripts as well I just default to .net.

The scheduled downtime uses a custom service that uses the .NET framework file listener class. Our front end creates a file that is picked up by the web servers to take the website offline.
kkmk
Posts: 73
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Re: User Communication of Outages

Post by kkmk »

Thank you all for your valuable suggestions.

We want to communicate when an unplanned outage happened.

Can I get any help on how to write a service in .Net as mentioned by George?

Thanks
KKMK
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: User Communication of Outages

Post by David Usherwood »

There are powershell scripts floating around which deliver service status - eg
http://www.computerperformance.co.uk/ezine/ezine147.htm
Shouldn't be hard to customise to report the running status of your TM1 services.
kkmk
Posts: 73
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Re: User Communication of Outages

Post by kkmk »

I got some information from the below link on how to logon to TM1 using the script.

http://publib.boulder.ibm.com/infocente ... 71005.html

But digging more on how I can make this script as service that check TM1 server availability on a certain interval.

Thanks
KKMK
Post Reply