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

Products

• CA Workload Automation AE

Issue/Introduction

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 com.ca.aua.packages.condition.ConditionBuilder.addClause(Unknown Source)
 at com.ca.aua.databases.newDatabase.databases.Aua451Database.getConditionTableMap(Unknown Source)

 

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

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.