IBM Cognos Xcelerator Server Freezes/Not responding

[ryan]

When I am trying to save rules of a particular cube, the server is either not responding or freezing the screen for hours.

My Xcelerator Server Specs:
Microsoft Window Server 2003 Exterprise x64 Edition Service Pack 2
RAM 15.9GB
IBM Cognos Express Xcelerator (Version 9.0)
MS-Office Excel 2007 (12.0.6514.5000)SP2 MSO (12.0.6425.1000)
Microsoft .NET Framework 3.5

Boot.ini file on Server system is as follows:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003 Enterprise x64 Edition" /noexecute=optout /fastdetect

I appreciate if anyone could help me in overcoming this problem.

Thanks in advance.

[jrizk]

Hi. Have you checked for circular rules for that cube? I'

I've experienced this freezing with a circular rule/calculation. Check your tm1server.log file as a start - if you see errors showing 'Stack Overflow' then a circular rule could be the problem.

Apart from that the tm1server.log will give you an indication of what's happening. You could also try running Tm1Top.

[tomok]

When you save rules, three things happen; 1) the rules syntax is checked, 2) rule validity is checked, and 3) feeders are processed. When a rule save takes a long time, it is almost always due to item number 3. My guess is you have a problem with your feeders but we can't help you without more background information about your cube structure and the rule file code.

[Martin Ryan]

Almost certainly it'll be as tomok described, here is a suggested methodology for finding your problem.
- Shrink the cube size (e.g. delete all data except the current month) so that it takes minutes rather than hours to save
- Remove all your feeders
- Add them back one by one timing how long each additional feeder adds to the save time
- Fix the one that adds all the time
- Add back all the data you deleted in step one.

Martin

[ryan]

Almost certainly it'll be as tomok described, here is a suggested methodology for finding your problem.
- Shrink the cube size (e.g. delete all data except the current month) so that it takes minutes rather than hours to save
- Remove all your feeders
- Add them back one by one timing how long each additional feeder adds to the save time
- Fix the one that adds all the time
- Add back all the data you deleted in step one.

Martin

Thank you J.Rizk/Martin/tomok.

Now it is working fine. Once again thank you one and all.