TM1 Forum

I found the following "Flash Alert" at IBM site while I was looking for a solution to a weird problem on my server even since we installed 9.4.1. FP2.

Flash (Alert)

Abstract
A performance optimization put into TM1 9.4.1 FP2 creates the possibility of a server crash after deleting any cubes on the server.

Content
It is possible in the short term to set a configuration parameter in the tm1s.cfg that turns off the new behavior and would thus avoid this potential crash.

IBM Cognos support recommends anyone running 9.4.1 FP2 turn it off until a fix can be provided. It does require restarting the server after making the change.

Parameter to put in the tm1s.cfg:

InvalidateRuleDependenciesOnDataChange=T

or

InvalidateRuleDependenciesOnDataChange=True

Then restart the server.

The problem is this: in a cube view, if we try to stack more than 2 dimensions as row dimensions, and the data to be viewed is to be calculated, then the action will crash the server. TM1 is running as a service.

I tested on my local which has not been applied with any Fix Pack, and this works fine. I did not apply FP2 on my local due to the issue with TM1 client on FP2 with server on FP2. This feature, being a bread-and-buttter function of TM1, should not have failed so spectacularly.

Anyway, I was quite happy to have found this IBM post and immediately tested it out. Result: FAIL.

I'm rolling back to Fix Pack 1 on my server now and hope this problem does not exist. But I hope that FP1 allows TM1 Web to display validation lists in Websheets, or else I have to redesign a whole bunch of worksheets! Wish me luck...

Forgot to add, the error message after triggering the problematic cube view is:

(SystemServerConnectionInvalid) : Server connection error

It does not matter whether you are using TM1 Client with or without FP2. As long as the server is on FP2, this is it.

We have had this issue in 9.1.3 as well.

Is anybody out there using 9.1.4 FP2 on Solaris 64-bit?