TM1 Forum

Has anyone ever experienced data loss between a server backup and restart?

We have users that have entered data on day 1 and overnight the only action that occurs is a TM1 Service Stop, Data Directory Zip, and TM1 Service Start. By the next morning the some of the data they entered doesn't exist. The TM1S log file with the timestamp from the time of the backup shows the transactions where the user entered the data but when we look in the cube there is no data.

I can't figure out why this would happen where some entries would still exist but others don't?

The current backup is run through a bat file and scheduled using windows scheduler. The TM1 documentation says that restarting the TM1 Windows Service forces a save data but Im thinking of changing the backup process to run out of TI so I can force the SaveDataAll before I restart the windows service.

Any thoughts would be greatly appreciated

PlanningDev wrote:The current backup is run through a bat file and scheduled using windows scheduler. The TM1 documentation says that restarting the TM1 Windows Service forces a save data but Im thinking of changing the backup process to run out of TI so I can force the SaveDataAll before I restart the windows service.

Any thoughts would be greatly appreciated

Restarting the TM1 service with a net stop command is not recommended unless you have first executed a SaveDataAll! If the server has a lot of cubes to save to disk and is busy saving while Windows is waiting for the service to "stop normally" then the OS may decide that the service is taking too long to stop and is "unresponsive" and terminate the service (the equivalent of killing a process via task manager) in which case the save will not finish. If the data is already saved then the service will be able to stop quickly and avoid this problem.

However you say the logs are in a time-stamped tm1s.log file which would indicate that the save should have occurred as the tm1s.log file should only be time-stamped after all .$cub files have been written and converted to .cub files. This sounds a little strange.... To start with a good idea to save data before pulling the rug out from under TM1.

If I run the backup through the TI will it wait for the SaveDataAll to complete before it executes the next line which would be the .bat file? Or do I need to put the SaveDataAll in section before the command line execute.?

PlanningDev wrote:If I run the backup through the TI will it wait for the SaveDataAll to complete before it executes the next line which would be the .bat file?

Yes TI executes each line sequentially and the action must complete before proceeding. The only time this is not true is when using ExecuteCommand and specifying not to wait.