Never ending GET cellset thread

Post Reply
kangkc
Community Contributor
Posts: 206
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1, PA , TMVGate
Version: 2.x
Excel Version: 36x
Location: Singapore
Contact:

Never ending GET cellset thread

Post by kangkc »

This is probably the 10 times I am getting this issue in which TM1Top show a user innocent Get Cellset thread seems to be running forever and as a result caused lock wait in a few TI processes and evetually a full server locked up.
Never arrived with any conslusion with IBM as it will require switcing on debug mode etc etc hence I am looking at ways to avoid this.

Am thinking of writting a Rest API utility to detect long running user threads and kill it before the sever goes into full lockup situation.

Any other suggestion ?
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Never ending GET cellset thread

Post by John Hammond »

PA now gives you tm1event.log which lists long running threads and locking contentions. The only problem is that it lists only the thread number which doesnt let you trace any further when the thread has gone.
Post Reply