search cancel

Setting Post Condition to restart task, with entries in Variables and Prompts field of the task, task remains in Generating status


Article ID: 84843


Updated On:


CA Automic Workload Automation - Automation Engine


Error Message :
U00003590 UCUDB - DB error: 'SQLBindParameter', 'ERROR ', 'HY104', 'Invalid precision value'

When setting a Post Condition to restart a task that has entries in the Variables and Prompts field of the task the task will remain in a status of Generating and the above error message will be displayed.

This occurs on Automation Engine systems running with a SQL Server database.


Cause type:
Root Cause: Jobs will get stuck in a Generating status and throw a 'SQLBindParameter' error. Tthe SQL Server ODBC driver does not support bind parameters with null values and the jobs will get stuck in a Generating status.


OS Version: N/A


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

Fix Status: Released

Fix Version(s):
Automation Engine 12.1.1 - Available
Automation Engine 12.0.4 - Available
Automation Engine 11.2.6 - Available

Additional Information

Workaround :
Remove the Variables and Prompts field value.