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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.

Environment

OS Version: N/A

Cause

Cause type:
Defect
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.

Resolution

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.