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

<< Click to Display Table of Contents >>

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

Update from >V2.0 to V2.4.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.4.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\241.23015”.

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 (password: Rotronic123):

update V240 14

 

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

update V240 15

Step 2

Open SQL Server Management Studio:

update V240 16

 

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.

update V240 17

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.

update V240 18

 

update V240 19

 

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 240.23070 folder, install the .Net Framework V4.8.0 or newer, double click on the file npd480-WEB.exe:

update v240 20

 

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.

update v240 21

 

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 241.23015 folder, update the connections.config file of the new software installation based upon the settings of the current software installation.

update v240 22

 

Edit, if required, the connection string (via Notepad) if the in connections.config in folder C:\inetpub\wwwroot\RMS\241.23015\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:

update v240 23

 

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 Update1xTo241.cmd

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

 

update v240 24

Step

10

Open the Update2ToV240.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:

update v240 25

Step 11

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

update v240 26

 

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

update v240 27

 

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

update v240 28

update v240 29

 

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

update v240 30

 

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

update v240 32

Step 12

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

update v240 33

 

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

 

update v240 34

 

update v240 35

 

update v240 36

 

update v240 37

 

update v240 38

 

update v240 39

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.

 

Updated: 25.08.2023.