Cube present, but no element in }Cubes dimension

[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.

[jim wood]

I've never seen that but a quick restart of the service should resolve the issue,

Jim.

[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

[jim wood]

You're not perhaps using windows server 2008 r2 are you? Are the data directories within the progam files directory?

[holger_b]

It actually is windows server 2008 r2, but the data directory is on d:

[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.

[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.

[jim wood]

They'll probably tell you to upgrade. It seems to be the standard response at the moment.

[Duncan P]

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;

[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

[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

[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.

[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 )

[lotsaram]

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.

[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

[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