Tech Tip: HOTFIX for ‘CCC spreadsheet download is very slow’ (DE161353)

Document created by biecl01 Employee on May 12, 2016
Version 1Show Document
  • View in full screen mode

Problem: Downloading a large ServerConfiguration.xlsx file (containing >3K physical hosts from an environment with >1K preferred groups, for example) can take over 10 minutes to complete.

 

Solution: The attached patch corrects this behavior. Follow the steps outlined below to deploy the patch on your system.

 

Before deploying the patch:

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

  • IPrecalcDataMapper.class
  • ServerGroupRepository.class
  • ServerGroupRepository$1.class
  • HyFyDatabaseFiller.properties
  • sqlStatement.sql

 

Deploy the SQL file (Windows/Linux):

Open the Data Manager Database (Oracle) console and run the sqlStatement.sql script.

 

Deploy the ServerConfiguration_Patch files on Windows:

1. Make a backup copy of the following files by copying them to your desktop folder:

  • <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes\com\hyperformix\hyfy\server\fillers\impl\HyFyDatabaseFiller.properties
  • <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes\com\hyperformix\pb\server\mapper\IPrecalcDataMapper.class
  • <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes\com\hyperformix\pb\groups\impl\ServerGroupRepository.class
  • <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes\com\hyperformix\pb\groups\impl\ServerGroupRepository$1.class
  • <ccc_install_folder>\ApacheTomcat\webapps\ccc\WEB-INF\classes\com\hyperformix\pb\server\mapper\IPrecalcDataMapper.xml

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

3. Add the following element in IPrecalcDataMapper.xml:

       <update id="refreshEntityGroupConfigMView">

              CALL DBMS_MVIEW.refresh('entity_config_mview')

       </update>

4. Save the xml file.

5. Restart the CCC service:

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

  

Deploy the ServerConfiguration_Patch files on Linux:

1. Make a backup copy of the following files by copying them to your desktop folder:

  • <ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes/com/hyperformix/hyfy/server/fillers/impl/HyFyDatabaseFiller.properties
  • <ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes/com/hyperformix/pb/server/mapper/IPrecalcDataMapper.class
  • <ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes/com/hyperformix/pb/groups/impl/ServerGroupRepository.class
  • <ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes/com/hyperformix/pb/groups/impl/ServerGroupRepository$1.class
  • <ccc_install_folder>/ApacheTomcat/webapps/ccc/WEB-INF/classes/com/hyperformix/pb/server/mapper/IPrecalcDataMapper.xml

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

3. Add the following element in IPrecalcDataMapper.xml:

       <update id="refreshEntityGroupConfigMView">

              CALL DBMS_MVIEW.refresh('entity_config_mview')

       </update>

4. Save the xml file.

5. Restart the CCC service:

  • In a terminal, navigate to the bin directory of Apache Tomcat Server: <ccc_install_folder>/ApacheTomcat/bin
  • Do:
    • ./stop.sh
    • ./start.sh

Outcomes