Update from RMS to V2.5.3 of the RMS Software

<< Click to Display Table of Contents >>

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

Update from RMS to V2.5.3 of the RMS Software

Within the Rotronic Software Contract, a link to download the RMS software is stated within the Annex.

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 <V1.3.3 and >2.0.0 to the V2.5.3. 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 (<V1.3.3 or >V2.0.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\253.24003”.

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 2501

 

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

update 2502

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 under Media Options is selected to verify the backup when finished:

5_2.3.0

 

Go to General, press add and select the backup destination:

update 2503

 

Remove all paths except the one added:

update 2504

 

Click on OK, the database should then be backed up.

update 2505

Step 4

Update the database tables using the "Rotronic-Rms-Tables". Click on "File" at the top left of the SQL Server Management Studio and then on "Open" and then on "File..." again.

update 2506

 

Go to the RMS folder and double click on the script "0000-Rotronic-Rms-Tables":

update 2507

 

The following data will be shown:

update 2508

 

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

update 2509

 

Once executed, the following screen should be visible:

update 25010

Step 5

Update the RMS SQL indices, via the SQL Server Management Studio, click on "File" at the top left and then on "Open" and then on "File..." again and do to the RMS folder.

update 25011

 

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

 

Based upon the MS SQL version, double click on the either

"0200-RMS_SQL_Indices (SQL 2014 or older)" or

"0200-RMS_SQL_Indices":

update 25012

 

The following overview will appear:

update 25013

 

Please check in which database you will run this script. The rms database should be shown in the left top field! Click on execute:

update 25014

 

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

update 25015

Step 6

Install the .Net Framework V4.8.0 or newer in the Dependencies folder under 253.24003, double-click on the file "npd48-web.exe":

update 25016

 

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

 

If .NET framework V4.8 is 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 253.24003 folder, update the connections.config file of the new software installation based upon the settings of the current software installation.

 

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

update 25017

 

The pre-existing connections.config data can be found in:

C:\inetpub\wwwroot\RMS\xxxxx\ServiceManager or

C:\inetpub\wwwroot\RMS\xxxxx\wPage.

update 25018

 

Here is for example an overview of the current and new files. The new connections.config should be based upon the settings of the current connections.config:

Data Source,

Initial Catalog,

User ID,

Password.

update 25019

 

If the current version is 2.4.0 or newer, the connections.config in the SqlMonitor folder must also be updated:

update 25020

 

update 25021

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 4 and 5 and execute the "0000-Rotronic-Rms-Tables" and "0200-RMS_SQL_Indices":

clip0116

 

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

update 25022

Step 9

The ports and paths of the new version must be checked. Not all versions have the folders for which the ports and paths needs to be checked. Please note the versions:

 

For versions: >V2.0.0 or higher: Open the file RmsServiceManager.exe.config under the ServiceManager folder for the new and current version and check to ensure that the port is based on the settings of the current port.

(Port 8091 is the default port.)

 

update 25023

 

For versions: >V2.0.0 or higher: Open the file NLog.config under the ServiceManager folder for the new and current version and check to ensure that the path is based on the settings of the current path.

update 25024

 

For versions: <V1.3.3 and >V2.0.0 or higher: Open the file Web.config under the wPage folder for the new and current version and check to ensure that the localhost port is based on the settings of the current localhost port.

update 25025

 

For versions: <V1.3.3 and >V2.0.0 or higher: Open the file Web.config under the wService folder for the new and current version and check to ensure that the localhost port is based on the settings of the current localhost port.

update 25026

 

For versions: >V2.0.0 or higher: Open the file NLog.config under the wService (or wService\bin) folder for the new and current version and check to ensure that the path is based on the settings of the current path.

update 25027

 

For versions: >V2.4.0 or higher: Open the file RmsServiceManager.exe.config under the ServiceMonitor folder for the new and current version and check to ensure that the localhost port is based on the settings of the current localhost port.

update 25028

 

For versions: >V2.4.0 or higher: Open the file NLog.config under the ServiceMonitor folder for the new and current version and check to ensure that the path is based on the settings of the current path.

update 25029

Step

10

Open the file UpdatexxToV253.cmd with Notepad and on the current version (only from version >V2.0.0 or higher) open the file InstallRmsVxxx.cmd with Notepad to make sure that wPageName, wServiceName and ManagerInstance are all correct.

 

Important Note:

If you update from <V1.3.3, open the Update1xTo252.cmd

If you update from >V2.0.0 or higher, open the Update2xTo252.cmd

update 25030

 

Here is for example an overview of the current and new files. The new UpdatexxToV253.cmd should be based upon the settings of the current InstallRmsVxxx.cmd:

update 25031

 

For versions <V1.3.3 you will find the wPageName and wServiceName in the IIS:

wservice and wpage

Step 11

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

update 25032

 

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

 

update 25033

 

update 25034

 

update 25035

 

update 25036

 

update 25037

 

update 25038

Step 12

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

update 25039

Step 13

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

 

If the following screen appears, simply refresh the URL:

update 25040

 

The following print screen should appear:

update 25041

Step 14

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

Step 15

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:

update 25042

 

Update the documentation path:

update 25043

 

This must match the file patch:

update 25044

Step 16

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

 

Updated: 05.09.2024