Update from >V2.0 to V2.4.0 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: [email protected].

Installing Multiple Instances.

Follow these guidelines for the upgrade of a software version >2.0 to the V2.4.0. 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\240.23070”.

• 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): Copy it into a folder with the version number parallel to the currently installed version: "C://inetpub/wwwroot/rms/{version}".
Step 2	Open SQL Server Management Studio: Login to the SQL Server as ADMIN or SA user:
Step 3	Create a backup of the RMS database, right click on the rms database>Tasks>Back Up... Select a full backup to the disk and click on OK: Ensure that the tick box is selected to verify the backup when finished, click on OK: Select the backup destination: The database should then be backed up, click on OK.
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. 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! Once executed, the following screen should be visible:
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. The following overview will appear: Once executed, the following screen should be visible (take this print screen for validation purposes):
Step 6	In the 240.23070 folder, install the .Net Framework V4.8.0 or newer, double click on the file npd480-WEB.exe: 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. Installation of the .NET framework, click on Install. The installation will start: Once completed, the following screen will appear: A server restart is required:
Step 7	In the 240.23070 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\240.23070\ServiceManager: - Data Source, - Initial Catalog, - User ID, - Password. The existing connections.config data can be found in C:\inetpub\wwwroot\RMS\xxxxx\wPage. Here is the overview of the old and new files:
Step 8	Test the connection to the database, by double clicking on the TestDatabase.cmd command: If the following screen appears, return to step 5 and execute the "Rotronic-RMS-Tables": The following screen should be shown if the test is successful:
Step 9	\	Important Note If you update from If you update from >V2.0.0 or higher, use the Update2xTo240.cmd \	\	--- \
Important Note If you update from If you update from >V2.0.0 or higher, use the Update2xTo240.cmd
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: The correct details are listed below in yellow:
Step 11	Open the RmsServiceManager.exe.config, in the ServiceManager file with notepad and check to ensure that the port = 8091: Open the NLog.config, in the ServiceManager file with notepad and check to ensure that the path is set to rms_files: Open the web.config, in the wPage file with notepad and check to ensure that the localhost:8091: Open the web.config, in the wService file with notepad and check to ensure that the localhost:8091: Open the NLog.config, in the wService file with notepad and check to ensure that the path is set to rms_files:
Step 12	Right click on the Update2ToVxx.cmd and run as administrator to run the update command and follow the steps in the script: IMPORTANT: should the URL (C:\inetpub\wwwroot\rms\240.23070) not be correct, then the URL needs to be changed within the Update2XT0240.cmd file via right click and edit.
Step 13	Recycle Application Pool .NET V4.5 (in IIS Manager>Application Pools>Recycle).
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: The following print screen should appear:
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: Update the documentation path:
Step 17	Once the software updated, ensure that a new license key is also added: Update your License Code.

Update date: 24.07.2023.