If you are unable to create a new account, please email support@bspsoftware.com

 

Tm1Serv service Crashing - ps im in the right spot, just bear with me

Started by TomCognos, 29 Jul 2018 06:42:55 PM

Previous topic - Next topic

TomCognos

So we have Cognos 11.0.11 Reporting off TM1 10.2.2

We have implemented Element Level security within our TM1 department Cost Centre dimension. When we create a crosstab report that has 3 or more dims nested in the rows (plus measures) the TM1Serv service crashes (1 of 3 tm1 services, the Cognos service is not effected). Nothing in the TM1 logs, Cognos logs that indicate the issue.

After a bucket load of testing on our test server we have narrowed it down to the Filler (http://www-01.ibm.com/support/docview.wss?uid=swg21660287) {setting hierarchyUseFillerMember=True}
that you set within c11_install/configuration/xqe.config.custom.xml and then restart the Cognos service.
When this is set the service crashes on any of our three servers. When this is not set, i have successfully nested 9 levels on the rows without a crash.

I have also found an old IBM link that merely states a very similar if not the same, issue but no resolution. (http://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1PI76570). Currently following this up with IBM as well.

So my question is. Has anyone with a Cognos 11 setup running of a 10.2.2 TM1 back end with Element Level security (and the filler set) come across this issue of a crashing TM1Serv service and how did you fix it ?