This issue applies to environments which have been upgraded to 4.3.0 hotfix (HF) 1 directly, from version 4.2.0 or older. This issue will not occur if the environment is upgraded to 4.3.0 first and then 4.3.0 HF 1 is applied.

Symptoms:
Following WARN messages are seen in the logs -

[PVM:Background Processor-1] [WARN ] com.tibco.pvm.system.PvmSystem - IdbBackgroundJobDaoImpl.startJob(DB_BPEL_MODULE_CLEANUP): job not found in database [PVM:Background Processor-2] [WARN ] com.tibco.pvm.system.PvmSystem - IdbBackgroundJobDaoImpl.startJob(DB_INMEMORY_INSTANCE_RECOVERY): job not found in database [PVM:Background Processor-3] [WARN ] com.tibco.pvm.system.PvmSystem - IdbBackgroundJobDaoImpl.startJob(DB_BPEL_PENDING_MSG): job not found in database

Below query will return 0 rows - select * from PVM_BG_JOBS;

Cause:
PVM_BG_JOBS table is empty due to a defect in the upgrade scripts.

After an upgrade to TIBCO ActiveMatrix BPM 4.3.0 hotfix 1, the PVM_BG_JOBS table may not contain any rows. This article explains a workaround which should be performed post-upgrade.

OS: All supported operating systems Database type: Oracle

This defect in the upgrade scripts is fixed in BPME v4.3.1.

Below workaround can be used if the issue is observed -

1. Stop all BPM Nodes

2. Execute the following to populate PVM_BG_JOBS -

=============
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (1, 'DB_BPEL_MODULE_CLEANUP');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (2, 'DB_INMEMORY_INSTANCE_RECOVERY');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (3, 'DB_PURGED_PROCESS');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (4, 'DB_ENGINE_EVENT_QUEUE_CLEANUP');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (5, 'DB_REQUEST_QUEUE_CLEANUP');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (6, 'DB_WORK_ITEM_CLEANUP');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (7, 'DB_BPEL_PENDING_MSG');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (8, 'DB_BPEL_UNCLAIMED_MSG');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (9, 'DB_EXT_EXPIRED_SIGNAL');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (10, 'DB_EXT_PENDING_SIGNAL');
INSERT INTO PVM_BG_JOBS (JOB_ID, JOB_NAME) VALUES (11, 'DB_QUERY_PAGING_CLEANUP');
COMMIT;
=============

3. Start all BPM Nodes

Internal defect id - WRM-11740