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 |