Renaming .cub$ files for restart

[fleaster]

Hi all,
I've recently had an issue with a .cub file being locked ("Fin_GL.cub"), which has prevented us from doing a Save data - however, I cannot find the process causing it (have tried using Process Explorer utility already)

...so as a final resort I am considering a complete server reboot. My plan is to:

1. restart the server
2. rename Fin_GL.cub to Fin_GL.cub.old
3. rename Fin_GL.cub$ to Fin_GL.cub
4. bounce the tm1 service

My question is whether this guarantees that no data will be lost, or whether there is still a risk of losing data?

Also, what do the files represent with the date extension (e.g. Fin_GL.cub.201412151334) - are these some sort of interim backups?

Thanks!

Matt

Code: Select all

19/12/2014  10:25 AM     1,699,940,140 Fin_GL.cub
23/12/2014  10:49 AM     1,698,769,664 Fin_GL.cub$
15/12/2014  01:34 PM     1,696,663,388 Fin_GL.cub.201412151334
17/12/2014  01:35 PM     1,699,731,271 Fin_GL.cub.201412171222

[upali]

Hi Matt,

We had a similar issue very recently. In our case the time difference between our CUB file and CUB$ file was about 3 weeks. We just didn't notice issue.

Anyway the best approach to aviod data loss was to use Process Explorer to unlik the CUB$ file from the TM1S process and then delete the file. Then you'll be able to call SaveDataAll.
However, as plan B, we took ASCII exports of all the cube data. So that if a data reload was required it could be done. Fortunately we didn't have to do that.

Hope this helps...

[gtonkin]

Hi Matt,

Your previous post had a reference to the cube as

\\apaustmp01\tm1\systemfiles\production\prod_data\Fin_GL.cub$$$

Are there two servers in the equation - the application and data?
Have you checked for locks, anti-virus exclusions etc. on both?

[fleaster]

Actually I hadn't thought about application vs data server...

...in any case, I ended up bouncing the service and renaming the $ file, which seems to have worked this time at least