search cancel

Error in Autosys Upgrade Assistant when loading jobs in PROD instance. No clause exists with an index of 11


Article ID: 240108


Updated On:


CA Workload Automation AE


We are using AUA (AutoSys Upgrade Assistant) to migrate PROD jobs from 4.5.1 to 11.3.6 SP8.

We see the following message when loading the jobs from the source 4.5.1 DB after the package is created.

Caused by: java.lang.IllegalArgumentException: No clause exists with an index of 11
 at Source)
 at Source)



Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)


The source autosys database had orphaned rows in the job_cond table. 

Rows which referenced a joid that did not exist in the job table. 

Remove the orphan rows to resolve the error.