企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 369|回复: 8

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

[复制链接]

71

主题

397

帖子

556

积分

中级会员

Rank: 3Rank: 3

积分
556
QQ
发表于 2014-3-20 19:26:38 | 显示全部楼层 |阅读模式
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.

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复

使用道具 举报

67

主题

399

帖子

545

积分

中级会员

Rank: 3Rank: 3

积分
545
QQ
发表于 2014-3-20 20:58:11 | 显示全部楼层
Guys - no one??
回复 支持 反对

使用道具 举报

73

主题

375

帖子

517

积分

中级会员

Rank: 3Rank: 3

积分
517
QQ
发表于 2014-3-20 21:28:03 | 显示全部楼层
IBM Support is going to be your best bet on this one.
回复 支持 反对

使用道具 举报

77

主题

412

帖子

581

积分

中级会员

Rank: 3Rank: 3

积分
581
QQ
发表于 2014-3-20 21:43:12 | 显示全部楼层
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?
回复 支持 反对

使用道具 举报

87

主题

397

帖子

590

积分

中级会员

Rank: 3Rank: 3

积分
590
QQ
发表于 2014-3-20 22:17:06 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

66

主题

378

帖子

536

积分

中级会员

Rank: 3Rank: 3

积分
536
QQ
发表于 2014-3-20 22:17:40 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

79

主题

383

帖子

556

积分

中级会员

Rank: 3Rank: 3

积分
556
QQ
发表于 2014-3-20 22:57:59 | 显示全部楼层
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,
回复 支持 反对

使用道具 举报

83

主题

418

帖子

540

积分

中级会员

Rank: 3Rank: 3

积分
540
QQ
发表于 2014-3-20 23:31:37 | 显示全部楼层
Hey All,

The new hotfix fixes the problem.

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

Regards,
回复 支持 反对

使用道具 举报

93

主题

423

帖子

624

积分

中级会员

Rank: 3Rank: 3

积分
624
QQ
发表于 2014-3-21 00:07:39 | 显示全部楼层
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?
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2018-5-25 16:51 , Processed in 0.135368 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表