Channels Reporting Database - Upgrade Workaround

This article is to help users in case of a Channels Reporting Database failure on upgrade from Channels 9.4 CU9 to Channels 9.4 CU11

 
Perform the following steps after running the Channels 9.4 CU11 installer. in this scenario, Channels Service will start, and database upgrade will fail when the related upgrade script is executed.
  1. Stop all Channels Services and CommCore Services.
  2. Rename the currently installed <Channels install directory>\Channels\conf\MSSQLto_9.40.6044.sql  file to MSSQLto_9.40.6044.sql.OLD
  3. Download and copy the new MSSQLto_9.40.6044.sql (MSSQLto_9.40.6044.sql) to the <Channels install directory>\Channels\conf directory
  4. Restart Channels Services and wait for database upgrade to complete.
  5. Start all other services.