Filtering in Cognos Insight (Connected) crashes server
Posted: Thu Oct 11, 2012 6:58 am
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.
** 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.
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: Select all
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).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.