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: