CA Client Automation

 View Only
  • 1.  Unable to Find Manager in Database

    Posted Dec 08, 2016 01:04 PM

    Hello.

     

    I'm back writing to the forum comunity because I have a problem with the SystemEngine.

     

    At the beginning, just after I finished installing the servers I went into DSM Explorer to check if my servers' agents where correctly detected/registered in Client Automation. I find no server registered.

     

    Investigating on the DSM Explorer I saw the "SystemEngine" stopped. Checking the logs I find the error "Unable to Find Manager in Database" on the file "SystemEngine.log" and with that went into the knowledge base where I find the document "Document ID: TEC428833" for versions 12.8 and 12.9 and I'm installing version 14.1.

     

    This document states this:

     

    <<The cause of the problem noted in this document can be related to the existence of duplicate rows in the ca_manager table>>

     

    As the document says I ran the query "select * from ca_manager" in my mdb and find that in fact there were 2 records:

    manager_uuiddomain_uuidlabelhost_uuidhost_name
    0x3391094E69C2124E988BCEA204603EF10xC00326E315FB164EBBBFDBBBF945D5A1ClntMgmt14EMCE67D3E3-9EB6-44B4-A8DC-A0E2BC59CAC0ClntMgmt14EM
    0x3ED1E2DD9961644F86EFC47E7B68A97A0xC00326E315FB164EBBBFDBBBF945D5A1ClntMgmt14DS9E90E630-49D9-4EA3-A71F-DC6FE5B446C4ClntMgmt14DS

    I did as recommended and deleted one record from the table (the one of DS -DominServer-) and restarted the SystemEngine. The collection job finished OK and after that I could see the EM and the DS/SS on the console.

     

    The problem I have now is that after I reboot the servers I see the SystemEngine stopped with the same behavior and details I descrived above only that now the manager_uuid are different (as expected)

     

    Every time I do this the SystemEngine on both serves logs the next error message on the file "SystemEngine.log":

     

    On the Enteprise:

    2016-12-08 11:22:52 Engine Starting...
    2016-12-08 11:22:53 cAmoDomain::InitializeNotification, Notification system succesfully initialized [LOCALHOST:SystemEngine]
    2016-12-08 11:25:56 Unable to find Manager in database
    2016-12-08 11:25:56 ReadEngineInfo Failed

    On the Domain:

    2016-12-08 11:25:09 Engine Starting...
    2016-12-08 11:25:10 cAmoDomain::InitializeNotification, Notification system succesfully initialized [LOCALHOST:SystemEngine]
    2016-12-08 11:28:18 Unable to find Manager in database
    2016-12-08 11:28:18 ReadEngineInfo Failed

    And then I go into DSM Explorer to check the status of the SystemEngine I see this where the System Engine is stopped:

     

    SystemEngine stopped

     

    I looked for more information on the KB but find none.

     

    Does anyone had experienced this behavior? or is that I'm doing something wrong?

     

    Thank you in advance for your comments and suggestions.



  • 2.  Re: Unable to Find Manager in Database
    Best Answer

    Broadcom Employee
    Posted Dec 08, 2016 04:56 PM

    Hi Rafael,

     

    I suspect that after the reboot, ITCM has generated again a new hostuuid for this machine and a duplicate row has been created again in table ca_manager.

     

    I advise you to create the string LockHostUUID with value 1 under following registry key on DOMAIN machine :

    HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\HostUUID
    or
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ComputerAssociates\HostUUID

     

    (see Knowledge Base Articles  (TEC1141502) for more information.)

    This will prevent the generation of a new hostuuid.

     

    Then do again the steps in TEC428833 in order to remove the duplicate row in table ca_manager

     

    Regards,

    Jean-Yves



  • 3.  Re: Unable to Find Manager in Database

    Broadcom Employee
    Posted Dec 08, 2016 05:53 PM

    If you are on version 14 that function has been added to configuration policy.  agent common

     

     

     

    Sent from my Verizon, Samsung Galaxy smartphone



  • 4.  Re: Unable to Find Manager in Database

    Posted Dec 09, 2016 03:19 PM

    Thank you all for your answers.

     

    I did as recommended by Jean-Yves and it is working fine.

     

    Best regards