Telemetry collection fails on MS SQL Server with 'Too many parameters'.
search cancel

Telemetry collection fails on MS SQL Server with 'Too many parameters'.

book

Article ID: 439064

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

In large Automic Automation environments using Microsoft SQL Server as the database backend, telemetry data collection may fail. The following symptoms are observed:

  • The LAH (License Audit History) table does not show recent telemetry usage data (e.g., aggregate_number_of_executions is missing).
  • The Automic Engine logs (WP/JWP) show the telemetry collection process starting, but failing during the database write operation.
  • The following error appears in the logs:

U00003590 UCUDB - DB error: 'S0001', 'The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.', '8003', 'com.microsoft.sqlserver.jdbc.SQLServerException'

Environment

  • Product: Automic Automation / Automation Engine
  • Versions: 24.x (Confirmed in 24.4.2.hf1)
  • Database: Microsoft SQL Server (All versions)
  • Scale: Large environments with thousands of agents or high daily execution volumes.

Cause

Microsoft SQL Server has a hardcoded architectural limit of 2,100 parameters per database request.

When the Automic Engine aggregates telemetry data—especially in environments with a massive number of agents (e.g., >4,000)—it constructs a single INSERT or SELECT statement for the LAH table that includes parameters for each metric or component. If the total number of bind parameters in this generated SQL statement exceeds 2,100, the SQL Server JDBC driver throws a SQLServerException, and the entire transaction is rolled back.

Resolution

Update to a fixed version listed below or a newer version if available.

Automic Automation Engine 24.4.3 - Available

Public Title:
Improved the performance of telemetry data collection

Public Description:
Improved the performance of telemetry data collection. The system now uses more efficient database queries to calculate execution counts, significantly reducing processing time and database load.

Additional Information

Article title: How to register to Broadcom Software Product updates and Critical Alerts

https://knowledge.broadcom.com/external/article?articleId=133819

Defect ID: DE177150

Powered by Wolken Software