Subsets locked by phantom views

Post Reply
steve_h
Posts: 3
Joined: Fri Mar 19, 2010 2:49 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Subsets locked by phantom views

Post by steve_h »

I've encountered this problem for years, and am wondering if anyone has come up with a solution for this.

Here's an example.

I create a drill through process that will create a unique view and unique set of subsets upon execution.

I've created a nightly cleanup chore to delete all unique views and subsets.

All views destroy correctly.

All subsets do not destroy and process will error out. The error being the subset can not be deleted because it is being used by a view. Which, of course, it is not.
This tends to occur more often when I'm using MDX to create the subsets.

Has anyone found a solution to this issue that doesn't require restarting the service?

Thanks.
John Hammond
Community Contributor
Posts: 296
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Subsets locked by phantom views

Post by John Hammond »

I have also encountered the ghost in the machine.

Unloading and reloading the cube that owns the view may be less drastic than restarting the service.
steve_h
Posts: 3
Joined: Fri Mar 19, 2010 2:49 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: Subsets locked by phantom views

Post by steve_h »

Thanks John. Good suggestion. Unfortunately the cube would take about 15 minutes to come back up, by as last resort, might not be another option.

Was hoping the issue had been addressed by now, or at least have some type of workaround to be able to delete them.
John Hammond
Community Contributor
Posts: 296
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Subsets locked by phantom views

Post by John Hammond »

Just remembered something - I think if you use a TI function to do the delete,as opposed to the user interface, the subset will go. I not 100% sure but it might be worth a try...
steve_h
Posts: 3
Joined: Fri Mar 19, 2010 2:49 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: Subsets locked by phantom views

Post by steve_h »

I am attempting to destroy via TI. I submitted a bug to IBM.

Thanks for the help.
User avatar
Alan Kirk
Site Admin
Posts: 6611
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Subsets locked by phantom views

Post by Alan Kirk »

steve_h wrote:I've encountered this problem for years, and am wondering if anyone has come up with a solution for this.

Here's an example.

I create a drill through process that will create a unique view and unique set of subsets upon execution.

I've created a nightly cleanup chore to delete all unique views and subsets.

All views destroy correctly.

All subsets do not destroy and process will error out. The error being the subset can not be deleted because it is being used by a view. Which, of course, it is not.
This tends to occur more often when I'm using MDX to create the subsets.

Has anyone found a solution to this issue that doesn't require restarting the service?
I've found instances of this when I've been testing the creation of a view via TI, and have looked at the view and possibly exported it in the process of doing so. (This isn't always the trigger, but as a "for instance".) It appears that somehow my client session gets ahold of the subset. As long as that client session remains alive, I can't delete the subset. Not manually, not by TI. As soon as I kick over my Excel session, the TI code to delete it will run without errors.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
cycleman83
Posts: 8
Joined: Mon Apr 13, 2009 2:36 pm
OLAP Product: Tm1
Version: 9.5.2
Excel Version: 2007

Re: Subsets locked by phantom views

Post by cycleman83 »

I'm having this same issue... Using v9.5.2

I dynamically create subsets and views as part of a drill process, then I have a process scheduled to delete all of the views and subsets that have been created.

The views delete without any issues. Then when I try to delete the subsets, I get an error saying the subsets are used by a view.

Has anyone had any luck with resolving this issue since the last post?
User avatar
Steve Rowe
Site Admin
Posts: 2429
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Subsets locked by phantom views

Post by Steve Rowe »

This is a version related bug that has dropped in out of the system over the years. If you are on a version that suffers from the issue you don't have too many options.
Of course you need to be 100% sure that your aren't using the subset in view, but if you are creating all the objects dynamically in a TI you can be sure.
Current version don't suffer from the issue, but different version of 9 did an didn't....
Technical Director
www.infocat.co.uk
Boas
Posts: 16
Joined: Mon Sep 07, 2020 12:54 pm
OLAP Product: Planning Analytics
Version: 2.0.8
Excel Version: MS 365

Re: Subsets locked by phantom views

Post by Boas »

Hi everybody,

although this topic is very old and claimed to be solved, I struggled this issue several times in several versions.
Looks like IBM did not really solve this bug in a sustainable way:
https://www.ibm.com/support/pages/apar/PI97815

Currently, I got this issue in version 11.8.01200.7, i.e. 2.0.9.13.

Cube unload and reload did not help...

I'm afraid, there is no smart idea by someone in the community?
Wim Gielis
MVP
Posts: 3140
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Subsets locked by phantom views

Post by Wim Gielis »

That version is 2 years old, maybe it’s solved in the meantime ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Boas
Posts: 16
Joined: Mon Sep 07, 2020 12:54 pm
OLAP Product: Planning Analytics
Version: 2.0.8
Excel Version: MS 365

Re: Subsets locked by phantom views

Post by Boas »

HI community,

meanwhile I was in contact with the IBM support. We examined that it was possible to delete the subsets after a re-login. And a chore was also able to delete the subsets.

But the whole issue was fixed in version Workspace version 2.0.94:
https://www.ibm.com/support/pages/apar/PH58579
Post Reply