Tech Tip: HOTFIX for ‘Regression Value Issue in BH_ROLLUP_HISTORY table’ (00369439/DE166263)

Document created by biecl01 Employee on Aug 16, 2016Last modified by biecl01 Employee on Aug 18, 2016
Version 2Show Document
  • View in full screen mode

Problem: In CCC 2.9.2 and 2.9.3, the regression design allows to calculate regression values on rollup values from one day before (=yesterday) only. It is not possible to include data sources that are pulling in data that are older than one day.


Solution: The attached patch allows to calculate regression values for more than one day in the past, according to the value of the key, which can be set in the file.


To deploy the patch on your system, follow these steps:


Before deploying the patch:

Unpack the attached file. The zip file contains:

  • RollupMetricsWithBusinessHoursStep.class
  • BusinessHoursDao.class
  • IBusinessHoursMapper.class
  • IBusinessHoursMapper.xml


Deploy the class and xml files:


  1. Make a backup copy of the following files:
  • <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes\com\hyperformix\hyfy\server\rollups\commands\triggeredUpdate\RollupMetricsWithBusinessHoursStep.class
  • <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes\com\hyperformix\pb\server\dao\BusinessHoursDao.class
  • <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes\com\hyperformix\pb\server\mapper\IBusinessHoursMapper.class
  • <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes\com\hyperformix\pb\server\mapper\IBusinessHoursMapper.xml


  • <ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes/com/hyperformix/hyfy/server/rollups/commands/triggeredUpdate/RollupMetricsWithBusinessHoursStep.class
  • <ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes/com/hyperformix/pb/server/dao/BusinessHoursDao.class
  • <ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes/com/hyperformix/pb/server/mapper/IBusinessHoursMapper.class
  • <ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes/com/hyperformix/pb/server/mapper/IBusinessHoursMapper.xml


    2. Replace the class and xml files with the ones you extracted from the attached zip file.


Set up a custom number of metrics days for daily regression:


  1. Navigate to <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes (<ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes) and open the file in a text editor.
  2. Append the following property at the end of the file, and set the value according to your preference:

# Number of past days to re-run rollup

    In this example, regression values will be calculated up to 2 days before today (=yesterday and the day before yesterday).


Restart the CCC service:


  1. Click Start, Control Panel, Administrative Tools. Click Services.
  2. Select the Apache Tomcat 7.0 CA_CCC service and restart it.


  1. In a terminal, navigate to the bin directory of Apache Tomcat Server: <ccc_install_folder>/ApacheTomcat/bin
  2. Do: