Adobe Connect 12 Upgrade from 11.x to 12.0 may result in Install error

Environment

Adobe Connect 12 on-premise Windows installer

How to verify you have the same issue

This issue may be observed if you’re performing an upgrade from Adobe Connect 11.2 or higher version to Connect 12, through the C12 Windows installer bits. Following errors would be observed in the logs if you’re running into this issue :

09-27 10:39:14: [SEVERE] – [class com.adobe.connectpro.install.panels.action.DBProcessAction] –
com.adobe.connectpro.config.utils.ConfigException[ACON-CONF-000-999]: Error.
at com.adobe.connectpro.config.processing.DBProcessScripts.executeScripts(DBProcessScripts.java:101)
at com.adobe.connectpro.config.processing.DBProcessScripts.runDBScripts(DBProcessScripts.java:129)
at com.adobe.connectpro.config.processing.DBProcessing.runUpgradeScripts(DBProcessing.java:521)
at com.adobe.connectpro.config.processing.DBProcessing.updateDatabase(DBProcessing.java:358)
at com.adobe.connectpro.config.action.DBScriptAction.runScripts(DBScriptAction.java:160)
at com.adobe.connectpro.install.panels.action.DBProcessAction.install(DBProcessAction.java:199)
at com.adobe.connectpro.install.panels.ComponentInstallation.PostInstallActions.postInstall(PostInstallActions.java:77)
at com.adobe.connectpro.install.panels.gui.InstallPanel$3.run(InstallPanel.java:461)
at java.lang.Thread.run(Thread.java:750)
Caused by: macromedia.jdbc.sqlserverbase.ddc: [Macromedia][SQLServer JDBC Driver][SQLServer]The INSERT statement conflicted with the FOREIGN KEY constraint “FK_PPS_ACL_FIELDS_FIELD_ID”. The conflict occurred in database “connect_test_db”, table “dbo.PPS_FIELD_NAMES”, column ‘FIELD_ID’.
at macromedia.jdbc.sqlserverbase.ddes.j(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddes.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddes.executeBatch(Unknown Source)
at com.adobe.connectpro.config.processing.DBProcessScripts.executeScripts(DBProcessScripts.java:64)

Solution :

1) In the table PPS_UPDATES_LOG you can see which scripts have been executed so far. Select * from PPS_UPDATES_LOG

2) The workaround is to run the 11.2.3.1 script without the version update; we got past the error with that db script.

3) Within the installer bits, goto, Adobe Connect 12.0.0.0\AdobeConnect_12_0_ALL\Adobe Connect\Merge_Modules\dbscripts.zip

The script is inside : fileset\dist\build\updates\update_11_2_3_1.sql

4) To execute it without the version update – before you run it, REMOVE this from near the end of the script.

UPDATE PPS_DATABASE_VERSION

                SET MAJOR_RELEASE = 11,

                MINOR_RELEASE = 2,

                [UPDATE] = 3,

                REVISION = 1

5) Keep everything else.

6) Re-run the script after the above modifications.

7) Execute the C12 upgrade again

Note : This is determined as Bug#CONN-4137194 and is under Engineering investigation for a fix with one of the upcoming updates