The Background Process Job Does not Purge Data from Job Tables for Jobs in 'DEL' Status (Doc ID 2159007.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

Created Background Processor Scheduled job to move 'COM' jobs to 'DEL' (n_cst_clear_completed_job or job type id 1011) and then to purge 'DEL' jobs (n_cst_purge_jobqueue or job type id 99).

The n_cst_clear_completed_job is successful and moves the 'COM' to 'DEL' and the n_cst_purge_jobqueue job is successful but no 'DEL' job data purged.

There are no errors in the BP_notification.log, jmaster.log or worker.log log files.

Workaround:
    <Bug.13534135> - data cleanup; deliver background processor jobs purge scripts <patch.13537252> - job_purge_sql



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms