Automic Workload Automation

 View Only

AE 24.4.1 - Job Workflow cancelled as exceeding schedule max runtime when get_var on a SQL Vara is used

  • 1.  AE 24.4.1 - Job Workflow cancelled as exceeding schedule max runtime when get_var on a SQL Vara is used

    Posted 2 days ago

    Hello

    We've found a strange issue from Automic v24.4.1 where a workflow has a bit of code in process tab to retrieve a value from a SQL Vara. The workflow has a maximum runtime associated with it and will cancel if it still running before midnight.  Running the workflow outside of schedule and it completes normally. 

    Triggering the workflow from the job schedule and it cancels 10 seconds later with the workflow exceeding the maximum runtime.  

    Retrieving a value from a SQLI or normal VARA works fine, it's only when it's a SQL Vara. I can reproduce this issue with new objects and different database connections, the code in the workflow process tab works fine.  It's a bit of an edge case so I wondered if anyone else had run into it. 

    Removing the process code for get_var on the SQL vara and it works fine.  This is also working without issue in V24.3



    -------------------------------------------