MDB Install: During a new MDB install or upgrade, error code 9024, a post install step failed, is received.

book

Article ID: 18488

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager

Issue/Introduction

While running the installation of CA client Automation during the setup or upgrade of the MDB, the following error is seen:

Error Code: 9024
Post install step failed
failed to apply post install step [sqlcmd.exe -S "$fqslserveraddr" -d $dbname -E -e -i .\mdb_install\mssql\synonyms.sql]


<Please see attached file for image>

Figure 1

Cause

The problem is that the following file is missing from the install media: 
..\WindowsProductFiles_x86\CCS\MdbOnly\database\mdb_install\mssql\synonyms.sql

This can happen depending on the software used to extract the DVD media.  The synonyms.sql file is 0kb in size, which some applications will skip when extracting the DVD media. As the file is empty and checked by the MDB installer,

Environment

Client Automation (ITCM) -- any version.

Resolution

1- You can manually create the missing file at the path mentioned.
  --or--
2- Use WinRar to extract the .ISO file
  --or--
3- Run the MDB installation first using 'setup.bat' from the following folder:
..\WindowsProductFiles_x86\mdb

Attachments

1558694438957000018488_sktwi1f5rjvs16mm9.gif get_app
1558694437115000018488_sktwi1f5rjvs16mm8.gif get_app