My Oracle Support Banner

BATCH_ARCHIVE_PURGE_HIST_JOB Failing After V21 Upgrade. (Doc ID 2912849.1)

Last updated on DECEMBER 05, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

BATCH_ARCHIVE_PURGE_HIST_JOB failed with below error :

EXT_PROG_SYS_OUT:@RMSAlias: batch_archive_purge_hist~20220421143739~CHECK_ARCHIVE_DATES~Errors encountered in Checking Archive Dates. See error file

"2022-04-21T14:37:38,176 [Thread-75] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Thu Apr 21 14:37:38 Program: batch_archive_purge_hist: PID=7864: Started by default user
2022-04-21T14:37:38,616 [Thread-75] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: batch_archive_purge_hist~20220421143738~EXEC_SQL~ERROR:
2022-04-21T14:37:38,616 [Thread-75] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: ORA-12154: TNS:could not resolve the connect identifier specified
2022-04-21T14:37:38,616 [Thread-75] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias:
2022-04-21T14:37:38,616 [Thread-75] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias:
2022-04-21T14:37:38,616 [Thread-75] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: SP2-0306: Invalid option."

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!

In this Document
Symptoms
Cause
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.