Skip to content

Update RMS to V2.5.2 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: [email protected].

Installing Multiple Instances.

Follow these guidelines for the upgrade of a software version 2.0.0 to the V2.5.2. 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.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\252.24169”.

  • 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 252.24169, 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 252.24169 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\252.24169\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: 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: 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 UpdatexxToV252.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 - 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 UpdatexxToV252.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 UpdatexxToV252.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\252.24169) not be correct, then the URL needs to be changed within the UpdatexxTo252.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