My Oracle Support Banner

Delay in Batch Jobs Completion (Doc ID 2882872.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Enterprise Data Quality - Version 12.2.1.4.2 and later
Information in this document applies to any platform.

Symptoms

Initially, after the upgrade from Oracle Enterprise Data Quality (EDQ) 12.2.1.3 to 12.2.1.4.2 batch jobs ran fine (around 5 hours each), but now seeing a delay in Batch jobs completion taking around 9 to 10 hours.  In addition, servers need to be restarted on a regular basis (daily), as jobs appear to be getting "hung" at some point.


The following are run nightly:

  1. Customer Data Preparation
  2. Download Watchlist data
  3. Analyze customer Data Quality
  4. Batch Screening
  5. real-time Screening

    The process "Analyze customer Data Quality" - should complete in 20 mins, but now taking 2 and half hours.

"Batch Screening" job took 9 and half hours.

The following errors are seen throughout the diagnostic log:

 

Changes

 Upgrade from 12.2.1.3 to 12.2.1.4.2

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.