Problem

It has been discovered that some upgrades from 5.10.1.x.x will have an ActiveFtpDmz table that was not migrated to the latest style. Upon upgrading to 5.12 it becomes evident when trying to save changes to the "Configure outbound connection proxy" page for Secure Relay.

Resolution

*before continuing, please be sure to have industry standard backups of your database*

1.) Stop your Interchange.

2.) Have your DBA backup the database and then delete the ActiveFtpDma table

3.) You may delete the ActiveFtpDmz table and then recreate it using the following script:

MY-SQL/Oracle:
CREATE TABLE ActiveFtpDMZ(
OID numeric(19,0) NOT NULL PRIMARY KEY,
ActiveExternalHost varchar(128) NULL
);

MS-SQL:
CREATE TABLE [databasename].[dbo].[ActiveFtpDMZ](
OID numeric(19,0) NOT NULL PRIMARY KEY,
ActiveExternalHost varchar(128) NULL
);

4.) Restart your Interchange, test saving on the noted page.