AAI DB Maintenance fails with "The incoming request has too many parameters" (SQL Error 8003)

Products

• Automation Analytics & Intelligence

Issue/Introduction

During AAI database maintenance tasks, the AAI process fails, and the logs report an SqlExceptionHelper error indicating that the request has too many parameters.

2026-07-29 01:09:19,218 ERROR [SqlExceptionHelper] The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
2026-07-29 01:11:19,152 WARN [SqlExceptionHelper] SQL Error: 8003, SQLState: S0001

 

Environment

Product: Automic Automation Intelligence (AAI)
Component: Database Maintenance
OS: Microsoft Windows / Linux
Database: Microsoft SQL Serve

Cause

Microsoft SQL Server has a hardcoded architectural limit of 2,100 parameters per database request. In some environments, when the AAI maintenance task attempts to purge older job run data, the generated SQL statement exceeds this parameter limit, causing the transaction to roll back and the maintenance process to fail.

Resolution

This issue is addressed in AAI version 24.4.1 and later.

To resolve this issue:

1. Verify your current AAI version.
2. If you are running a version prior to 24.4.1, plan and execute an upgrade to the latest supported release of AAI (e.g., 24.4.2 or later).
3. The upgrade includes code optimizations that effectively handle the database purge logic without exceeding the MS SQL Server parameter limit.