Update from >V2.0 to V2.3.1 of the RMS Software

<< Click to Display Table of Contents >>

Navigation:  Software Overview > RMS Monitoring Software > Server Software Installation > RMS Software V2.3.1 >

Update from >V2.0 to V2.3.1 of the RMS Software

 

Important:

As soon as the Rotronic Monitoring System >V2.0.0 has been uploaded, please update all RMS-GW devices with the latest firmware version: Update Firmware.

 

Please reach out to Rotronic for more details: rms@rotronic.ch.

 

Installing Multiple Instances.

 

Follow these guidelines for the upgrade of a software version >2.0 to the V2.3.1. These guidelines work for a single server (application and database) as well as for two servers (one for the application and another one for the database).

 

Prerequisites:

A previous version of RMS is already installed (>V2.0).

The current version is hosted in IIS on the site “Default Web Site” and named “RMS” and “wService”.

The new RMS Files are unzipped in the folder “C:\inetpub\wwwroot\RMS\22325”.

The “connection.config” file contains the correct information for the database connection.

 

IMPORTANT: as soon as the prerequisites above are not met, additional adaptations are necessary!!!

 

Step 1

Unzip the new version and copy it into a folder with the version number parallel to the currently installed version: "C://inetpub/wwwroot/rms/{version}".

1_2.3.0

Step 2

Login to the SQL Server as ADMIN or SA user:

2_2.3.0

Step 3

Create a backup of the RMS database, right click on the rms database>Tasks>Back Up...

3_2.3.0

 

Select a full backup to the disk and click on OK:

4_2.3.0

 

Ensure that the tick box is selected to verify the backup when finished, click on OK:

5_2.3.0

 

Select the backup destination:

6_2.3.0

 

7_2.3.0

 

The database should then be backed up, click on OK.

8_2.3.0

Step 4

Update the database tables using the "Rotronic-Rms-Tables". Via the SQL Server Management Studio, click on "open file" and double click on the folder to update.

9_2.3.0

 

The following data will be shown and click on execute. Please check before execute in which database you will run this script. The rms database should be shown in the left top field!

10_2.3.0

 

Once executed, the following screen should be visible:

11_2.3.0

Step 5

Update the RMS SQL indices,  via the SQL Server Management Studio, click on "open file" and select the required SQL indices.

 

Please check before execution in which database you will run this script. The rms database should be shown in the left top field!

 

Check what version of MS SQL is running on the server.

 

Based upon the MS SQL version, double click on the either RMS_SQL_Indices or RMS_SQL_Indices (SQL 2014 or older) to upgrade and execute it.

12_2.3.0

 

 

The following overview will appear:

13_2.3.0

 

Once executed, the following screen should be visible (take this print screen for validation purposes):

14_2.3.0

Step 6

In the 22325 folder, install the .Net Framework V4.7.2 or newer, double click on the file NDP472-KB4054531-WEB.exe:

15_2.3.0

 

When prompted click on continue to install the .NET framework or close if it is already installed.

 

.NET framework already installed, close the window and please move to the next step.

16_2.3.0

 

Installation of the .NET framework, click on Install.

14_1.3.1

 

The installation will start:

15_1.3.1

 

Once completed, the following screen will appear:

16_1.3.1

 

A server restart is required:

17_1.3.1

Step 7

In the 22325 folder, update the connections.config file of the new software installation based upon the settings of the current software installation.

 

Edit, if required, the connection string (via Notepad) if the in connections.config in folder C:\inetpub\wwwroot\RMS\22325\ServiceManager:

Data Source,

Initial Catalog,

User ID,

Password.

 

The existing connections.config data can be found in C:\inetpub\wwwroot\RMS\xxxxx\wPage.

18_2.3.0

 

Here is the overview of the old and new files:

17_2.3.0

 

 

Step 8

Test the connection to the database, by double clicking on the TestDatabase.cmd command:

19_2.3.0

 

If the following screen appears, return to step 5 and execute the "Rotronic-RMS-Tables":

clip0116

 

The following screen should be shown if the test is successful:

20_2.3.0

Step 9

Important Note

If you update from <V1.3.3 , use the Update1xTo231.cmd

If you update from >V2.0.0 or higher, use the Update2xTo231.cmd

 

clip0115

Step

10

Open the Update2ToV231.cmd file with notepad and check to ensure that the wPageName, wServiceName and ManagerInstance are all correct.

 

IMPORTANT: the wPage, wServiceName can be found in the IIS:

wservice and wpage

 

The correct details are listed below in yellow:

22_1.3.1

Step 11

Open the RmsServiceManager.exe.config, in the ServiceManager file with notepad and check to ensure that the port = 8091:

22_2.3.0

 

Open the NLog.config, in the ServiceManager file with notepad and check to ensure that the path is set to rms_files:

23_2.3.0

 

Open the web.config, in the wPage file with notepad and check to ensure that the localhost:8091:

24_2.3.0

 

Open the web.config, in the wService file with notepad and check to ensure that the localhost:8091:

25_2.3.0

 

Open the NLog.config, in the wService file with notepad and check to ensure that the path is set to rms_files:

26_2.3.0

Step 12

Right click on the Update2ToVxx.cmd and run as administrator to run the update command and follow the steps in the script:

27_2.3.0

 

IMPORTANT: should the URL (C:\inetpub\wwwroot\rms\22325) not be correct, then the URL needs to be changed within the Update2XT0231.cmd file via right click and edit.

 

28_2.3.0

 

29_2.3.0

 

30_2.3.0

 

31_2.3.0

 

32_2.3.0

 

33_2.3.0

Step 13

Recycle Application Pool .NET V4.5 (in IIS Manager>Application Pools>Recycle).

 

34_2.3.0

Step 14

Test to see if the website and the webservice are running: Software Installation Testing.

 

If the following screen appears, simply refresh the URL:

35_2.3.0

 

The following print screen should appear:

36_2.3.0

Step 15

If additional fonts are required: RMS V2.1 Add the Help Menu and Report Fonts.

Step 16

Update the Documentation path in the RMS software accordingly. The update created a new folder. The software update has created a new folder. We recommend either leaving the old folder as it is or integrating everything into the new one. If background images, layouts, etc. are used in the software, they must be copied from the old folder to the new one.

 

 

Log into RMS and select Tools>Setup>System:

41_1.3.1

 

Update the documentation path:

42_1.3.1

Step 17

Once the software updated, ensure that a new license key is also added: Update your License Code.