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:
    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,

  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 
                  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

    • Global Functions

      Global functions are custom functions that can be called from custom functions configured for request They can store information that is essential to connect with external applications, common functionalities, and configurations, all of which can be ...
    • 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 ...
    • Request Custom Functions

      Request custom functions can be used in business rules, request custom triggers, request life cycle, and request timer actions. Using custom functions, you can perform automated actions on requests, other modules, and external applications. Go to the ...
    • Database Migration Tool

      You can use this tool to migrate data between two databases (Postgres to MSSQL and vice versa) as well as between operating systems (Linux to Windows and vice versa). You can perform the following data migration with this tool: Server migration ...
    • Custom Modules

      SupportCenter Plus has built-in modules such as Requests, Solutions, and configuration entities such as Users, Status, Priority, Level, and Mode. Organizations might want to create additional entities to suit their business processes and workflows. ...