CA Client Automation

Expand all | Collapse all

MDB Installation error "ITCA"

  • 1.  MDB Installation error "ITCA"

    Posted 06-13-2018 04:04 PM

    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)

    zip
    mdb_install_ITCM.zip   39.48 MB 1 version


  • 2.  Re: MDB Installation error "ITCA"

    Broadcom Employee
    Posted 06-13-2018 04:11 PM

    What does the log say

     

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



  • 3.  Re: MDB Installation error "ITCA"

    Broadcom Employee
    Posted 06-21-2018 07:18 AM

    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



  • 4.  Re: MDB Installation error "ITCA"

    Posted 06-21-2018 11:36 AM

    Hi JY GUIBLET Employee,

     

    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.