When doing an upgrade you first need to Upgrade them MDB, especially if your MDB is on a remote machine.
When you get to the following Screen you select OK:
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).
Why am I getting an Appcrash with dsminfoa.dll when upgrading my MDB ?
CA Client Automation - All Versions
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).
To resolve the issue do a DSMver to find out what version of DSM you are at now:
Then use that version to create the ca_settings record :
insert into ca_settings(set_id,set_val_text)
Now if you look at the ca_settings table, it will list the ca_settings 903 record:
A similar issue, is when doing an upgrade you get Appcrash msvcr100.dll:
This is caused by the ca_settings, record 903 has a value that is not a correct version
To resolve this change the incorrect version to a "real version" (again, check DSMVER)
set set_val_text= '184.108.40.2068'
where set_id = 903
This will change the ca_settings table to the correct version and this will allow the upgrade to progress.