CA Client Automation

Expand all | Collapse all

CIC failed to connection MDB

Jump to Best Answer
  • 1.  CIC failed to connection MDB

    Posted 03-13-2017 03:50 PM

    hi

     

    i tried to configure my CIC on remote database and instance named but say mensage 

     

    MDB Session acquisition failed, waiting for DBMS...

    MDB Session acquisition failed for domain 'ITCAM', retries expired

    Failed to initialize/test MDB connection manager for domain 'ITCAM'

     

    my itcm manager name is ITCAM

    my database server is ITDB on this server have instance named called "ITCM" and lisening port 2783

     

    any idea



  • 2.  Re: CIC failed to connection MDB

    Posted 03-13-2017 04:20 PM

    Please check you config.xml file in the ca\sc\cic\conf folder

     

    Yours should look similar to this: (mdb name might be FQDN)

     

    <MDB_properties_by_domain>

    <domain>

    <domainName>itdb</domainName>

    <mdbConn>jdbc:sqlserver://itdb:2783</mdbConn>

    <mdbName>mdb</mdbName>

     

    <mdbPassword>aW2yAr/ZENaBvfAMshjYFg==</mdbPassword>

    If your mdb password looks like this ??

     

    You should be able to login into SQL as:

     

    cicuser

    CAC0nt3nt!4CIC

     

    If you still have issues, attach logs and config.xml



  • 3.  Re: CIC failed to connection MDB

    Posted 03-13-2017 04:22 PM

    when configure Logs in debug mode  show this

     

    2017-03-13 15:46:08,383 [CCMain] INFO [com.ca.sccc.CCMain] - Initializing CIC Config through MDB
    2017-03-13 15:46:08,445 [CCMain] INFO [com.ca.sccc.dbm.CCDBManager] - Initializing MDB connection 'jdbc:sqlserver://ITDB /ITCM:2783' for domain 'ITCAM'. User name: cicuser
    2017-03-13 15:46:08,445 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - Jdbc class: com.microsoft.sqlserver.jdbc.SQLServerDriver
    2017-03-13 15:46:08,445 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - Validation query: null
    2017-03-13 15:46:08,445 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - Max sessions: 10
    2017-03-13 15:46:08,445 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - Max idle sesisons: -1
    2017-03-13 15:46:08,445 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - Evict Idle Time: 600000
    2017-03-13 15:46:08,445 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - Evict Interval: 60000
    2017-03-13 15:46:08,695 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBReturnActiveHostDetails] - Connecting to : jdbc:sqlserver://;serverName=ITDB /ITCM:2783
    2017-03-13 15:46:09,055 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - MDB connection factory string: jdbc:sqlserver://BCITILDB/ITCM:2783;DatabaseName=mdb;SelectMethod=direct;lastUpdateCount=true;ProgramName=CIC
    2017-03-13 15:46:09,055 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - creating the poolable MDB connection factory for domain 'ITCAM'
    2017-03-13 15:46:09,055 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - creating the MDB pooling MDB driver for domain 'ITCAM'
    2017-03-13 15:46:09,055 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - MDB connection pool established for domain 'ITCAM'
    2017-03-13 15:46:09,055 [CCMain] DEBUG [com.ca.sccc.dbm.CCDBManager] - Testing MDB connection for domain 'ITCAM' ...
    2017-03-13 15:46:09,086 [CCMain] ERROR [com.ca.sccc.dbm.CCDBManager] - Failed to acquire MDB connection for domain 'ITCAM'
    2017-03-13 15:46:09,086 [CCMain] ERROR [com.ca.sccc.CCException] - Exception caught. Stack Trace:



  • 4.  Re: CIC failed to connection MDB

    Posted 03-13-2017 04:42 PM

    Can you upload the config.xml file from CA\SC\CIC\conf ???  or post the top half ....



  • 5.  Re: CIC failed to connection MDB

    Posted 03-15-2017 10:08 AM

    Hi 

    are you still having issues with this?

    thanks

    Rich



  • 6.  Re: CIC failed to connection MDB

    Posted 03-15-2017 11:10 AM

    yes i correct the error in the conexion on mdb, the error solved when change value for database in FQDN 

     

    -<MDB_properties_by_domain>

       -<domain>

             <domainName>ITDB.domanin</domainName>

             <mdbConn>jdbc:sqlserver://ITDB//ITCM:2783</mdbConn>

             <mdbName>mdb</mdbName>

             <mdbPassword>aW2yAr/ZENaBvfAMshjYFg==</mdbPassword>

             <mdbUser>cicuser</mdbUser>

             <className>com.microsoft.sqlserver.jdbc.SQLServerDriver</className>

             <validationQuery/>

             <maxIdleSessions>-1</maxIdleSessions>

             <maxPoolSessions>10</maxPoolSessions>

             <evictIdleTime>600000</evictIdleTime>

             <evictInterval>60000</evictInterval>

       </domain>

    </MDB_properties_by_domain>

     

    when run command Util.bat -m  the result is OK but when run  Util.bat -c show this "Completed due to Error (return code: 8)"

    check browser url http://contentupdate.ca.com:5250/igsponsor and resolve this result is OK.

     

    but the CIC is not OK

     

     



  • 7.  Re: CIC failed to connection MDB

    Posted 03-15-2017 12:29 PM

    can you attach new CIC logs please



  • 8.  Re: CIC failed to connection MDB

    Posted 03-15-2017 01:18 PM

    hi i attach logs

    Attachment(s)

    zip
    CIC_Util.log.zip   5K 1 version
    zip
    httpclient.log.zip   144B 1 version


  • 9.  Re: CIC failed to connection MDB
    Best Answer

    Posted 03-15-2017 06:57 PM

    Hello Jonathan,

     

    I could see this in the log :

     

    2017-03-15 10:41:58,254 [pool-1-thread-1] ERROR [com.ca.sccc.CCException] - java.net.UnknownHostException: contentupdate.ca.com: contentupdate.ca.com

     

    It seems the machine could not resolve the name contentupdate.ca.com in ipaddress.

     

    You could verify this with :

     

    nslookup contentupdate.ca.com

     

    As solution you could add this line in file c:\windows\system32\drivers\etc\hosts

     

    141.202.248.110 contentupdate.ca.com

     

    You could also check the connectivity with contentupdate.ca.com by following instructions in this page :

     

    https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec405649.html 

     

    Thanks.

    Regards,

    Jean-Yves