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 precalc.day.back key, which can be set in the defaults.properties file.

 

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

 

Before deploying the patch:

Unpack the attached RegressionValue_Patch.zip file. The zip file contains:

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

 

Deploy the class and xml files:

Windows:

  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

Linux:

  • <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 defaults.properties 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
precalc.day.back=2

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

 

Restart the CCC service:

Windows:

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

Linux:

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

./stop.sh

./start.sh

Attachments

Outcomes