Upgrade BrightWork

This article describes how to upgrade BrightWork for SharePoint 2019 from a previous version of BrightWork for SharePoint 2019.

Part of this process involves uninstalling the BrightWork solution before installing the newer version. This process does not affect your data or customizations.

At a high-level the sequence of steps are as follows:

1. Pre-Requisites
2. Uninstall BrightWork
3. Install BrightWork
4. Update Servers
5. Activate BrightWork Timer Jobs
6. Adjust BrightWork Timer Jobs
7. Run psconfig

Pre-Requisites

• You need administrative privileges on your SharePoint server to install BrightWork.
• While installing, you need full control access to the SQL Admin Content Database.
• We recommend you create a full backup of your SharePoint installation before starting the installation.

Uninstall BrightWork

To uninstall BrightWork:

1. Right-click on the SharePoint 2019 Management Shell and select Run as administrator.

   

2. Run this command:

   cd "C:\Program Files (x86)\BrightWork\16\Install Files"

3. Run this command:

   .\UnInstallSolution.ps1 BrightWork.wsp

4. When the "Solution BrightWork.wsp is now removed" message displays, close the SharePoint Management Shell.

   

5. Navigate to the Control Panel | Programs and Features page.
6. Click on BrightWork for SharePoint 2019 and click Uninstall.

Install BrightWork

1. Copy the BrightWork installer to your server desktop and double-click on it to begin the installation.
2. Click Next.
3. Review the License Agreement, select I Accept and click Next.
4. Click Install, then click Finish.
5. Right-click on the SharePoint 2019 Management Shell and select Run as administrator.

6. Run this command to change to the install files folder:

   cd "C:\Program Files (x86)\BrightWork\16\Install Files"

7. Next, run this command:

   .\InstallSolution.ps1 "C:\Program Files (x86)\BrightWork\16\Install Files\BrightWork.wsp"

8. Close the SharePoint Management Shell when "Solution BrightWork.wsp is now installed" displays.

   Note: Please ensure you close the SharePoint Management Shell before proceeding with the next step. This ensures that it is running under a different process.

9. Right-click on the SharePoint 2019 Management Shell, click Run as administrator and run this command:

   Install-BWDiagnosticsService

10. Close the SharePoint Management Shell.

Update Other Servers in the Farm

Follow the steps below on all other servers in the farm.

1. Right-click on the SharePoint 2019 Management Shell and click Run as administrator.

2. Run the following commands (in sequence) on each front end server the solution has been deployed to:

   iisreset

   net stop sptimerv4

   net start sptimerv4

   Install-SPApplicationContent

3. Close the SharePoint Management Shell.
4. Right-click on the SharePoint 2019 Management Shell and click Run as administrator.

5. Run the following command:

   Install-BWDiagnosticsService

Activate BrightWork Timer Job Features

1. Login to SharePoint Central Administration.
2. Click Manage web applications.

3. Ensure you have the correct web application selected and click Manage Features.

   Note: The timer job features must be activated on a web application by web application basis.

4. Click Activate beside the following timer jobs:

   • BrightWork Metric Recalculation Timer Job
   • BrightWork Project Cache Maintenance Timer Job
   • BrightWork Project Status Report Cache Maintenance Timer Job
   • BrightWork Scheduled Email Timer Job
   • BrightWork Task Scheduling Timer Job
   • BrightWork User Access Report Timer Job
   • BrightWork Work Cache Maintenance Timer Job
5. Click OK.

Adjust BrightWork Timer Job

If you have previously adjusted your BrightWork Timer Jobs, you need to do so again to reapply your changes.

The main timer jobs should run at least once a day in the following sequence:

• User Access Report (Monthly - default is the 1st of the month at 12:00am)
• Task Scheduling (Daily - default time 12:00am to 12:30am)
• Project Metrics Refresh (Daily - default time 1:30am to 2:00am)
• Project Status Report Cache Refresh (Daily - default time 2:30am to 3:00am)
• Project Cache Refresh (Daily - default time 3:00am to 3:30am)
• Work Cache Refresh (Daily - default time 3:30am to 4:30am)
• Scheduled Email (Daily - default time 4:30am to 5:00am)
• Work Cache Update (Daily - runs every 15 minutes)

To ensure projects metrics are up to date, the Project Metrics Refresh can be run as frequent as you like. At BrightWork we run the Project Metrics Refresh every 15 minutes.

Project Schedule Refresh timer job takes place from 12.00am to 12.30am. This is a timer job for a deprecated list. Therefore, if you do not use it, you do not have to use this timer job.

To adjust the timer job schedule:

1. Click Monitoring on the Central Administration Quick Launch.
2. Click Review job definitions.
3. Click the BrightWork timer job you want to adjust.
4. Make your adjustments and click OK.

Run psconfig

The SharePoint Products Configuration Wizard (psconfig) is a SharePoint Utility that needs to be run periodically for proper SharePoint maintenance. It is needed in BrightWork to update existing Site Collections with new features added in a release.

Please note that the psconfig utility can highlight issues with the configuration of your SharePoint Server Farm.

To run psconfig:

1. Right-click on the SharePoint 2019 Management Shell and click Run as administrator.

2. Next, run the following command to perform a build-to-build upgrade using the SharePoint psconfig.exe utility:

   psconfig.exe -cmd upgrade -inplace b2b -force -includesiteupgrade

3. The below screen should display.

   

4. Run iisreset and close the window once "Internet services successfully restarted" is displayed.

BrightWork should be successfully upgraded.