New install fails with "Error code 3: MDBTools install error: setup MDB failed, please see install_<dbname>.logfile for details"

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
• CA Server Automation

Issue/Introduction

• Install of new DM fails with the following error
  
  
• "Error Code: 3
  
  
• MDBTools install error: setup MDB failed, please see install_<dbname>.log file for details"
  
  
• install_mdb.log contains the following entries
  
  
• 05-08,23:58:55 INFO - MDBTools_0339I - Upgrading object 'ca_software_def[upmuser_group].xml' from version '0.0' to version '1.0'
  C:\Users\Z-SVC-~1\AppData\Local\Temp\ITRM\database\mdb_install\ITCM_mssql\schemas\Unicenter Patch Management\DBPermission\ca_software_def_class_def_matrix[upmadmin_group].xml not found
  05-08,23:58:56 ERROR - MDBTools_0401E - Object 'ca_software_def_class_def_matrix[upmadmin_group]' in class DBPermission not found.
  05-08,23:58:56 INFO - MDBTools_0303I - Processing permission: ca_software_def_class_def_matrix[upmadmin_group].xml timestamp: null
  05-08,23:58:56 INFO - MDBTools_0305E - Error processing permission 'ca_software_def_class_def_matrix[upmadmin_group].xml'; details follow:
  05-08,23:58:56 ERROR - java.lang.RuntimeException: DBPermission 'ca_software_def_class_def_matrix[upmadmin_group]': MDBTools_0401E - Object 'ca_software_def_class_def_matrix[upmadmin_group]' in class DBPermission not found.
  java.lang.RuntimeException: DBPermission 'ca_software_def_class_def_matrix[upmadmin_group]': MDBTools_0401E - Object 'ca_software_def_class_def_matrix[upmadmin_group]' in class DBPermission not found.
  at com.ca.mdbtools.Utilities.readFromFile(Utilities.java:515)
  at com.ca.mdbtools.DriverApp$EntryIterator.next(DriverApp.java:4459)
  at com.ca.mdbtools.DriverApp.installSchemaDriver(DriverApp.java:920)
  at com.ca.mdbtools.Utilities.run(Utilities.java:1678)
  at com.ca.mdbtools.Utilities.main(Utilities.java:1042)
  05-08,23:58:56 ERROR - MDBTools_0309E - DBDriver failed to install!
  05-08,23:58:56 INFO - MDBTools_0104I - Total time: 0H:0M:53S.
  05-08,23:58:56 MDBTools install error=3
  05-08,23:58:56 Setupmdb exit return code=3

 

Environment

CA Client Automation - All Versions.

Cause

The install was being carried out from a image on a HD copied across the network and it had corrupted during the copy.

Resolution

Replace the install image.