Page 1 of 1
Cube present, but no element in }Cubes dimension
Posted: Tue Sep 24, 2013 10:11 am
by holger_b
Did anybody ever see such a case: We create a cube in a process (no error message), we can "see" it in the architect, but there is no respective element in the }Cubes dimension. Of course there is a number of actions which we can not perform as a consequence.
Re: Cube present, but no element in }Cubes dimension
Posted: Tue Sep 24, 2013 12:33 pm
by jim wood
I've never seen that but a quick restart of the service should resolve the issue,
Jim.
Re: Cube present, but no element in }Cubes dimension
Posted: Tue Sep 24, 2013 1:25 pm
by holger_b
Quick restart means something like 180 minutes in this case - it is a planning system of a "real" big customer, but we are considering that
Still, in the meantime we found more funny issues around this: We can not create new cubes with a certain naming, others are no problem. It looks a bit like there was a limitation of how many cube names can start with the same six characters (in terms of maybe a hundred). This is really thrilling, and I will post here what we will have learned in the end.
Thank you
Holger
Re: Cube present, but no element in }Cubes dimension
Posted: Tue Sep 24, 2013 2:45 pm
by jim wood
You're not perhaps using windows server 2008 r2 are you? Are the data directories within the progam files directory?
Re: Cube present, but no element in }Cubes dimension
Posted: Tue Sep 24, 2013 3:31 pm
by holger_b
It actually is windows server 2008 r2, but the data directory is on d:
Re: Cube present, but no element in }Cubes dimension
Posted: Tue Sep 24, 2013 3:56 pm
by jim wood
I asked as I've seen some funnies like this and cubes not saving when in the program files directory due to windows security. Even when the progam files directory is not on C:. I always keep the data directory outside of any program files directory, no matter the drive,
Jim.
Re: Cube present, but no element in }Cubes dimension
Posted: Tue Sep 24, 2013 4:12 pm
by holger_b
That's good advice, I will try and remember it, even if it does not help today... The IBM support are now involved in this, let us see what they find out.
Re: Cube present, but no element in }Cubes dimension
Posted: Tue Sep 24, 2013 4:14 pm
by jim wood
They'll probably tell you to upgrade. It seems to be the standard response at the moment.
Re: Cube present, but no element in }Cubes dimension
Posted: Tue Sep 24, 2013 7:38 pm
by Duncan P
holger_b wrote:Still, in the meantime we found more funny issues around this: We can not create new cubes with a certain naming, others are no problem. It looks a bit like there was a limitation of how many cube names can start with the same six characters (in terms of maybe a hundred). This is really thrilling, and I will post here what we will have learned in the end.
I have just used a process in 9.5.2 FP3 HF7 on Win 2008 R2 to create 1000 cubes from 'qwerty_1' to 'qwerty_1000' with no problem. What version are you using?
Code: Select all
i = 0;
while ( i < 1000 );
i = i + 1;
name = 'qwerty_' | NumberToString( i );
CubeCreate( name, 's1', 'measures' );
end;
Re: Cube present, but no element in }Cubes dimension
Posted: Wed Sep 25, 2013 7:04 am
by holger_b
We run the same version: 9.5.20307.33647 (FP3, HF7). All kinds of cube names work (at least those we tried) except if they start with '}Hold_'. The cube seems to be there, but there is no element in the }Cubes dimension.
Regards
Holger
Re: Cube present, but no element in }Cubes dimension
Posted: Wed Sep 25, 2013 9:46 am
by EvgenyT
Intersting... I tested what you were suggesting and worked fine for me }hold is there... Obviously you are doing it via TI? because if you do it manually, it wont let you since } is a special character.. Maybe thats where the problem is?
Tested on cx 10.1 and win 2008 rs datacenter btw
thanks
Re: Cube present, but no element in }Cubes dimension
Posted: Wed Sep 25, 2013 10:00 am
by holger_b
Yes, via TI. The funny thing is, it used to work for weeks, and we can not figure out yet why the problem occurred out of a sudden.
Re: Cube present, but no element in }Cubes dimension
Posted: Wed Sep 25, 2013 10:29 am
by holger_b
Today, the IBM support could reproduce the problem and will come back with a solution after they checked with development. (They did not use the word upgrade so far, Jim
)
Re: Cube present, but no element in }Cubes dimension
Posted: Wed Sep 25, 2013 10:42 am
by lotsaram
holger_b wrote:We run the same version: 9.5.20307.33647 (FP3, HF7). All kinds of cube names work (at least those we tried) except if they start with '}Hold_'. The cube seems to be there, but there is no element in the }Cubes dimension.
That might have been a piece of information worth leading with. "}Hold_" is not just any old same 6 characters! It designates a particular kind of control cube used to control spreading which are dynamically created by the server and should be cleaned up by background processes and on server restart.
Why would you be programatically creating }Hold_ cubes and for what purpose? If you are doing this it would presume you really know what you're doing, and I mean
really know what you are doing.
Re: Cube present, but no element in }Cubes dimension
Posted: Wed Sep 25, 2013 11:32 am
by holger_b
Lotsaram, of course you are right. I admit I did not have that piece of information myself - I am not too deep into this part of the project, I was just trying to support my colleagues and find some helpful information. In fact, this is about a pretty sophisticated planning application which does a few things beyond the standard TM1 planning functionality, be it spreading or workflow - designed by a few guys who really know what they are doing I bet.
Sorry if I wasted anybody's time! Anyhow, I will keep you posted what becomes of it.
Regards
Holger
Re: Cube present, but no element in }Cubes dimension
Posted: Thu Sep 26, 2013 10:01 am
by holger_b
Here is what development answered: As of 2009, }Hold cubes do not appear any more as elements in the }Cubes dimension, in order to avoid bottlenecks and the flooding of this dimension. However, if there are remaining }Hold cubes during server restart, they will show up in the }Cubes dimension.
Thanks to all
Holger