|Summary||This tutorial describes how to completely clean a production server after data collection|
|Written for||Fieldwork manager|
|Keywords||cca; backup ; slow ; production ; server ; cleanup ; sql ; harddrive ; HDD|
After a given amount of time, all application servers aggregate clutter files, left overs and other useless data from past years of production.
This can slow down the host environment, and even impact production.
Here is a complete guide to get rid of this unused data.
Step 1 : Improve server speed by freeing up RAM
- Identify all surveys that are currently not in production, as well as their associated sample lists and agent groups.
- Connect to CCA via the Supervisor client
- (optional) Create backups of the survey tasks using the task package feature
- Select all surveys that have been identified and hit your del. key or right-click -> delete
During this action, you might receive the following prompt :
Clicking "Yes" will also remove the survey from its Web-position, and thus free up one spot to upload a new survey for CAWI.
- Repeat for the identified sample lists and agent groups
Step 2 : Free up SQL space with CcaCleanUp.exe
After Step 1, your data has been removed from the CCA interface only. It still exists, as a safety, on the SQL server.
Here is the procedure to remove unused data from all Askia-related databases on your SQL server, with this utility called CcaCleanUp.
- The CCA must be stopped during the operation of this tool.
- The new version needs to have VisualC++ redistributable 2010 (vcredist 2010) installed. Depending on the server architecture, you might need a different version of this dependency. They are available on the cca server, in the \askiafield\Packages\VcRedist\ folder. Use only the vcredist_x86 packs.
The application that allows you to clean the Statistics, Surveys and Webinterviews databases is called CcaCleanUp.exe and is located in the installation folder of Cca : "C:\Program Files (x86)\AskiaField\CCA\". If you don't find it, please download it from here.
It should be started directly from the CCA server.
Below is the procedure for cleaning statistics graduate.
- Fill up the 2 fields in "Source" with connection ADO connection strings.
- For a first run, let the default value for SQL Queries Timeout at 300 seconds. It could be necessary, especially during the Statistics clean up by date, to increase this value.
- Choose the type of data that should be removed.
- Date cleanup: Deletes all records in the Statistics database prior to the date indicated and for all surveys (deleted or not).
- Survey cleanup: Deletes all records in the Statistics database for the selected surveys.
- List DB cleanup: Removes all AskList / AskEmail / AskCall tables from the Lists Database. This only deletes data related to lists that have been previously deleted from the CCA / supervisor interface.
- Survey DB cleanup: Removes all tables ASKReponseXXX from the Surveys database referring to studies that have been deleted from the interface of the CCA / supervisor.
- WebInterviews DB cleanup: Removes data from the WebInterviews database for surveys that have been previously deleted from Cca and removed from Webprod.
- You can get the connection strings directly from the Cca/supervisor menu > options > cca settings in Lists/Statistics/Surveys part of the cca settings.
- For the webprod, the connection string for WebInterview is located in webprod administration pages > configuration > Webprod Configuration > Connection string for interview db. The one for webprod database is store in the global.asa file (which can be opened with notepad) in "strWebProdDatabase ".
Step 3 : Free up hard drive space on the servers (work in progress)
There is no officially released script to perform a file cleanup yet. On the other hand, here is the default location of files that can be left over after production.
- Step 1 must be completed beforehand
- Only remove working directories that have been previously deleted (and optionally backed up) from CCA
- The working directory stores unused .qes files
In the CCA settings, you can find the current path of this directory.
In these directories, spot the working directories of the unused surveys, and remove or back them up to an external hard drive location.
- The Logging folder stores old logs that can be zipped / removed
Its path can be found in the logging settings of CCA