IT Process Automation

 View Only
  • 1.  Kill ITPAM process from database

    Posted Oct 13, 2015 02:51 AM

    Hi,

     

    Due to a badly designed recursive workflows there are more than 100000 processes running in my ITPAM environment. ITPAM has stopped displaying Operations console. Can somebody please suggest how can I kill or stop running processes from runtime database in ITPAM using some SQL Query.



  • 2.  Re: Kill ITPAM process from database
    Best Answer

    Broadcom Employee
    Posted Oct 13, 2015 08:55 AM

    Do you need anything that is or was running?   Clearing the runtime database tables would be the simplest quickest, and depending on the scope of the problem, possibly only, method to get rid of those processes.

     

    There isn't going to be a blanket 'clear all process 'ZYX' instance runs - the instances exist independently of each other.

     

    The GUI not loading is likely a resource issue.    If you increase memory for PAM it may allow it to load enough that you can begin to abort the processes through the GUI:

     

    In PAM/Server/c2o/bin/

    c2osvcw.conf:

    wrapper.java.initmemory=4096

    wrapper.java.maxmemory=4096

     

    If PAM is already set and using 4g:

     

    in c2osvcw.conf:

    commented out

    #wrapper.java.initmemory=4096
    #wrapper.java.maxmemory=4096

     

    then add at the bottom of the file:

     

    wrapper.java.additional.14-XX:initmemory=8192
    wrapper.java.additional.15-XX:maxmemory=8192

    (Where 14 and 15 are the next available values)

     

    A couple other settings need to be tuned to better handle this increase in memory.  Modify as follows:

    wrapper.java.additional.7=-XX:PermSize=256m
    wrapper.java.additional.8=-XX:MaxPermSize=768m

     

    Good Luck, and feel free to contact the support team for assistance.

     

    Please note - your system must have at least 8 GB of FREE contiguous memory meaning 12 or 16gb TOTAL dedicated memory installed on the server.