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: 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.
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
Workaround : Remove the Variables and Prompts field value.