Hello,
We recently upgraded and migrated our ancient AM8 to AM9, and amazing mostly everything works after making config and environment changes.
However, we've noticed that we're getting launch errors on jobs that use any dynamic subvars, that in turn reference another dynamic subvar.
For example, say I have a job with 2 prompts:
1. FISCAL_Q
2. LAST_DAY_OF_FISCAL_1
Under AM8, I could have used:
1. Q1
2. {#QUERY_FOR_LAST_DAY)
In this case,
#QUERY_FOR_LAST_DAY would be:
SELECT MAX(LAST_DAY) FROM FISCAL_Q
WHERE FISCAL_C = {#GET_PROMPT_1);
#GET_PROMPT_1:
SELECT SO_ARG from SO_JOB_ARGS
WHERE so_job_args.so_jobid = trunc('{jobid}')
and SO_ARG_NO = 1
They're still valid in the old AM8, and the queries work individually. But when used together, I always get
ErrorMsg: AwE-5117 Job launch error
Thanks for any suggestions!