TM1 Forum

All Experts,

After updated the SSL certificate in one of my production server, I had changed the date of my production server to November 26 2016 to see whether everything will functioning or not and during that particular time one of my chore was running automatically that i can see it from my tm1server logs and later next day I got email from business that one of the cube got lost the data. May I know is this because of changing the server time during process running time caused the issue?
Experts please share your ideas/experiences on the same, if you would have faced ?

So let me get this straight. You set the date forward on a production server? While everything was running?

let's just let that sink in.

mincharug.shulft wrote:All Experts,

After updated the SSL certificate in one of my production server, I had changed the date of my production server to November 26 2016 to see whether everything will functioning or not and during that particular time one of my chore was running automatically that i can see it from my tm1server logs and later next day I got email from business that one of the cube got lost the data. May I know is this because of changing the server time during process running time caused the issue?
Experts please share your ideas/experiences on the same, if you would have faced ?

Lotsa beat me to the punchline; no IT professional would have any experience of this because they would not - ever - do that in a production environment.

But let's think about it for a minute.

Is a different date on the server going to make loaded N level data disappear? No, there is absolutely no reason why it would by itself.

But could it make rules derived data disappear? Potentially, yes. If you had a rule which ran along the lines of "If date > month end THEN use actual data, ELSE use forecast data", and the actual data had not been loaded yet then boom, goodbye to the rules-derived values. This is an example only. I would be looking for any date-sensitive rules. Actually what I would be doing first is resetting my server back to the correct time which may make this redundant if this is the cause.

Similarly if you had a TI process which copies data from actuals after month end, and the server now thinks that it IS after month end, then the process may well be copying zeroes.

Those would be my two best guesses.

Thanks lotsaram, alan,

Thank you so much for quick response really good explaning you had provided.

Could you please help me out, I ran the TI Process from Perfomance Modeler and i need to see the logs, where can i see it.

Alan Kirk wrote:

mincharug.shulft wrote:All Experts,

After updated the SSL certificate in one of my production server, I had changed the date of my production server to November 26 2016 to see whether everything will functioning or not and during that particular time one of my chore was running automatically that i can see it from my tm1server logs and later next day I got email from business that one of the cube got lost the data. May I know is this because of changing the server time during process running time caused the issue?
Experts please share your ideas/experiences on the same, if you would have faced ?

Lotsa beat me to the punchline; no IT professional would have any experience of this because they would not - ever - do that in a production environment.

But let's think about it for a minute.

Is a different date on the server going to make loaded N level data disappear? No, there is absolutely no reason why it would by itself.

But could it make rules derived data disappear? Potentially, yes. If you had a rule which ran along the lines of "If date > month end THEN use actual data, ELSE use forecast data", and the actual data had not been loaded yet then boom, goodbye to the rules-derived values. This is an example only. I would be looking for any date-sensitive rules. Actually what I would be doing first is resetting my server back to the correct time which may make this redundant if this is the cause.

Similarly if you had a TI process which copies data from actuals after month end, and the server now thinks that it IS after month end, then the process may well be copying zeroes.

Those would be my two best guesses.

mincharug.shulft wrote:All Experts,

After updated the SSL certificate in one of my production server, I had changed the date of my production server to November 26 2016 to see whether everything will functioning or not and during that particular time one of my chore was running automatically that i can see it from my tm1server logs and later next day I got email from business that one of the cube got lost the data. May I know is this because of changing the server time during process running time caused the issue?
Experts please share your ideas/experiences on the same, if you would have faced ?

I faced the same issue. One of the user had enter the data in to input cube but not submitted or committed. When he check today, there was no data which he inputted. I went to tm1s.log file and retrieved all the data.

Would like to know is it because of TM1 SSL update? I want to add more here that the user had seen the inputted data on Wednesday evening.

Please throw some lights.

Was the server and admin server shutdown cleanly before updating the certificates?
If the certificates were applied whilst running, possible that data could not be written back.

I think when somebody set the date forward with servers runing, all the chores would start working. One of them could zero out the data

gtonkin wrote:Was the server and admin server shutdown cleanly before updating the certificates?
If the certificates were applied whilst running, possible that data could not be written back.

Yes. Everything else working fine. All the data which were submitted is good. Two user just entered the data but did not submit or commit the data. They were blue. I retrieve those from system generated sandbox log. I opened the PMR with IBM as well.

@Elessar

We do not use chore at all. We are using batch files instead.

Even though services are restart the data should not be affected. The data in blue should be available for that specific user.

What i found:

I ask the user to log in to architect on my machine. I went to that cube view and went sand box option. One system generated sandbox were found with all data changes.
I am still keen to know which activity could have affect this behavior?

I will update once the PMR will be resolved.

Thank You

Dharav