Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  List identify and kill long thread by API

    Posted Thu July 25, 2024 02:34 AM

    Hello,
    One of my customers uses CA (11.2.2) to report PA (2.0.9.16 ) cube data.

    When a report takes too long to run, CA shuts down the reporting (we've set a timeout of 3'), but the thread(s) continue to run on PA. and, eventually, TM1 consumes all the available ram.

    I ask to ibm support if a solution exists ..... No solution except perhaps use TM1 API .....

    So I started studying the TM1 API documentation, downloaded the fantastic tm1py and ran a few tests in python......
    I've managed to write a script that execute a ti process (I'm proud of myself).
     
    But since computing has evolved a lot (without me) since the Cobol years, I'm unable to understand the API documentation and the tm1py documentation. ;-(
     
    Would one of you be so kind as to help me out or make me an example script that ....
    - would capture the list of threads running
    - for each thread, look at its characteristics (duration, type, information) and decide whether to kill it or not.
    - then kill each selected thread
     
    Thank you (a lot !)  in advance.
     
    Kind regards,
    Philippe


    ------------------------------
    Philippe CHAMPLEBOUX
    ------------------------------


  • 2.  RE: List identify and kill long thread by API
    Best Answer

    Posted Thu July 25, 2024 04:30 AM

    There is an IBM Tech Note/ Support page which gives you a starting point:

    https://www.ibm.com/support/pages/how-use-rest-api-and-postman-return-threads-table-format

    What is interesting here is that CA also has a REST API and in theory when the report cancel is triggered in CA you could also call a request to PA to kill the appropriate thread.

    You would need to be sure you can identify the relevant thread and find a mechanism to trigger the action (tm1py, Go, Python, JavaScript etc..)

    If you are/ were using v12/ Planning Analytics Engine then you could use ExecuteHttpRequest direct within TI

    Note that the URL used in the Support page relates to PA on Cloud and if you have a local install then the URL will be different



    ------------------------------
    Edward Stuart
    ------------------------------

    Original Message


Related Content