Filtering in Cognos Insight (Connected) crashes serv ...

koko33777

Hello all experts

I have created a TM1 application which has a market dimension as approval hierarchy. I am facing two weird behaviors,

a - with an approval type application, when I try to open up the application in Cognos Insight, it sometimes loads, and some times it gives exceptions like could nto load widget, 0 index out of range
b - I switched the application to central type and this time I was able to open up the application in Cognos Insight. Now when I try to filter out some dimension member, say budget period, it would not filter out the data. Instead it causes a java language exception, which makes the current tab black/blank etc. Moreover, it also crashes the Tm1 server. This is alarming as I might be able to convince my user base to use a central application but if they ever try to filter out data they can potentially lose a lot of data if the tm1 server crashes.

I tried to look in tm1 logs, and in tm1 server.log i found following as the last lines in the log file, which is leading me to think that probably its crashing at the time of generating a custom/dynamic MDX for applying filter.

Code: 2164   [22]   DEBUG   2012-10-11 05:15:12.402   TM1.NGAPI.FACET   Model name: Assumptions Drivers840e7a06-423c-475d-a14b-88c3c84b6313
2164   [22]   DEBUG   2012-10-11 05:15:12.402   TM1.NGAPI.FACET   Model spec: {"facets":[{"dimension":"Budget_Period", "facets":[{"name":"Budget_Period", "type":"element"}]}, {"dimension":"Version", "facets":[{"name":"Version", "type":"element"}]}, {"dimension":"Scenario", "facets":[{"name":"Scenario", "type":"element"}]}, {"dimension":"Brand", "facets":[{"name":"Brand", "type":"element"}]}, {"dimension":"Market", "facets":[{"name":"Market", "type":"element"}]}, {"dimension":"Products", "facets":[{"name":"Products", "type":"element"}]}, {"dimension":"Subscriber_Assumption_Measures", "facets":[{"name":"Subscriber_Assumption_Measures", "type":"element"}]}], "sources":["Subscriber Assumption Drivers"]}
2164   [22]   WARN   2012-10-11 05:15:12.527   TM1.Cube   TM1CubeImpl::GetRTreeNodePool: Illegal call on versioned cube cube 0x0000000006AA8010 (Revenue  Monthly Assumption Drivers).
2164   [22]   WARN   2012-10-11 05:15:12.731   TM1.Cube   TM1CubeImpl::GetRTreeNodePool: Illegal call on versioned cube cube 0x0000000006AA6010 (Revenue  Budget).
2164   [22]   WARN   2012-10-11 05:15:12.762   TM1.Cube   TM1CubeImpl::GetRTreeNodePool: Illegal call on versioned cube cube 0x0000000006A01010 (Config Revenue  Calculation).
2164   [22]   WARN   2012-10-11 05:15:12.777   TM1.Cube   TM1CubeImpl::GetRTreeNodePool: Illegal call on versioned cube cube 0x0000000006AAA010 (RS Assumption Drivers).
2164   [22]   WARN   2012-10-11 05:15:18.653   TM1.Cube   TM1CubeImpl::GetRTreeNodePool: Illegal call on versioned cube cube 0x0000000006AA8010 (Revenue  Monthly Assumption Drivers).
2164   [22]   WARN   2012-10-11 05:15:18.653   TM1.Cube   TM1CubeImpl::GetRTreeNodePool: Illegal call on versioned cube cube 0x0000000006AA8010 (Revenue  Monthly Assumption Drivers).
2164   [22]   WARN   2012-10-11 05:15:18.653   TM1.Cube   TM1CubeImpl::GetRTreeNodePool: Illegal call on versioned cube cube 0x0000000006AA6010 (Revenue  Budget).

** I am guessing the TM1 server crashed after 2164?

Environment:
Cognos TM1 server version is 10.1.1, Cognos Insight 10.1.1
Environment: Windows 2008 Server, 64 Bit
Memory 16 GB
Processor Xeon 2 GHz

Any help would be appreciated. Btw, I am come from MS SQL/BI/Cognos Reporting background so please excuse me if i have ignore any basics here.

楼上MJJ

Guys - no one??

lindejink

IBM Support is going to be your best bet on this one.

sjgogo

Kaazimraza,

Have you find a resolution?
I have a client who wants use Insight for analysis purposes, but when we try to filter on biggish dimension it crashes the TM1 server?

chenwu521

We currently have similar issue open with Support and going on three months now. Recommend you follow tomok's advise and open SR as you might have better luck than I.

wddr

Mems wrote:Kaazimraza,

Have you find a resolution?
I have a client who wants use Insight for analysis purposes, but when we try to filter on biggish dimension it crashes the TM1 server?

Hi Mems -

I am guessing that it's something to do with unnamed subsets, but i am not sure about it. Since it was not a critical requirement for my client, i slept over it for now.

messiahxu

Hi Mems -

I am guessing that it's something to do with unnamed subsets

Kaazimraza,

I have a public default subset for every dimension in the cube. (except for the Control Object dimensions)

Any other suggestions, before I escalate it to IBM?

Regards,

wanglinyangling

Hey All,

The new hotfix fixes the problem.

It's called:
up_plananalytics_winx64h_10.1.7000.528_ml.tar.gz

Regards,

黄华民

Mems wrote:Hey All,

The new hotfix fixes the problem.

It's called:
up_plananalytics_winx64h_10.1.7000.528_ml.tar.gz

Regards,

thanks for letting us know. is this hot fix released after TM1 10.1.1?