Connection to server closed: Connection timed-out or server stopped! (or, less probable, network problem) SDM000021

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager
• CA Server Automation

Issue/Introduction

Description:

Problem

• When trying to open the DSM Explorer the above error is received
  
• Clicking OK loads the Explorer
  
• Trying to use any Software Delivery function returns same error
  
• Task Manager does not show any unusual CPU or RAM activity
  
• CAMPING localhost works fine
  
• CAMSTAT shows that application SD_IM is disconnected with a queue building up

Environment

• CA Client Automation r12.5
  
• CA IT Client Manager r12.5
  
• CA Software Delivery r12.5
  
• SQL 2008

Cause

• Review of the Installation Manager log revealed the SQL transaction log was full

ADO Version 6.1 - ExecuteCommandPointer-COM Error: ErrorCode:-2147217900,WordErrorCode:3092, IDispatch error #3092, The transaction log for database 'mdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases, Microsoft SQL Server Native Client 10.0, (null)

Solution:

• Truncate the SQL transaction log

Environment

Release: UASIT.99000-12.5-Asset Intelligence
Component: