The following error occurs when you apply Hot Fix B5C004 or later to SAS Infrastructure for Risk Management 3.4 and you then upgrade to release 3.5:

To work around this error:

1. Locate the following lines in the irmMigrateDatabase_34_35.sql file, which resides in the SASHOME/SASInfrastructureforRiskManagementServerConfiguration/3.5/Config/Deployment/sql/ directory.
   Add MV_NAMES, MV_VALUES column to DATA_OBJ
   alter table DATA_OBJ add column MV_NAMES character varying(255);
   alter table DATA_OBJ add column MV_VALUES character varying(255);
2. Add comment delimiters (double hyphens) in front of the lines above, as shown here:
   -- Add MV_NAMES, MV_VALUES column to DATA_OBJ
   -- alter table DATA_OBJ add column MV_NAMES character varying(255);
   -- alter table DATA_OBJ add column MV_VALUES character varying(255);
3. Click Retry. The SAS^® Deployment Wizard should then configure as expected.

Operating System and Release Information

A fix for this issue for SAS Infrastructure for Risk Management Server Configuration 3.5 is available at:

A fix for this issue for SAS Infrastructure for Risk Management 3.5 is available at: