MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post Reply
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by Alan Kirk »

At midnight on 24 November, they just stopped working! Does anyone know why??? Please help me!!! :shock: :o

Sorry, I couldn't resist. But I'll bet this post has a decent chance of getting the highest number of hits in TM1 history. :twisted:

Well, here we are on 25 November and hey look, the sun is still coming up in the east. (Actually that's a slight fabrication. I get up to go to work at 03:20 so it's not quite here yet, but in both cases I'm playing the odds.)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by Steve Rowe »

I get up to go to work at 03:20.
Seriously?!?!
Technical Director
www.infocat.co.uk
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by declanr »

Steve Rowe wrote:
I get up to go to work at 03:20.
Seriously?!?!
Beat me to it.
Declan Rodger
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by Alan Kirk »

Steve Rowe wrote:
I get up to go to work at 03:20.
Seriously?!?!
Sadly, yes. It's about a 2 hour commute from here and you do not want to be on the peak hour trains on this line, believe me. Thankfully computers mean that I don't have to spend it staring at the walls but despite what Microsoft seems to assume with the way it has designed Office 2016 ("though shalt write to the cloud, and only the cloud") only about half of it has Interwebz access. Shower time!
25-Nov-16 03-40-59.jpg
25-Nov-16 03-40-59.jpg (141.07 KiB) Viewed 8960 times
On the main subject, interestingly I see that one testbed server that I didn't upgrade is still running, although it obviously isn't 25 November everywhere yet including, perhaps most importantly, UTC.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by declanr »

I thought it was a universal 16.45 gmt timestamp giving up the ghost?
Declan Rodger
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by Alan Kirk »

declanr wrote:I thought it was a universal 16.45 gmt timestamp giving up the ghost?
Could be; I just figured "get it out of the way early and it becomes academic".

It's now 17:10 universal and yup, the old testbed is dead. We await the onslaught of new account requests and posts from those who haven't been paying attention for the last few months with interest.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by declanr »

To the shelters!

I at least have the excuse that I am about to board a flight; so all comms about to go dark. Ghost protocol.
Declan Rodger
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by gtonkin »

Alan Kirk wrote:At midnight on 24 November, they just stopped working! Does anyone know why??? Please help me!!! :shock: :o
SOLVED - I have a workaround for you Alan.
Create a batch file called SSL_Patch.bat and put this into your TM1 Install folder with the following code:

Code: Select all

@echo off
set CurrDate=%date:~0,9%4
date %CurrDate%
Create a TI to

Code: Select all

ExecuteCommand('SSL_Patch.bat');
Schedule this as a chore to run each day just after midnight.
But be quick to implement, will only work if you implement before the 29th of this month - thereafter, you are on your own! :lol:
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by Alan Kirk »

gtonkin wrote:
Alan Kirk wrote:At midnight on 24 November, they just stopped working! Does anyone know why??? Please help me!!! :shock: :o
SOLVED - I have a workaround for you Alan.
Create a batch file called SSL_Patch.bat and put this into your TM1 Install folder with the following code:
Sounds too complicated. I just told the users to switch on the Emergency OLAP Backup System instead.
EOBS.jpg
EOBS.jpg (83.56 KiB) Viewed 8915 times
(You know George, part of me is worried (hmm, perhaps "worried" is not the right word here...) that there will be someone out there, probably a very "economically priced" consultant, who will actually take the suggestions in this thread and run with them... :twisted: )
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by stephen waters »

declanr wrote:
I at least have the excuse that I am about to board a flight; so all comms about to go dark. Ghost protocol.
I hope the airline upgraded its SSL certs before Declan's flight took off. Has he posted since?

We had our consultants and support guys in early today ( though not Alan early), ready to answer support calls from our customers but the phone lines are reassurringly quiet - so far.
Maybe we are just lucky or it could be the hundreds of emails and scores of phone calls we made to persuade our clients to take this seriously!
dsproffitt
Posts: 66
Joined: Wed Jul 16, 2014 9:20 am
OLAP Product: All of them
Version: All of them
Excel Version: 2003 -2013

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by dsproffitt »

Alan Kirk wrote:At midnight on 24 November, they just stopped working! Does anyone know why??? Please help me!!! :shock: :o
Dear Mr Kirk, Im sorry that you dont have a working system

Have you tried unplugging it and plugging it back in again?
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by Alan Kirk »

stephen waters wrote:
declanr wrote:
I at least have the excuse that I am about to board a flight; so all comms about to go dark. Ghost protocol.
I hope the airline upgraded its SSL certs before Declan's flight took off. Has he posted since?
He should be fine. I didn't have the heart to tell him that to be on the safe side they swapped his plane out for a surplus C-47 that was left over from D-Day. They pre-date SSL. Might take him a little longer than he expected to get to the destination though.
stephen waters wrote:We had our consultants and support guys in early today ( though not Alan early), ready to answer support calls from our customers but the phone lines are reassurringly quiet - so far.
Maybe we are just lucky or it could be the hundreds of emails and scores of phone calls we made to persuade our clients to take this seriously!
There may be another factor that George touched upon... it's Friday. And it's a week before calendar month end. For it to happen at this time may well be the exact inverse of a Perfect Storm... the Perfect Quiet Period. We shall see what happens when weekly reporting and end of month cycles kick in.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by Alan Kirk »

dsproffitt wrote:
Alan Kirk wrote:At midnight on 24 November, they just stopped working! Does anyone know why??? Please help me!!! :shock: :o
Dear Mr Kirk, Im sorry that you dont have a working system

Have you tried unplugging it and plugging it back in again?
I didn't know that you worked on a Help Desk!
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
dsproffitt
Posts: 66
Joined: Wed Jul 16, 2014 9:20 am
OLAP Product: All of them
Version: All of them
Excel Version: 2003 -2013

Re: MY TM1 SERVERS STOPPED WORKING AT MIDNIGHT ON 24 NOVEMBER

Post by dsproffitt »

Alan Kirk wrote:
dsproffitt wrote:
Alan Kirk wrote:At midnight on 24 November, they just stopped working! Does anyone know why??? Please help me!!! :shock: :o
Dear Mr Kirk, Im sorry that you dont have a working system

Have you tried unplugging it and plugging it back in again?
I didn't know that you worked on a Help Desk!
I help them out when they get busy ..
Post Reply