HI All,
Need your help in fixing an issue which I am facing very frequently.
I do not get able to Create Subset/View, even when I have FULL ADMIN RIGHTS (both in Server and TM1 instance)
Upon checking the DATA DIRECTORY, found that subset / View folder doesnt exist there but is visible (Check the screenshot attached)
To fix this I have to RESTART my TM1 Instance, but I cant Restart the server everytime.
How to fix this ?
Thanks in advance.
Unable to delete Vues Folder in Data Directory - Even when I have FULL ADMIN rights
-
- Posts: 100
- Joined: Wed Apr 03, 2019 12:10 am
- OLAP Product: IBM PA
- Version: 2.0.9.x
- Excel Version: Microsoft 365 x64
Re: Unable to delete Vues Folder in Data Directory - Even when I have FULL ADMIN rights
What error message do you get in tm1server.log?
Separately, are you trying to delete the }vues folder while the TM1 server is running?
Take care.
Adam
Adam
-
- Posts: 45
- Joined: Fri Apr 17, 2015 5:55 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2013
Re: Unable to delete Vues Folder in Data Directory - Even when I have FULL ADMIN rights
Srry I have already cleared the logs (as file size was very big), will check and share if next time I will get the same issue.
Yes I am trying to DELETE the }vues Folder while TM1 Server is running
I cant even open this PARTICULAR folder as of now, while in other files/folders (under data directory) I dont have any issues even when server is running
I feel this vues folder is got created by some process (and all vues already got cleared in Epilog section) but this folder still virtually remains, hence not able to delete/open.
Yes I am trying to DELETE the }vues Folder while TM1 Server is running
I cant even open this PARTICULAR folder as of now, while in other files/folders (under data directory) I dont have any issues even when server is running
I feel this vues folder is got created by some process (and all vues already got cleared in Epilog section) but this folder still virtually remains, hence not able to delete/open.
-
- Posts: 100
- Joined: Wed Apr 03, 2019 12:10 am
- OLAP Product: IBM PA
- Version: 2.0.9.x
- Excel Version: Microsoft 365 x64
Re: Unable to delete Vues Folder in Data Directory - Even when I have FULL ADMIN rights
This would be most helpful, since you're getting errors but we're not sure yet which ones (besides Windows).
It's not a good practice to delete tm1 server files/folders while tm1 server is running.
When you delete a .vue (classic view) or an .xbv (MDX view) in Windows, even if Windows lets you, the entry for these views in the }Views_CubeName dimension is not removed, so when attempting to save another view with the same name, you may get errors. Think you will need to restart your tm1 server to get it in working shape, then delete using the below going forward.
Try deleting view either in GUI or by always having this in your TI process:
Code: Select all
If(ViewExists(cCubeName, cViewName) = 1);
ViewDestroy(cCubeName, cViewName);
EndIf;
Take care.
Adam
Adam
-
- Posts: 45
- Joined: Fri Apr 17, 2015 5:55 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2013
Re: Unable to delete Vues Folder in Data Directory - Even when I have FULL ADMIN rights
Thanks Adam,
Yes we already have this code in all our processes.
bt in few cubes (for views) and in few dimensions (for subsets) we get below mentioned error
Reason same as mentioned in main post.
Subset/View folder doesnt exists in server but is visible and we are not able to delete that too manually. (only with Server restart we can do that)
Yes we already have this code in all our processes.
bt in few cubes (for views) and in few dimensions (for subsets) we get below mentioned error
Reason same as mentioned in main post.
Subset/View folder doesnt exists in server but is visible and we are not able to delete that too manually. (only with Server restart we can do that)
-
- Posts: 100
- Joined: Wed Apr 03, 2019 12:10 am
- OLAP Product: IBM PA
- Version: 2.0.9.x
- Excel Version: Microsoft 365 x64
Re: Unable to delete Vues Folder in Data Directory - Even when I have FULL ADMIN rights
I think some of the more seasoned TM1ers will need to weigh in as I’ve never seen this before in routine operation.
I’m wondering if it has something to do with .VUE being deleted from the data directory, which as I mentioned is not a good practice.
I’m wondering if it has something to do with .VUE being deleted from the data directory, which as I mentioned is not a good practice.
Take care.
Adam
Adam
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Unable to delete Vues Folder in Data Directory - Even when I have FULL ADMIN rights
I have seen this when a views folder contains .xbv views (MDX created e.g. through ViewCreateByMDX or PAW views etc.)
If you manually delete the views folder while the server is still running there is a disconnect where TM1 gets confused by thinking that the folder already exists, so it tries to save a view in the folder that isn't actually there.
I don't think I've seen it how you have where the folder is actually visible, but from the error message when you try to delete it - you can tell windows has a problem with the folder not REALLY existing.
Either way long story short, do not delete any subfolders in the data directory while the TM1 service is running.
TM1 will on its own delete a view folder if you delete all the views in it (using the GUI) - but I must be honest that I have seen it fail to do this sometimes.
But any cleanup maintenance etc that is required should be done on a stopped service otherwise you will likely run into issues.
If you manually delete the views folder while the server is still running there is a disconnect where TM1 gets confused by thinking that the folder already exists, so it tries to save a view in the folder that isn't actually there.
I don't think I've seen it how you have where the folder is actually visible, but from the error message when you try to delete it - you can tell windows has a problem with the folder not REALLY existing.
Either way long story short, do not delete any subfolders in the data directory while the TM1 service is running.
TM1 will on its own delete a view folder if you delete all the views in it (using the GUI) - but I must be honest that I have seen it fail to do this sometimes.
But any cleanup maintenance etc that is required should be done on a stopped service otherwise you will likely run into issues.
Declan Rodger