Upgrading Reports Server from 1.4.1 to 1.5

[#1]

Warning

Issue

Upgrading Reports Server from 1.4.1 to 1.5

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.