TrueSight Capacity Optimization (TSCO): The Near-real-time Warehouse Max Queue age is greater than 3 days

Version 5
    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 Capacity Optimization


    COMPONENT:

    Capacity Optimization 11.5.01


    APPLIES TO:

    All versions



    PROBLEM:

     

    The TSCO Console is reporting the following message
    2014-03-12 17:20:07,272 ERROR [taskid=19]- Near-real-time Warehouse service is in ERROR state. Max Queue age is greater than 3 days
    2014-03-12 17:20:07,302 INFO  [taskid=19]- Component status of Core Services - Near-real-time Warehouse service (id: -50)  installed on host "bcoas.domain.com" has been updated to ERROR


     

     


    SOLUTION:

    Legacy ID:KA410848

    Under Administration -> Data warehouse - Status check to see which queue(s) have a high queue length and long Max Queue Age (greater than 24 hours).  Make sure that the Processing Throughput value for that queue is non-zero.

       
    • If the Processing Throughput is 0, do the following:
      
       
    1. Restart the BCO Datahub ./cpit restart datahub
    2.  
    3. Wait 15 minutes
    4.  
    5. Check if the throughput now is greter than 0
    6.  
    7. If not, follow the steps reported below to contact support
      
       
    • If the Processing Throughput is non-zero for the backed up queue
      
       
    1. Run the Database Space Manager task in Analyze Schema mode (KA000198982: https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000198982)
    2.  
    3. Wait the end of the task
    4.  
    5. Wait 8-12 hours
    6.  
    7. Check if the flow is now normal
    If after these tentatives, the problem will be not solve, get in contact with product support, providing these information:  
       
    1. The log grabber output from the Application Server environment (https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000099787). If the environment has more that one AS, collect the logs for the one with Data Hub
    2.  
    3. An fresh exeution of Diagnostic Report - Data Flow & Statistics (https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000025194)
    4.  
    5. If the TSCO data base is Oracle, an AWR report of last 24 hours

     


    Article Number:

    000311670


    Article Type:

    Solutions to a Product Problem



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