Upgrading Reports Server from 1.4.1 to 1.5

NOTICE

COMPLEX PROCEDURE REQUIRED.
The resolution of this article has many complex steps that may result in unforeseen results if not performed correctly. If you are at all unfamiliar with the requirements, please contact Product Support Services for assistance.

Issue

Upgrading Reports Server from 1.4.1 to 1.5

Product Line

SmartStruxure Solution

Environment

StruxureWare Building Operation 1.5.0

Windows Server 2008 R2

Reports Server WebReports

Enterprise Server

Cause

Failure to follow upgrade guides may result in data loss.

The most likely point of failure seems to be running the Reporting Agent Service on the Reports Server while upgrading the Enterprise Server.

The Upgrade will error out if SQL2008 R2 is not upgraded to SP2 or .NET framework is not upgraded to 4.5 at the indicated points.

Resolution

This resolution process was developed from the System Upgrade Reference Guide and tested on a single PC. Windows Server 2008 R2 at StruxureWare Building Operation 1.4.1 running SQL2008 R2 SP1 and .NET 4.0 upgraded to StruxureWare Building Operation 1.5.0 SQL2008 R2 SP2 and .NET 4.5. 

You can find and download all 1.5.0 released software and documentation by searching the Building Download Center for the tag "relsbov1.5"

  1. Backup Enterpriser Server, All Automation Servers and Report Server. Store backups on external media. If desired, create a Windows snapshot for a quick return point.

  2. Download all StruxureWare Building Operation 1.5 Installation files, SQL2008 R2 Upgrade files and .NET 4.5 installer.

  3. Close all StruxureWare applications

  4. In the Windows Server Manager, Expand Configuration and Select Services

  5. Browse to “StruxureWare Reporting Agent”, right click on it and select stop

  6. Open Software Administrator and stop the ES service.

  7. Close Software Administrator

  8. In the Windows Server Manager - Services section, stop the service “Building Operation 1.4 License Server”

  9. Run the .NET 4.5 installer. If prompted to restart, select Restart Later. If the PC restarts on its own, verify that all services listed above are stopped before moving forward. (repeat on all PCs)

  10. Run the License Administrator 1.5.0 installer

  11. Run the Enterprise Server 1.5.0 installer; select the Upgrade current version option. Note the ports used. Port 80 should not be used for http communication when the ES is installed on the Same PC as the Report Server.

  12. If desired install the Project Configuration Server.  Be sure that the HTTP port is not the same as what is used for the Enterprise Server and not port 80

  13. Open Software Administrator and verify that both the Enterprise Server and PCS are running and using different ports

  14. Install Workstation. If you are upgrading from 1.4.1 to 1.5 and planning to delay the upgrade of the Automation Servers, you should install Workstation in parallel instead of upgrading

  15. Install Device Administrator. If you are upgrading from 1.4.1 to 1.5 and planning to delay the upgrade of the Automation Servers, you should install Workstation in parallel instead of upgrading

  16. At this time, upgrade any required Automation Servers. If upgrading from 1.4.0, all AS must be upgraded together.

  17. Install any required language packs

  18. If required, download and install the SQL2008 R2 upgrade to SP2 : http://www.microsoft.com/en-us/download/details.aspx?id=30437The default file name for the upgrade installer is SQLServer2008R2SP2-KB2630458-x64-ENU.exe

  19. In Windows Control Panel, go to Programs and Features

  20. Uninstall the “Building Operation Reports Installation” application only. This is the installer application for 1.4 Web Reports

  21. Run the Reports Server 1.5.0 installer

  22. Browse to C:\Program Files (x86)\Schneider Electric StruxureWare\Building Operation Reports Installer

  23. Right Click on SE.SBO.WebReports.Installer and select “Run as Administrator”

  24. For Setup Type, select “Upgrade both software and database”

  25. Fill in site specific information as instructed.

  26. For Reporting Agent, be sure to specify the exact Enterprise Server Address and port used.

  27. Follow the remaining prompts to install WebReports

  28. On completion, log into the StruxureWare WebReports interface and run a few test reports.