xxx.cub$

[yuval]

Hi,

Today I've opened tm1 model and noticed that one of the cubes was disappeared,
I looked in data directory and saw the the cube file (cube_name.cub$),
I know that extension with "$" in an error, how can I recover it?
why it happened?

Thanks

[lotsaram]

When a save data operation is in progress cubes are incrementally written to temporary <cube name>.cub$ files. Once the cub$ file is complete the last thing the tm1 server does is to delete the .cub file and then rename the .cub$ file. If there is any issue with obtaining write locks then sometimes the file rename can fail. In your case since there is no .cub file you should be in luck since this should indicate that the .cub$ file is a complete file and not a partial temp file (otherwise the .cub file would not have been deleted).

To restore:
1/ stop the tm1 service
2/ rename the .cub$ file by removing the $
3/ restart the service

If the file is complete then things will be back to normal. If the file is not complete then the load will error and you will probably be back in the same situation of the cube being gone. In this situation you go back to a nightly backup (you do of course have a nightly backup?). But I woudl guess you should be OK since in theory the .cub file should not be deleted by the server during the save process until the .cub$ file is complete and ready to be renamed.

[yuval]

suceeded to restore by changing the name,
thanks for great explanation