CA Client Automation

Hola estoy realizando un upgrade de la versión 12.8.0690 a la 14.0.2 y me sale el error siguiente MDBTools install error=1 

There is another log somewhere in %temp%, install_mdb.log, which covers the MDB tools portion of the install.  Please check or post that log to the community, as it should lead us to the issue...

hola,
En el log me vuelve a salir solo ese error 09-04,15:41:43 MDBTools install error=1 
Adjunte el log  install_mdb 
Saludos.

I see the following in the install_mdb log:

09-04,15:29:26 INFO - MDBTools_0319I - Reconciliation detected that foreignkey 'fk__tng_class__class__4a0fa628.xml' is missing from the database
09-04,15:29:26 INFO - MDBTools_0319I - Reconciliation detected that foreignkey 'fk__tng_prope__class__4b03ca61.xml' is missing from the database
09-04,15:41:38 INFO - MDBTools_0104I - Total time: 1H:6M:58S.
09-04,15:41:43 MDBTools install error=1
09-04,15:41:43 Setupmdb exit return code=1

Looks like a trigger that is listed to be a part of the database, is not found.  And for some reason it also did not get installed.

The trigger name has "tng", which would indicate it is related to CCS functionality.

I understand this is an upgrade from ITCM 12.8.  Do you have the CCS feature-set installed?

Hi Lorena,

I could see a big delay of 12 minutes between these 2 lines :

09-04,15:29:26 INFO - MDBTools_0319I - Reconciliation detected that foreignkey 'fk__tng_prope__class__4b03ca61.xml' is missing from the database
09-04,15:41:38 INFO - MDBTools_0104I - Total time: 1H:6M:58S.

Maybe there are some running SQL activities locking SQL tables ?

Please make sure that all process using mdb database are stopped before doing the upgrade.

Maybe you could restart SQL Server service "SQL Server (MSSQLSERVER)" to make sure that all sessions are closed and try again the upgrade.

Thanks.

Regards,

Jean-Yves