ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

cic loops with error "Failed to acquire MDB connection for domain"

book

Article ID: 227967

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

If there is a problem with cicuser (account locked, wrong password ...) or with database connection, execution of CIC could enter in a infinite loop with following error in C:\Program Files (x86)\CA\SC\CIC\logs\CIC*.log

2021-11-09 18:41:52,474 [CCMain] ERROR [com.ca.sccc.dbm.CCDBManager] - Failed to acquire MDB connection for domain 'JY-2019-145'
2021-11-09 18:41:52,474 [CCMain] ERROR [com.ca.sccc.CCException] - Exception caught.  Stack Trace:
2021-11-09 18:41:52,474 [CCMain] ERROR [com.ca.sccc.CCException] - com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'cicuser'. ClientConnectionId:a5785f98-138a-4059-b742-b8280ca9467c
...
2021-11-09 18:42:07,536 [CCMain] ERROR [com.ca.sccc.dbm.CCDBManager] - Failed to acquire MDB connection for domain 'JY-2019-145'
2021-11-09 18:42:07,536 [CCMain] ERROR [com.ca.sccc.CCException] - Exception caught.  Stack Trace:
2021-11-09 18:42:07,536 [CCMain] ERROR [com.ca.sccc.CCException] - com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'cicuser'. ClientConnectionId:8079b24c-63cc-4fce-a9d8-a727a13194f0
...
2021-11-09 18:42:22,583 [CCMain] ERROR [com.ca.sccc.dbm.CCDBManager] - Failed to acquire MDB connection for domain 'JY-2019-145'
2021-11-09 18:42:22,583 [CCMain] ERROR [com.ca.sccc.CCException] - Exception caught.  Stack Trace:
2021-11-09 18:42:22,583 [CCMain] ERROR [com.ca.sccc.CCException] - com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'cicuser'. ClientConnectionId:d562eeea-8eb5-44d1-ac3c-32e1edadae6b
...
...
2021-11-09 18:51:40,718 [CCMain] ERROR [com.ca.sccc.dbm.CCDBManager] - Failed to acquire MDB connection for domain 'JY-2019-145'
2021-11-09 18:51:40,718 [CCMain] ERROR [com.ca.sccc.CCException] - Exception caught.  Stack Trace:
2021-11-09 18:51:40,718 [CCMain] ERROR [com.ca.sccc.CCException] - com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'cicuser'. ClientConnectionId:e6410ba3-20ae-4880-b68b-4e7e85b1f38c

How to avoid the infinite loop and stop automatically after some connection retries ?

Environment

Client Automation 14.0 SP2, 14.0 SP3 and 14.5

Resolution

Create a CA Broadcom case to request the fix T55V191
 
This fix is indicated for 14.0 SP2 but it could be installed on CIC 14.0 SP3 and 14.5
 
This fix introduces 2 new parameters in config.xml for <domain> section :
<connectRetries>3</connectRetries>
<connectRetryInterval>10000</connectRetryInterval>
 
 
Above example indicates 3 connection attempts with a delay of 10000 ms between attempt.
 
 
Edit file C:\Program Files (x86)\CA\SC\CIC\conf\config.xml and add these 2 lines in <domain> section :
 
<domain>
<domainName>JY-2019-145</domainName>
...
<connectRetries>3</connectRetries>
<connectRetryInterval>10000</connectRetryInterval>
</domain>

With the fix installed and settings set in config.xml, cic*.log contains :
2021-11-09 19:03:14,947 [CCMain] ERROR [com.ca.sccc.dbm.CCDBManager] - Failed to acquire MDB connection for domain 'JY-2019-145'
2021-11-09 19:03:24,980 [CCMain] ERROR [com.ca.sccc.dbm.CCDBManager] - Failed to acquire MDB connection for domain 'JY-2019-145'
2021-11-09 19:03:35,025 [CCMain] ERROR [com.ca.sccc.dbm.CCDBManager] - Failed to acquire MDB connection for domain 'JY-2019-145'
2021-11-09 19:03:45,026 [CCMain] ERROR [com.ca.sccc.dbm.CCDBManager] - MDB Session acquisition failed for domain 'JY-2019-145', retries expired