Customer Screening/Watchlist Management Jobs Are Failing (Doc ID 2907325.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Symptoms

Steps to reproduce the issue:
Step1: Run watchlist management job "Download,Prepare,Filter and Export All lists"

Actual Behavior:
Getting error and job fails

Expected Behavior:
Job to be completed successfully

Issue Encountered:
ORA-06512: at line 1 (Code: 202,608)
at com.datanomic.director.dataupload.DataUploader.endUpload(DataUploader.java:171)
at com.datanomic.director.dataupload.Upload.endUpload(Upload.java:62)
at com.datanomic.director.snapshot.SnapshotExecutor.uploadData(SnapshotExecutor.java:694)
at com.datanomic.director.snapshot.SnapshotExecutor.executeSnapshot(SnapshotExecutor.java:200)
at com.datanomic.director.snapshot.SnapshotExecutor.runTask(SnapshotExecutor.java:802)
at com.datanomic.director.missionmanager.executor.ThreadResources.ThreadConstrainedWorkUnit$TaskWrapper.run(ThreadConstrainedWorkUnit.java:424)
at java.lang.Thread.run(Thread.java:748)

SEVERE: 20-Oct-2022 02:36:08: [EDQ-09019] Error during snapshot execution: Indexing for dn_r327 failed: ORA-20011: Approximate NDV failed: ORA-27103: internal error
SVR4 Error: 11: Resource temporarily unavailable

Changes

 NA

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.