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

Post Reply
Stanislav2
Posts: 31
Joined: Tue Aug 20, 2013 5:53 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: -

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

Post 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
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

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

Post 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
Post Reply