How to
Detaching a WebReports Database
You detach a WebReports database to make the database available for subsequent attachment (when installing or upgrading WebReports to another operating system or computer).
Use this workflow to upgrade an Enterprise Server system from version 1.7.x to version 1.8.x. An Enterprise Server system can include an Enterprise Server, one or more SmartStruxure server devices and WorkStations, and supporting administrator software, such as Device Administrator.
Prepare LonWorks Systems
The following flowchart shows the tasks for preparing LonWorks configurations for a version 1.8.x upgrade. Related information can be found in the sections after the flowchart.
If you upgrade from 1.7.1 to 1.8.x, install the latest version of WorkStation Add-on: SE.SBO.WorkStation - 1.7.1.500xx - AddOn.exe .
If you upgrade from 1.7.2 to 1.8.x this is not necessary.
In WorkStation , select the Enterprise Server and prepare the LonWorks configurations in all online SmartStruxure servers for version 1.8.x upgrade.
For more information, see Preparing LonWorks Configurations for Upgrade .
The preparation must be performed on all SmartStruxure servers containing LonWorks configurations in order to be able to upgrade to version 1.8.x.
If any preparation on a SmartStruxure server device fails, a preparation can be done locally on the SmartStruxure server device before upgrade to version 1.8.x.
Prepare for Upgrade
Prior to upgrading a system, complete the tasks listed in the following flowchart. Related information can be found in the sections after the flowchart.
If you are upgrading WebReports, stop the Reporting Agent Windows service. For more information, see Stopping the Reporting Agent Windows Service .
Perform a new All data backup of the Enterprise Server and SmartStruxure server devices when backing up the system.
For more information, see Backing Up SmartStruxure Servers Manually .
For systems that include a Reports Server, back up the WebReports database.
For more information, see Backing Up the WebReports Database .
If you are upgrading the License Server, use the Services tool to stop the License Server Windows service. For more information, see Stopping the License Server .
Upgrade Building Operation Software
The following flowchart shows the tasks for upgrading the Building Operation software, except SmartStruxure server devices. Related information can be found in the sections after the flowchart.
Upgrade the License Server and License Administrator. For more information, see Upgrading the License Administrator and the License Server .
Upgrade the Device Administrator. For more information, see Upgrading the Device Administrator Installation .
Install the Enterprise Server and select Upgrade current version to . For more information, see Upgrading the Enterprise Server .
If a newer version of Enterprise Server already is installed, ensure that the Enterprise Server Windows service of this version is stopped.
If Device Administrator is running on the same PC as the Enterprise Server, you can simulate the Enterprise Server upgrade to see if you can fix configuration issues in the Enterprise Server before you upgrade it. For more information, see Previewing the Enterprise Server Database Upgrade .
The Enterprise Server Windows service automatically restarts after the Enterprise Server upgrade is complete. If the Enterprise Server Windows service does not start, restart the computer.
If you are using a language pack in WebStation, install the language pack and change the language setting in WebStation.
For more information, see Adding a Language in WebStation .
For more information, see Changing the Language in WebStation .
Upgrade WorkStation and select the editor tools and language packs you want to upgrade. For more information, see Upgrading WorkStation and Client Tools Installation .
Keep one WorkStation at version 1.7.1.500xx in case you need to make configuration changes to 1.7.x SmartStruxure server devices, or if you need to perform LonWorks configuration preparations locally on a SmartStruxure server device before version 1.8.x upgrade.
Upgrade SmartStruxure Server Devices
The following flowchart shows the tasks for upgrading SmartStruxure server devices. Related information can be found in the sections after the flowchart.
Ensure that all SmartStruxure server devices with LonWorks configurations have been prepared for version 1.8.x upgrade. For more information, see . Prepare LonWorks Systems.
Use the upgraded Device Administrator to upgrade the databases of the SmartStruxure server devices using the IP network or USB port. For more information, see Uploading and Upgrading a SmartStruxure Server Device .
Open the Device Administrator upgrade log to get detailed information about the SmartStruxure server device upgrade process. For more information, see Opening the Upgrade Log .
You can postpone the upgrade of some SmartStruxure server devices running version 1.7.x, while you upgrade the Enterprise Server, WorkStation, and other SmartStruxure server devices to version 1.8.x.
Open the two conversion logs to see warning and error messages that occurred when the databases were upgraded.
Use Device Administrator to open the Conversion log. For more information, see Opening the Conversion Log .
In Windows, open the High Priority Conversion log. For more information, see Opening the High Priority Conversion Log .
Determine if you can use the converted database for download or if you need to fix configuration issues in the SmartStruxure server device.
For more information, see Conversion Logs .
For more information, see Log Entry Interpretation .
When you are comfortable with the content of the High Priority Conversion log, use Device Administrator to download the upgraded database to the SmartStruxure server device.
For more information, see Downloading an Upgraded Database to a SmartStruxure Server Device .
Reset and Confirm Server Functions
The following flowchart shows the tasks for confirming the functions of the SmartStruxure servers. Related information can be found in the sections after the flowchart.
Use the Software Administrator (or the Services tool) to verify that the Enterprise Server Windows service is running. For more information, see Starting the Enterprise Server Windows Service .
In WorkStation, verify that the control and monitoring operations of the Enterprise Server are functioning normally according to the guidelines specified for your site.
In the Security Certificate Risk dialog box, click Trust certificate to temporarily trust the certificate and log on to the SmartStruxure server.
If you upgrade from version 1.7.x or earlier, the upgrade changes the default SMTP port from 25 to 587. To use the SMTP port number 25, reset it after the upgrade.
For more information, see Selecting and Specifying an Email Server for Email Notifications .
In Binding Diagnostics, check for invalid or unresolved bindings. For more information, see Checking the Status of Bindings .
Replace any invalid or unresolved bindings with new bindings, using the Bindings view. For more information, see Bindings Management .
The system may require 10 to 30 minutes to complete the process of fixing invalid or unresolved bindings. Wait for this process to finish before editing the bindings.
In WorkStation, generate, add, and activate certificates for the SmartStruxure servers.
For more information, see Generating a Certificate .
For more information, see Adding a Certificate .
For more information, see Activating a Certificate .
After an upgrade to 1.8.1, you can delete obsolete LonWorks objects from your SmartStruxure server devices to increase available space. This must be done when the whole system has been upgraded.
For more information, see Delete Obsolete LonWorks Objects .
On the computer running the current version of WebReports, stop the Reporting Agent service by way of the Control Panel.
Ensure that any other applications that might be accessing the database are closed.
Open SQL Server Management Studio (type SQL in the Start menu Search box).
Expand the Databases folder.
Right-click the WebReports database, click Tasks , and then click Detach .
action_zoom_plus_stroke 
Select Drop Connections and then click OK .
action_zoom_plus_stroke 
Copy all the files in C:\Program Files (x86)\Schneider Electric\StruxureWareReports\DatabaseFiles to a convenient location, for later attachment.
Note:Save the database files to an external device such as a USB memory device.
You now attach the database at the computer where you want to install WebReports. For more information, see Attaching a WebReports Database .
Enterprise Server System Upgrade Workflow
Attaching a WebReports Database