TM1 Forum

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.

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.

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.

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

Martin Ryan wrote: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.