Creating a Test Environment

Creating a Test Environment

You can use a test environment to try newer versions or beta service packs before applying the patches or service packs to the application on the production server. We strongly recommend using test environments for any hotfixes, major releases, or beta service packs.

Creating a test environment involves the following.
 
  1. Obtaining backup from the Production Server
  2. Setting up the Test Server 

Obtaining backup from the Production Server 

  1. Stop SupportCenter Plus service on the production server.

  2. Using the command prompt, go to <SupportCenter_Plus_Home>\ bin directory and execute trimmedBackUpData.bat  to start the Trimmed data backup. Trimmed data backup does not include attachments and custom images. It is sufficient to create a test environment. To know more about backup, click here.

  1.  Once the backup is complete, a backup folder with the format below is placed under trimmedbackup folder in SupportCenter Plus Home directory. 
       backup_ supportcenter_ [build number] _database_month _date _ year _ hour _minutes.
    The  .data backup files are placed under the respective directories. For example, a trimmed backup taken in Version 11.0 of SupportCenter Plus looks like this:
           backup_supportcenter_11000_database_12_08_2020_15_22.data
    The backup folder/file contains information such as the Build number of SupportCenter Plus, and date and time when the backup was performed.

Setting up the Test Server 

Data should be restored ONLY across the same builds of SupportCenter Plus. (i.e.) data backed up in 11000 builds can be restored only in 11000 builds.

Build version can be checked, by either of the below ways:
  1. Help>>About in the application.
  2. From buildInfo.xml file under <SupportCenter_Plus_Home>\Conf directory.
Make sure the following steps should be carried out with administrator privileges 
  1. Download SupportCenter Plus with the same build number as in the Production Server from this link. For older builds, click here.

  2. Now start and shut down the Test set up application once.

  3. Copy the backup taken from the production server to the Test server.

  4. To restore the backed up data, Go to <SupportCenter_Plus_Home>\bin directory and execute restoreData.bat.

  5. Choose the backup file while prompted as in the screenshot given below,
    <SupportCenter_Plus_Home>\bin>restoreData.bat

  6. Provide the backup file password when prompted. The default password is SCP123!

  7. Once the data is restored successfully, stop the application from fetching emails.            


    1.  Using command prompt go to <SupportCenter_Plus_Home>\ bin in the command prompt and execute the startDB.bat 65432

    2.  Connect to the database:
                  Postgres: Navigate to <SupportCenter_Plus_Home>\ pgsql \ bin and execute the following.   
                               psql -h localhost -U scpadmin -p 65432 -d supportcenter                       
                              Enter password when prompted: The default password is 
      scp@123 
                  MS SQL: Connect using SQL studio.

    3. Execute the below queries one by one :
                 update outgoingmailserver set HOSTNAME =’ALPHA’;
                 update outgoingmailserver set ALTERNATEHOSTNAME=’BETA’;
                 update incomingmailserver set HOSTNAME =’XYZ’;
                 update TASK_INPUT set OPERATIONAL_STATUS=’4′;
        

  8. Start SupportCenter Plus in the test server. 

You can log in into the application UI with the user credentials 

    • Related Articles

    • Business Rules for Notes

      Business rules are used to automate certain actions for notes that fulfill certain incoming criteria. Some of the actions that can be automated using business rules for notes include making the notes public for all users or making the notes available ...
    • Business Rules for Notifications

      Business rules are used to automate certain actions for notifications that fulfill certain incoming criteria. Some of the actions that can be automated using business rules for notifications include pausing specific notifications or turning them off ...
    • Business Rules for Request

      Business rules are used to automate certain actions for requests that fulfill certain incoming criteria. Some of the actions that can be automated using business rules include assigning groups, support reps, status, and priority. You can now create ...
    • Custom Scheduled Function

      SupportCenter Plus allows administrators to execute custom schedules using a built-in script execution tool called Custom Scheduled Function. The custom scheduled function scripts can be built from scratch using Deluge, Zoho's propriety scripting ...
    • Custom Module API

      Custom Module API allows customers to add, edit, and delete records through REST API from scripts or external clients. The list of supported operations with the expected URL and input_data is given below. For more details about the custom module ...