Job with unique identifier 18742818 not defined to sub-system.

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

A job that was part of a process flow aborted in production. After deleting the process flow following messages are appearing. 

ErrorMsg: AwE-9999 Internal error 
Details: null
java.lang.RuntimeException: Job with unique identifier 12345678 is not defined to sub-system.
 at com.appworx.master.predtester.LocalPredTesterImpl.predecessorChanged(LocalPredTesterImpl.java:1342)
 at com.appworx.master.predtester.LocalPredTesterImpl.resumePredAnalysis(LocalPredTesterImpl.java:1744)
 at com.appworx.server.data.JobsData.z(JobsData.java:2448)
 at com.appworx.server.data.JobsData.w(JobsData.java:1943)
 at com.appworx.server.data.JobsData.A(JobsData.java:76)
 at com.appworx.server.data.JobsData$_E.doRun(JobsData.java:3533)
 at com.uc4.be.threading.AbstractWorker.run(AbstractWorker.java:367)
 at java.lang.Thread.run(Thread.java:748)

How to correct the problem?

Environment

Release: 9.3

Component: Applications Manager

Cause

Unique identifier errors are generally caused by a memory error that occurs when a job is manually deleted from the database end or from the command line.

Resolution

There are two tables that would cause the "Job with unique identifier 12345678 is not defined to sub-system" message to appear. In order to take of this problem following steps would be helpful:

Note that JobID 12345678 needs to be replaced with the actual JobID from the error.

1) check the history for JobID:

select count(*) from so_job_history where so_jobid='12345678';

2) check the Backlog for JobID 

select count(*) from so_job_queue where so_jobid='12345678';

3) If there is no record found from the first 2 sql, check to see if it is in the activity table

select count(*) from aw_job_queue_activity where so_jobid='12345678';

4) Depending on which table the record is found, run one or delete statements to remove the record from the table before running the commit:

delete from so_job_history where so_jobid='12345678';
delete from so_job_queue where so_jobid='12345678';
delete from aw_job_queue_activity where so_jobid='12345678';

commit;

5) If errors still appear shortly after the change, a restart to Applications Manager may be necessary to flush the JobID out of memory