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

Document ID : KB000084843
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.