DB Agent running against SQL Server | U00003620 Routine 'UCEX_R' | Forced Traces

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

The Database Agent seems to create trace files at random.  This happens with a database agent connecting to SQL Server.  The logs show the following:

20240219/003101.461 - U00003620 Routine 'UCEX_R' forces trace because of error.
20240219/003101.461 - U02000048 TRACE file opened with flags '0000000000000001', max.trace: '9', memory trace: '0', search type: 'S', search string: ''.
20240219/003101.508 - U00003449 Output to the TRACE file is finished.

And the trace shows:

20240221/093624.204 - 1574   ----------------------- Stack Trace -----------------------
20240221/093624.204 - 1574   com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

Environment

Database agent is on a lower service pack than 21.0.6

Cause

This is caused by a defect with the Database Agent

Resolution

This is fixed with the 21.0.6 Database agent.