Truesight Infrastructure Management Server (TSIM) is taking time to come up after restart

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Infrastructure Management


    COMPONENT:

    TSIM Analytics Engine


    APPLIES TO:

    All versions of TrueSight Infrastructure Management



    PROBLEM:

    TSIM server is taking time to come up.
    The <TSIM_install_directory>/pw/pronto/logs/TrueSight.log shows below error:

     

    WARN  02/27 08:15:22 jserver              [RateInit-1] 303869 Unable to insert 161 107450 into cache WARN  02/27 08:15:23 MsgHandler           [Thread-169] 101826 RateWriter::Unable to connect to Rate. Connection refused ERROR 02/27 08:15:31 jserver              [RateInit-1] 301231 Unable to get threshold info java.lang.NullPointerException     at com.proactivenet.api.alarm.Threshold.parentForInstThresh(Threshold.java:517)     at com.proactivenet.api.alarm.Threshold.<init>(Threshold.java:251)     at com.proactivenet.api.alarm.AbsoluteThreshold.<init>(AbsoluteThreshold.java:52)     at com.proactivenet.api.alarm.Threshold.getThreshold(Threshold.java:353)     at com.proactivenet.api.alarm.ThresholdCache.insertThreshold(ThresholdCache.java:169)

     


    CAUSE:

    Absolute instance thresholds with missing parent object.


    SOLUTION:

     

    To find out the instances, without parent object, please execute below query from <TSIM_HOME>/pw/pronto/bin:

    runjava scripts.runsqli "select count(*) from pers_obj_instances where moinstanceid in (select distinct(moinstanceid) from pers_obj_instances where moinstanceid not in (select moinstid from pers_obj_parents where motypeid=161) and motypeid=161) and motypeid=161"

    Output should be "0". If the result is not zero then please follow below steps to delete the orphaned entries from the database.

    For High Availability:

    1) Stop TSIM standby server by executing "pw sys stop"

    2) Stop TSIM active server by executing “pw sys stop”
    3) Take backup of Oracle DB instance
    4) Run below query from command prompt (path: <TSIM_HOME>/pw/pronto/bin). This will remove the corrupted entries.

    runjava scripts.runsqli "delete from pers_obj_instances where moinstanceid in (select distinct(moinstanceid) from pers_obj_instances where moinstanceid not in (select moinstid from pers_obj_parents where motypeid=161) and motypeid=161) and motypeid=161"

    5) Restart the active TSIM server by executing "pw sys start"
    6) Once the Integration Services and PATROL Agents are connected, start the standby TSIM server.


    For Standalone:

    A. Steps for Oracle Database:

    1) Stop TSIM server by executing "pw sys stop"
    2) Take backup of Oracle DB instance
    3) Run below query from command prompt (path: <TSIM_HOME>/pw/pronto/bin). This will remove the corrupted entries.

    runjava scripts.runsqli "delete from pers_obj_instances where moinstanceid in (select distinct(moinstanceid) from pers_obj_instances where moinstanceid not in (select moinstid from pers_obj_parents where motypeid=161) and motypeid=161) and motypeid=161"

    4) Restart the TSIM server by executing "pw sys start"

    B. Steps for Sybase Database:

       1) Stop TSIM server by executing "pw sys stop"
    2) Take Database backup by copying 'storm_<HOST_NAME>.db' and 'pronto.log' files from the "<TSIM_HOME>/pw/sybase" directory to backup location.
    3) Start the database process by executing "pw p s dbsrv"
    4) Verify that the database process is up and running by executing "pw p l"
    5) Run below query from command prompt (path: <TSIM_HOME>/pw/pronto/bin). This will remove the corrupted entries.

    runjava scripts.runsqli "delete from pers_obj_instances where moinstanceid in (select distinct(moinstanceid) from pers_obj_instances where moinstanceid not in (select moinstid from pers_obj_parents where motypeid=161) and motypeid=161) and motypeid=161"

    6) Restart TSIM server by executing "pw sys start"


      

     


    Article Number:

    000350031


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles