The TM1 cube is empty after a reboot of the Microsoft Windows Server

Product:
Cognos TM1 version 9.5.1

Symptom:
The TM1 cube is empty after a reboot of the Microsoft Windows Server.

Background:
IT department is outsourced, and every weekend the servers are rebooted to apply Microsoft Patches and other updates. The reboot is done automatically by scripts.

Cause:
If the TM1 cube is large, the TM1 service does not have time enough to save data to disk when a reboot of the Microsoft Windows Server is executed.

Solution:
Create a batch file with this content;

net stop “Planning Sample”
net stop TM1ExcelService
net stop tm1admsd

Schedule that batch file to run 1 hour before any schedule reboot of the Windows Server.
This should give the TM1 service time to save any data.

In the Script replace the “Planning Sample” with the name of your TM1 services.
Because all TM1 services are set to Automatic startup type they will then start with the start of the Windows server.