TM1 Server Save headaches

[robchr]

I've noticed that on 9.1.4 every time I do a server save (after some recent changes, like adding two elements and some cube rules) that these changes disappear completely if I bring down the server and start it back up. I have to retrace my steps and it is getting annoying.

Do you think this may have something to do with the BLB files? Has anyone else experienced this? I did check to see if there are dim$ and rux$ files and indeed there are. Is server save just a pretend function or does it actually do anything?

[Martin Erlmoser]

1. shut down the tm1server
2. make a backup of your database
6. check if the files which cause the problem are read only, or have strange security settings
3. rename the files which have a $ version to .whatever or move them out of the directory
4. rename the .dim$, cub$ and so on to .dim .cub and so on.
5. start the tm1server

[kpk]

1. shut down the tm1server
2. make a backup of your database
6. check if the files which cause the problem are read only, or have strange security settings
3. rename the files which have a $ version to .whatever or move them out of the directory
4. rename the .dim$, cub$ and so on to .dim .cub and so on.
5. start the tm1server

... and probably you need to check your log files and load back some data from them if you are not lucky.
When you have a cu$ file then the server can not save the data from the RAM to the cub file.
Therefore it is better to export those cubes into ASCII files before you shut down the server FIRST!
After a shut down you can only works with your log files and usually it is not easy to figure out for which log files you need to roll back.

[Jeroen Eynikel]

I've noticed that on 9.1.4 every time I do a server save (after some recent changes, like adding two elements and some cube rules) that these changes disappear completely if I bring down the server and start it back up. I have to retrace my steps and it is getting annoying.

Do you think this may have something to do with the BLB files? Has anyone else experienced this? I did check to see if there are dim$ and rux$ files and indeed there are. Is server save just a pretend function or does it actually do anything?

You are losing metadata changes? Afaik savedataall does nothing with metadata, it only commits data changes to disk. Metadata changes are commited immeadiately. If you have no corrupted files in your directory the only thing I can think off is that the server can not access the datadirectory for some reason. Is it on the server itself or on a network drive?

Also - just to make sure - you are not using dimension worksheets and have someone else doing the same but with another local directory are you?

[robchr]

I've noticed that on 9.1.4 every time I do a server save (after some recent changes, like adding two elements and some cube rules) that these changes disappear completely if I bring down the server and start it back up. I have to retrace my steps and it is getting annoying.

Do you think this may have something to do with the BLB files? Has anyone else experienced this? I did check to see if there are dim$ and rux$ files and indeed there are. Is server save just a pretend function or does it actually do anything?

You are losing metadata changes? Afaik savedataall does nothing with metadata, it only commits data changes to disk. Metadata changes are commited immeadiately. If you have no corrupted files in your directory the only thing I can think off is that the server can not access the datadirectory for some reason. Is it on the server itself or on a network drive?

Also - just to make sure - you are not using dimension worksheets and have someone else doing the same but with another local directory are you?

It's a network directory, not local to the server.

[Jeroen Eynikel]

I would check with IT first then whether there have been any connection losses to the fileserver.

Edit: also if you have a virusscanner running, exclude the TM1 data directory from the scans.