Table of Contents

    

ISSUE:

 

Installing a FIM CM R2 patch fails with the following dialog.

 

---------------------------
FIM Certificate Management
---------------------------
FIM CM Database upgrade failed with the following exception:
An error occurred: Problem while executing the SQL statement
--********************************************************
--*                                                      *
--*   Copyright (C) Microsoft. All rights reserved.      *
--*                                                      *
--********************************************************
/* Parameters:  */
USE
GO
 
IF NOT EXISTS (
    SELECT [column_name]
    FROM INFORMATION_SCHEMA.columns
    WHERE
            [table_name] = 'CertificateAuthority'
        AND [column_name] = 'ca_exit_module_version')  
BEGIN       
    ALTER TABLE [CertificateAuthority]
        ADD [ca_exit_module_version] VARCHAR(50) NULL
END
GO

 

A verbose MSI log indicates the following.

Executing op: CustomAspan>ALTER TABLE [CertificateAuthority]