search cancel

WF variable does not resolve when going over period turnaround

book

Article ID: 253501

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

1) Create a SQLI variable with the following (called {VARA.SQLI.TEST_DATE}) :
Oracle: select to_char(ah_timestamp1-7/24,'YYYYMMDD') from uc4.eh inner join uc4.ah on eh_ah_idnr = ah_idnr where eh_ah_idnr = ?
with ? being &$RUNID#
MSSQL: select ah_timestamp1 from eh inner join ah on eh_ah_idnr = ah_idnr where eh_ah_idnr = ?
with ? being &$RUNID#

2) Create a promptset (PRMPT.TEST_DATE) with a text field called &test_date# that has data reference of VARA.SQLI.TEST_DATE and with the default value of {VARA.SQLI.TEST_DATE}
3) Create a UNIX job called JOBS.UNIX.SLEEP.3600 with Generate at Runtime and the following in Process tab:
 &test_date#
sleep 3600
4) Create a workflow called JOBP.PASS.TEST_DATE with Generate at runtime
5) Be sure the workflow has a max parallel of 1 else wait
6) Add the Promptset PRMPT.TEST_DATE to the Workflow
7) Add the job, JOBS.UNIX.SLEEP.3600, to the workflow
8) Create a schedule with the WF, JOBP.PASS.TEST_DATE set to run at 11:45 AM, 11:55 AM, 11:45 PM, and 11:55 PM
9) Run the schedule and wait for it to go through a full run where all four of the scheduled times run

Expected behavior:
11:45 AM WF and JOB should run just fine and job should print out the value for &test_date#
11:55 AM WF and JOB should wait until 12:45 PM for the first parallel run to finish and then run just fine and job should print out the value for &test_date#
11:45 PM WF and JOB should run just fine and print out the value for &test_date#
11:55 PM WF and JOB should wait until 12:45 AM the next day for the first parallel run to finish and then run just fine and job should print out the value for &test_date#

Actual behavior:
11:45 AM runs as expected described above
11:55 AM runs as expected described above
11:45 PM runs as expected described above
11:55 PM waits until 12:45 AM and then WF runs; job ends with FAULT_OTHER - Start Impossible. Other error. Looking at last message we see:

U00021719 Syntax error in object 'JOBS.UNIX.33185436', line '00001'. 'U01001308 Variable 'test_date#' has not yet been defined.'.

Environment

Release : 12.3, 21.0

Resolution

Will be fixed with 21.0.5