Upgrade of MDB for CA Client Automation fails with Appcrash with dsminfoa.dll error

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

Introduction:                                        

When doing an upgrade you first need to Upgrade them MDB, especially if your MDB is on a remote machine.

<Please see attached file for image>

 

When you get to the following Screen you select OK:

<Please see attached file for image>

You will see the following Error Screen popup with the following Appcrash in dsminfoa.dll  

and in the Application Event viewer you will see the following Errors (Error 1638).

<Please see attached file for image>

    

<Please see attached file for image>

 

Question:

Why am I getting an Appcrash with dsminfoa.dll when upgrading my MDB ?

 

Environment:                                          

 

CA Client Automation - All Versions 

 

Answer:

This problem is caused by a missing entry in the ca_settings table.

The version of the mdb is listed in the ca_settings table in the set_id column under the 903 record (which is missing from this table).

<Please see attached file for image>

 

To resolve the issue do a DSMver to find out what version of DSM you are at now:

<Please see attached file for image>

Then use that version to create the ca_settings record :

use mdb

  insert into ca_settings(set_id,set_val_text)

  values (903,'12.9.0.338')

 

Now if you look at the ca_settings table, it will list the ca_settings 903 record:

<Please see attached file for image>

 

A similar issue, is when doing an upgrade you get Appcrash msvcr100.dll:

<Please see attached file for image>

 

This is caused by the ca_settings,  record 903 has a value that is not a correct version

<Please see attached file for image>

 

 

To resolve this change the incorrect version to a "real version" (again, check DSMVER)

 

  update ca_settings

  set set_val_text= '12.9.0.338'

  where set_id = 903

 

This will change the ca_settings table to the correct version and this will allow the upgrade to progress.

 

Environment

Release: UASIT.99000-12.8-Asset Intelligence
Component: