Configuration Failed attempting to configure Deployment Solution

book

Article ID: 172021

calendar_today

Updated On:

Products

Deployment Solution

Issue/Introduction

After running a 'Perform full repair' or 'Reconfigure installed products' from SIM the following error occurs:

Configuration failed while attempting: Configure Deployment Solution 8.1 RU7

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Working with customers support has noticed that the error message appears to vary on a per environment basis. 

Console shows: Configuration failed while attempting: Configure Deployment Solution 8.1 RU7

The Altiris Log Viewer on the notification server will show a message similar to this:

Failed to install the product from the file: AC:\Program Files\Altiris\Deployment\Config\Altiris.Deployment_Hotfix.config

Column names in each table must be unique. Column name 'UseiPXE' in table 'Automation_Image_Configuration' is specified more than once.

Cause

The Altiris.Deployment_Hotfix_SQL.config configuration file doesn't handle the already installed iPXE table and fails to complete the re-configuration.

Environment

ITMS installations that include Deployment Solution 8.1 RU7

Resolution

  1. Open C:\Program Files\Altiris\Deployment\Config\Altiris.Deployment_Hotfix_SQL.config
  2. Replace these lines starting at 265:

ALTER TABLE  [Automation_Image_Configuration]
ADD UseiPXE nvarchar(50);

  1. With these lines:

IF NOT Exists (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Automation_Image_Configuration'
AND COLUMN_NAME = 'UseiPXE')
BEGIN
ALTER TABLE [Automation_Image_Configuration]
ADD UseiPXE nvarchar(50);
END

  1. Save the changes, and start the reconfigure over again.

 

 

Attachments