TM1 Forum

Hello,
I have a a cube feeds with flat files by TI but without chore, however the cube is cleared and empty every day. How can it be possible ?
I use Active Forms,

Many thanks for your help,

Jon

If there is no chore how do you run the TI process that loads the data? Do you run it manually every day? Do you ever issue a SaveDataAll command to save your cubes to disk or is it scheduled in your TM1S.cfg file? Do you have your TM1 server service set to stop and restart each day?

tomok wrote:If there is no chore how do you run the TI process that loads the data? Do you run it manually every day?

Yes tomok, manually, I do not use chore until the bug is fixed.

tomok wrote: Do you ever issue a SaveDataAll command to save your cubes to disk or is it scheduled in your TM1S.cfg file?

I don't think I used the SaveDataAll command.

tomok wrote: Do you have your TM1 server service set to stop and restart each day?

Yes.

There is a TI SaveDataAll that you can add to the last process you run. Do you run them all at the processes at the same time? If so why don't you add them all to chore, keeping it inactive? You can then just run that. If not why don't you add a chore that runs a save each night before the services are stopped if you don't fancy playing around with you cfg.

Have you looked in the audit log to see when the data is being changed back to zero?

Martin

Martin Ryan wrote:Have you looked in the audit log to see when the data is being changed back to zero?

He's losing data because he's loading the data via a TI process (which turns logging off by default), never issuing a Save command, and then recycling the TM1 service each night.

tomok wrote: He's losing data because he's loading the data via a TI process (which turns logging off by default), never issuing a Save command, and then recycling the TM1 service each night.

Recycling the server automatically saves all the data to disk. So either the server is actually crashing instead of recycling, or the data has been zeroed out somehow. Which may well be in the log.

And Jon, if you have left the default "Turn logging off" in the TI process as tomok asserts, then turn it on. (There's always a debate on this topic but my view is always have logging on unless you have a good reason to turn it off.)

Martin

Martin Ryan wrote:

tomok wrote: He's losing data because he's loading the data via a TI process (which turns logging off by default), never issuing a Save command, and then recycling the TM1 service each night.

Recycling the server automatically saves all the data to disk.

It certainly attempts to. Though I know in my own case the data save takes so long that Windows will just complain that the service is "not responding in a timely manner" and kill it while the data save is going on, which is why I manually force a data save before I do a service shutdown. If this is happening there should be some .cu$ files (the ones that the data is saved to before they're copied over the top of the original .cub files) floating around the data directory.

Martin Ryan wrote: So either the server is actually crashing instead of recycling, or the data has been zeroed out somehow. Which may well be in the log.

And Jon, if you have left the default "Turn logging off" in the TI process as tomok asserts, then turn it on. (There's always a debate on this topic but my view is always have logging on unless you have a good reason to turn it off.)

My own rule of thumb is that if I'm frequently zeroing out and reloading the data then it's off (otherwise you end up with gigabytes of log files in no time), if I'm doing a single load it's on. Though even this has some exceptions; in the case of a zero out / upload that we do only once per month, I leave it on.

The big thing that you have to watch out for is that unless the data is easy to reproduce and is regularly reproduced (such as an interface from the GL system), you need to do a data save as soon as possible after an unlogged upload or it can make your life just that little bit harder. And if you're taking a "snapshot" of values? Always do a data save as soon as possible afterwards.

Alan Kirk wrote:

Martin Ryan wrote:

tomok wrote: He's losing data because he's loading the data via a TI process (which turns logging off by default), never issuing a Save command, and then recycling the TM1 service each night.

Recycling the server automatically saves all the data to disk.

It certainly attempts to. Though I know in my own case the data save takes so long that Windows will just complain that the service is "not responding in a timely manner" and kill it while the data save is going on,

I'd categorise that as a crash, rather than a recycle. Which is indeed possible, but a different problem.

I think the point is that there's still more information required in order to diagnose the problem.

Thanks Tomok, Jim, Alan and Martin, I added the savedataall function on TI and it works perfectly fine now.

(Is there any tag 'Resolved' or something like that for the thread ?)

Jonsulli wrote:Thanks Tomok, Jim, Alan and Martin, I added the savedataall function on TI and it works perfectly fine now.

Glad it's resolved.

Jonsulli wrote:(Is there any tag 'Resolved' or something like that for the thread ?)

No, it's more a discussion forum than a straight questions and answers forum, so threads aren't tagged like that. Sometimes a question will lead into a discussion, sometimes the discussion will start out being about the finer points of Web's config file and end up being about where the best cafes in downtown Budapest are. The thread just dies out when there's nothing more to say.