Description:

The following error occurs after migration from TIBCO BusinessWorks ProcessMonitor(BWPM) 3.0.1 to 3.02 HF-01:

NJAMS_JOB_DELETE_DATA and NJAMS_JOB_CHECK_TRACE_SETTINGS jobs does not appear in the main job list.

The stack trace is as follows:

2015-08-11 00:00:02,020 INFO [NJAMS_Worker-2] org.quartz.core.JobRunShell: Job NJAMS.NJAMS_JOB_DATA_MANAGEMENT threw a JobExecutionException:
org.quartz.JobExecutionException: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'PROC_DATA_MANAGEMENT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
[See nested exception: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'PROC_DATA_MANAGEMENT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



Symptoms:

The following error is seen:

Couldn't store trigger 'NJAMS.NJAMS_JOB_DELETE_DATA' for 'NJAMS.NJAMS_JOB_DELETE_DATA' job:com.faizsiegeln.njams.jobs.JobDeleteData
org.quartz.JobPersistenceException: Couldn't store trigger 'NJAMS.NJAMS_JOB_DELETE_DATA' for 'NJAMS.NJAMS_JOB_DELETE_DATA' job:com.faizsiegeln.njams.jobs.JobDeleteData [See nested exception: java.lang.ClassNotFoundException: com.faizsiegeln.njams.jobs.JobDeleteData

The following stack trace appears:

2015-08-11 00:00:02,020 INFO [NJAMS_Worker-2] org.quartz.core.JobRunShell: Job NJAMS.NJAMS_JOB_DATA_MANAGEMENT threw a JobExecutionException:
org.quartz.JobExecutionException: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'PROC_DATA_MANAGEMENT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
[See nested exception: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'PROC_DATA_MANAGEMENT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored






Cause:
In TIBCO BusinessWorks ProcessMonitor(BWPM) 3.0.2, the procedure 'PROC_DATA_MANAGEMENT' no longer exists. The BWPM 3.0.2 Server has two separate cluster wide jobs NJAMS_JOB_CREATE_PARTITIONS and NJAMS_JOB_DELETE_DATA. Both jobs replace the previous job NJAMS_JOB_DATA_MANAGEMENT.

Error 'NJAMS_JOB_DELETE_DATA and NJAMS_JOB_CHECK_TRACE_SETTINGS jobs does not appear in the main job list' .

Execute following select statement to check whether job 'NJAMS_JOB_DATA_MANAGEMENT’ exist in the database.

1). Select * FROM NJAMS_SCHEMA.NJAMS_T_Q_TRIGGERS WHEREJOB_NAME=‘NJAMS_JOB_DATA_MANAGEMENT';

2). Select * FROM NJAMS_SCHEMA.NJAMS_T_Q_JOB_DETAILS WHEREJOB_NAME=‘NJAMS_JOB_DATA_MANAGEMENT’;


If the above query returns data then it indicates that the migration to TIBCO BusinessWorks ProcessMonitor(BWPM) server version 3.0.2.1 was not correctly executed. Execute the following delete statements manually:

1). DELETE FROM NJAMS_SCHEMA.NJAMS_T_Q_SIMPROP_TRIGGERS WHERE TRIGGER_NAME IN (SELECT TRIGGER_NAME FROM
NJAMS_SCHEMA.NJAMS_T_Q_TRIGGERS WHERE JOB_NAME='NJAMS_JOB_DATA_MANAGEMENT’);

2). DELETE FROM NJAMS_SCHEMA.NJAMS_T_Q_TRIGGERS WHERE JOB_NAME=‘NJAMS_JOB_DATA_MANAGEMENT';

3). DELETE FROM NJAMS_SCHEMA.NJAMS_T_Q_JOB_DETAILS WHERE JOB_NAME=‘NJAMS_JOB_DATA_MANAGEMENT’;