My Oracle Support Banner

BATCH_ARCHIVE_PURGE_HIST_JOB ERROR Aborted in Job_State (Doc ID 2989872.1)

Last updated on JANUARY 24, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 to 22.1 [Release 22.1]
Information in this document applies to any platform.

Goal

BATCH_ARCHIVE_PURGE_HIST_JOB got aborted.

As per JOB_AUDIT_LOGS, Data Pump was long running and as a result, it aborted in job_state.

Batch log (Nov_08.log) showed:

Wed Nov 8 17:33:27 Program: batch_archive_purge_hist: PID=26217: Started by %s
Wed Nov 8 17:33:29 Program: batch_archive_purge_hist: PID=26217: Perform Archive Y. CHECK_ARCHIVE_DATES
Wed Nov 8 17:33:30 Program: batch_archive_purge_hist: PID=26217: Owning Schema retrieved. GET_OWNING_SCHEMA
Wed Nov 8 17:33:31 Program: batch_archive_purge_hist: PID=26217: Start of CREATE_DATA_PUMP. CREATE_DATA_PUMP
Wed Nov 8 17:37:14 Program: batch_archive_purge_hist: PID=26217: Aborted in job_state
Wed Nov 8 17:44:48 Program: batch_archive_purge_hist: PID=26514: Started by RMSBATCHUSER2
Wed Nov 8 17:44:50 Program: batch_archive_purge_hist: PID=26514: Perform Archive Y. CHECK_ARCHIVE_DATES
Wed Nov 8 17:44:51 Program: batch_archive_purge_hist: PID=26514: Owning Schema retrieved. GET_OWNING_SCHEMA
Wed Nov 8 17:44:52 Program: batch_archive_purge_hist: PID=26514: Start of CREATE_DATA_PUMP. CREATE_DATA_PUMP
Wed Nov 8 17:48:09 Program: batch_archive_purge_hist: PID=26514: Aborted in job_state

Batch error log (err.batch_archive_purge_hist.Nov_08) showed:

batch_archive_purge_hist~20231108173714~job_state~Data Pump Long Running.
batch_archive_purge_hist~20231108174809~job_state~Data Pump Long Running.




 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


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