TrueSight Capacity Optimization(TSCO) reporting, "Exception occurred while pushing request in the local DB; trying to push it in shared DB"

Version 6
    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


    APPLIES TO:

    TSCO 10.3



    PROBLEM:

     

    The following error message is being reported in the TrueSight Capacity Optimization 10.3 Diagnostic Alerts and in the $CPITBASE/datahub/wh.log:
     

      
    2015-08-14 11:23:43,471 WARN - [store-sys-64899] Exception occurred while pushing request in the local DB; trying to push it in shared DB StackTrace: com.neptuny.cpit.querymanager.QueryException: DYNAMIC The database has been closed [90098-187] sql-code : select freshness from red_sys_freshness where id=? params : [[64899]] at com.neptuny.cpit.querymanager.QueryManager.executeDynamicQuery(QueryManager.java:197) at com.neptuny.cpit.querymanager.QueryManager.executeDynamicQuery(QueryManager.java:128) at com.neptuny.cpit.warehouse.LocalDBRequestsHandler.executeQuery(LocalDBRequestsHandler.java:1495) at com.neptuny.cpit.warehouse.LocalDBRequestsHandler.getFreshness(LocalDBRequestsHandler.java:1038) at com.neptuny.cpit.warehouse.LocalDBRequestsHandler.evaluateScore(LocalDBRequestsHandler.java:595) at com.neptuny.cpit.warehouse.LocalDBRequestsHandler.push(LocalDBRequestsHandler.java:575) at com.neptuny.cpit.warehouse.LocalDBRequestsHandler.pushReduceStatusImpl(LocalDBRequestsHandler.java:1836) at com.neptuny.cpit.warehouse.LocalDBRequestsHandler.pushReduceStatus(LocalDBRequestsHandler.java:1828) at com.neptuny.cpit.warehouse.LocalDBRequestsHandler.pushReduceStatus(LocalDBRequestsHandler.java:1820) at com.neptuny.cpit.warehouse.AbstractThread.pushReduceStatus(AbstractThread.java:1100) at com.neptuny.cpit.warehouse.StoreThread.doStore(StoreThread.java:568) at com.neptuny.cpit.warehouse.StoreThread.doExecution(StoreThread.java:80) at com.neptuny.cpit.warehouse.AbstractThread.runImpl(AbstractThread.java:212) at com.neptuny.cpit.warehouse.AbstractThread.run(AbstractThread.java:159) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcSQLException: The database has been closed [90098-187] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.message.DbException.get(DbException.java:144) at org.h2.engine.Session.getTransaction(Session.java:1451) at org.h2.engine.Session.getStatementSavepoint(Session.java:1461) at org.h2.engine.Session.setSavepoint(Session.java:690) at org.h2.command.Command.executeUpdate(Command.java:248) at org.h2.jdbc.JdbcConnection.setQueryTimeout(JdbcConnection.java:737) at org.h2.jdbc.JdbcStatement.setQueryTimeout(JdbcStatement.java:597) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.setQueryTimeout(DelegatingStatement.java:249) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.setQueryTimeout(DelegatingStatement.java:249) at com.neptuny.cpit.querymanager.MyPreparedStatement.execute(MyPreparedStatement.java:98) at com.neptuny.cpit.querymanager.MyPreparedStatement.doExecuteDynamicQuery(MyPreparedStatement.java:43) at com.neptuny.cpit.querymanager.MyAbstractStatement.executeDynamicQuery(MyAbstractStatement.java:855) at com.neptuny.cpit.querymanager.QueryManager.executeDynamicQuery(QueryManager.java:172) ... 16 more
       

    Additional errors include:

    From the $CPITBASE/datahub/wh_cpit.log:
     

      
    2015-08-14 11:18:53,557 ERROR - [red-sys-cacheFiller] BCO_DH_ERR011: Error during rollback operation. StackTrace: org.h2.jdbc.JdbcSQLException: The database has been closed [90098-187]         at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)         at org.h2.message.DbException.get(DbException.java:179)         at org.h2.message.DbException.get(DbException.java:155)         at org.h2.message.DbException.get(DbException.java:144)         at org.h2.engine.Session.getTransaction(Session.java:1451)         at org.h2.engine.Session.getStatementSavepoint(Session.java:1461)         at org.h2.engine.Session.setSavepoint(Session.java:690)         at org.h2.command.Command.executeUpdate(Command.java:248)         at org.h2.jdbc.JdbcConnection.rollbackInternal(JdbcConnection.java:1501)         at org.h2.jdbc.JdbcConnection.rollback(JdbcConnection.java:489)         at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368)         at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)         at com.neptuny.cpit.querymanager.QueryManager.rollback(QueryManager.java:692)         at com.neptuny.cpit.warehouse.LocalDBRequestsHandler.fillBlockingQueue(LocalDBRequestsHandler.java:443)         at com.neptuny.cpit.warehouse.LocalDBRequestsHandler.access$300(LocalDBRequestsHandler.java:46)         at com.neptuny.cpit.warehouse.LocalDBRequestsHandler$BlockingQueueFiller.run(LocalDBRequestsHandler.java:311)         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)         at java.util.concurrent.FutureTask.run(FutureTask.java:266)         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)         at java.lang.Thread.run(Thread.java:745)
       





     

     


    CAUSE:

    Defect QM001885868 "Restore version h2-1.3.176* includes dependency Management refactoring of other libraries (sqllite, ojdbc, postgres)"


    SOLUTION:

     

    These errors may be related to above Defect,which has been addressed in the CO 10.3.00 CHF #3 and later patch package.  

    If the environment is running CO 10.3 CHF #2 or earlier it is recommended to apply the latest CHF to update the H2 database library file version in the CO environment.

      

    000097159: Cumulative Hot Fixes for TrueSight Capacity Optimization (CO), CO Gateway Server, and CO Agent, and CO Perceiver (https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000097159)

      

    If the environment is already running CO 10.3 CHF #3 or later:

      

    This error message indicates that there is a problem with the local working set database that is used by the Datahub.  To stop this error the local database files can be removed and they will be rebuild on restart of the Datahub from information that is available in the CO database.

      

    Workaround steps:

    (1) Stop the BCO Datahub
    ./cpit stop datahub

    (2) Delete the $CPITBASE/nrtwh/rs-1.2-store.h2.db and rs-1.2-store.lock.db files.

    NOTE: Only the store-sys NRTWH local database file can be deleted without the potential for data processing loss requiring manual recovery steps.  Deleting the red-sys or wh-sys local database files will result in data reduction for any data currently pending in those queues not being executed which may require manual steps to recover DAY and MONTH data aggregations.

      

    (4) Restart the BCO Datahub
    ./cpit start Datahub

    Additional Information

    The message indicates that there is a problem with the $CPITBASE/nrtwh/*.db files.

    To debug further contact CO Technical Support and provide the following:
    * The logGrabber output from the BCO Datahub AS

      

    KA000099787: Gathering data using Log Grabber (https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000099787)

      

     

     


    Article Number:

    000319046


    Article Type:

    Solutions to a Product Problem



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