Client Automation - sdmgr plugins stopped

Products

• CA Client Automation - IT Client Manager
• CA Client Automation - Software Delivery

Issue/Introduction

Sometimes some sdmgr plugins (RM, NM, TM, IM and PM) are stopped.

In TRC_USD_*MAN*.log (like TRC_USD_INSTMAN*.log) following errors could appear before stop :

 

evalSQLInfo sqlstate: 08S01 native error: 121 0x79
evalSQLInfo description: Communication link failure source: Microsoft SQL Server Native Client 11.0


evalSQLInfo sqlstate: 08S01 native error: 121 0x79
evalSQLInfo description: TCP Provider: The semaphore timeout period has expired. 
 source: Microsoft SQL Server Native Client 11.0

evalSQLInfo class: 16 state: 1 server: 
Error Message: ADO Version 6.3 - COM Error: ErrorCode:-2147467259,WordErrorCode:0, Unspecified error, TCP Provider: The semaphore timeout period has expired.

evalSQLInfo sqlstate: 08S01 native error: 0 0x0
Error Message: ADO Version 6.3 - COM Error: ErrorCode:-2147467259,WordErrorCode:0, Unspecified error, Communication link failure, Microsoft SQL Server Native Client 11.0, (null)

Cause

This problem is caused by a communication problem between ITCM Domain Manager and Microsoft SQL Server.

This could be caused by a network problem or a SQL Server problem.

 

Environment

Client Automation - All version

Resolution

The best solution is to find the root cause and resolve the network or SQL Server problem.

 

But as workaround a script could be used to automatically start the sdmgr plugins if they are stopped :

This script check if a sdmgr plugin is stopped and start it if it is stopped.

 

This script generates a log under C:\Program Files (x86)\CA\DSM\logs\restart_sdmgr.log

 
 
1- Copy the file restart_sdmgr.bat (see attached file) into C:\Program Files (x86)\CA\DSM\bin on Domain Manager
 
2- Execute this command to schedule execution of this script every day at 21:00 :

schtasks.exe /create /RU "NT AUTHORITY\SYSTEM" /TN "Restart SDMGR plugins" /SC DAILY /TR "C:\Program Files (x86)\CA\DSM\Bin\restart_sdmgr.bat" /ST "21:00"

 

 

Every day at 21:00, if sdmgr_tm, sdmgr_rm, sdmgr_pm, sdmgr_nm and/or sdmgr_im are stopped, the script start it automatically.