Page 1 of 1

How to get info from tm1server.log for which cube indivitual info is related to?

Posted: Tue Dec 13, 2016 2:15 pm
by Stanislav2
Hi,
in Cognos TM1 10.2.2 fixpack 6 I would like to monitor if Stargate views are created or not for my cube.

In tm1s-log.properties in my tm1 server I added:

Code: Select all

log4j.logger.TM1.Cube.Stargate=DEBUG
log4j.logger.TM1.Cube.Stargate.Reference=INFO
log4j.logger.TM1.Cube.Invalidation=DEBUG
Now I see something like:

Code: Select all

4792   [41]   DEBUG   2016-12-13 14:01:46.281   TM1.Cube.Stargate.Catalog   Adding stargate: 0x000000052B366810 to catalog: 0x0000000548F22C58 of cube: 0x0000000005A47010.
4792   [41]   DEBUG   2016-12-13 14:01:46.281   TM1.Cube.Stargate.ViewStorage   dbstgCreate: Stargate (0x000000052B366810) found in ViewStorage.
4792   [41]   DEBUG   2016-12-13 14:01:49.046   TM1.Cube.Stargate.Catalog   Adding stargate: 0x000000052B367810 to catalog: 0x0000000548F20458 of cube: 0x0000000005A47010.
4792   [41]   DEBUG   2016-12-13 14:01:49.046   TM1.Cube.Stargate.ViewStorage   dbstgCreate: Stargate (0x000000052B367810) found in ViewStorage.
6852   [42]   DEBUG   2016-12-13 14:01:53.312   TM1.Cube.Stargate.Catalog   Adding stargate: 0x0000000546223010 to catalog: 0x00000005452AB758 of cube: 0x0000000005A47010.
6852   [42]   DEBUG   2016-12-13 14:01:53.312   TM1.Cube.Stargate.ViewStorage   dbstgCreate: Stargate (0x0000000546223010) found in ViewStorage.
6852   [42]   DEBUG   2016-12-13 14:01:54.296   TM1.Cube.Stargate.Catalog   Adding stargate: 0x0000000546226210 to catalog: 0x00000005452AC058 of cube: 0x0000000005A47010.
6852   [42]   DEBUG   2016-12-13 14:01:54.296   TM1.Cube.Stargate.ViewStorage   dbstgCreate: Stargate (0x0000000546226210) found in ViewStorage.
From above I see "of cube 0x0000000005A47010".
How do I know for which cube are this logs?

I would like to check if VMM is sufficiently set in }CubeProperties cube or increasing value would benefit.
Regards

Re: How to get info from tm1server.log for which cube indivitual info is related to?

Posted: Tue Dec 13, 2016 8:42 pm
by EvgenyT
If memory servers me right, then TM1.Cube.Stargate.Definition will give you detailed definition of a star gate, as well as a cube name

Please let me know how you go


Cheers