MDB Installation error "ITCA"

[Marco Antonio Velazquez Aldama]

Hi Everyone,

 

Currently, I am working a distributed environment of CA SDM 17.

Server 1: mdb
Server 2: SDM

CA SDM has already been installed along with the mdb

and at the moment, I'm trying to install ITCM on server 3.

all the parameters were already registered without errors, but when the installation starts, it shows me the following error

---------------------------------
Error Code: 3

MDBTools install error: setup MDB failed, please see install_<dbname>.log file for details

MDBTools install error: setup MDB failed, please see install_<dbname>.log file for details
---------------------------------

Nota: Keep in mind that the mdb was installed with the CA SDM wizard, not the ITCM wizard. and the goal is to install ITCM by joining the existing mdb

 

Any idea for to resolve the issue? and how to solve it?

 

Attachment log

Regards,
Marco Velazquez.

Attachment(s)

Log mdb Installation error.txt.zip   3 KB 1 version

mdb_install_ITCM.zip   39.48 MB 1 version

[lecri01]

What does the log say

 

Get Outlook for Android<https://aka.ms/ghei36>

[Jean-Yves Guiblet]

Hi Marco,

 

Following error appears in file %TEMP%\mdb_install\install_mdb.log :

 

 

06-13,14:08:53 INFO - MDBTools_0305E - Error processing foreign key '$usm_t_r00002c7f00000000.xml'; details follow:

06-13,14:08:53 ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "$usm_t_r00002c7f00000000". The conflict occurred in database "mdb", table "dbo.usm_runtime_component", column 'runtime_component_id'.
com.microsoft.sqlserver.jdbc.SQLServerException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "$usm_t_r00002c7f00000000". The conflict occurred in database "mdb", table "dbo.usm_runtime_component", column 'runtime_component_id'.

 

 

 

 

Please check this document which gives a solution for this kind or error:

 

How to resolve an common error while installing IT - CA Knowledge 

 

Maybe it could resolve the installation problem ?

 

Thanks.

Regards,

Jean-Yves

[Marco Antonio Velazquez Aldama]

Hi JY GUIBLET ,

 

I executed the following query, as mentioned the document.

 

*******************************************************

select * from usm_runtime_component

*******************************************************

 

the table is empty, and I executed the query

 

*******************************************************

insert into usm_runtime_component
VALUES ('Scheduler',NULL,NULL,NULL,NULL,NULL)

*******************************************************

 

then, the instalation was executed correctly

Regards,
Marco V.