Database Settings page loops, never completes | Connect 8

After you upgrade to Adobe Connect 8, sometimes the Install wizard opens the Database settings page on the console. When you click Next, the first screen reappears. 

Solution

Make a backup of  your breeze database before running the below query.

The sample log files above indicate that the TOS_STATUS column is missing. Run the query to create the missing column as identified in the logs:

alter table PPS_ACCOUNTS

add TOS_STATUS nchar(1);  

The log files sometimes indicate that other columns are missing. Use the following queries to create those missing columns manually.

alter table PPS_ACCOUNTS add COMMENTS nvarchar(1024);

alter table PPS_ACCOUNTS add TEMPLATE_ID int;

alter table PPS_ASSETS add ASSET_INFO_BITSET int;

Additional information

The Adobe Connect 8 upgrade fails because some required columns aren't automatically created during the upgrade process. 



To find out which database columns are missing, open the log file at C:\breeze\debug.log: