CIC failed to connection MDB

[Legacy User]

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

[Gordon Lamothe]

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

[Legacy User]

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:

[Gordon Lamothe]

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

[Richard Little]

Hi 

are you still having issues with this?

thanks

Rich

[Legacy User]

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

 

 

[Richard Little]

can you attach new CIC logs please

[Legacy User]

hi i attach logs

Attachment(s)

CIC_Util.log.zip   5 KB 1 version

httpclient.log.zip   144 B 1 version

[Jean-Yves Guiblet]

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