MERCHAPI_CACHE_PURGE_JOB FAILURE - PURGE_CACHE Process Does Not Existing For MERCHAPI_RUA API
(Doc ID 3053909.1)
Last updated on OCTOBER 17, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.1 to 24.1 [Release 24.1]Information in this document applies to any platform.
Symptoms
Problem Description:
The MERCHAPI_CACHE_PURGE_JOB shows successful completion in POM but the log file shows errors.
2024-09-09T02:38:31,443 [Thread-2492] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: b8dwrap~20240909023831~EXEC_SQL~
2024-09-09T02:38:31,455 [Thread-2492] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Error ORA-06550: line 4, column 36:
2024-09-09T02:38:31,455 [Thread-2492] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: PLS-00302: component 'PURGE_CACHE' must be declared returned by program unit B8D
2024-09-09T02:38:31,455 [Thread-2492] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: _MERCHAPI_CACHE_PURGE_SQL.MERCHAPI_CACHE_PURGE.
2024-09-09T02:38:31,456 [Thread-2492] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Mon Sep 9 02:38:31 Program: b8dwrap: PID=MERCHAPI_CACHE_PURGE_JOB: Aborted in EXEC_SQL
2024-09-09T02:38:32,332 [Thread-2492] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: b8dwrap~20240909023832~PROCESS_JOB~Function call B8D_MERCHAPI_CACHE_PURGE_SQL.MERCHAPI_CACHE_PURGE failed.
2024-09-09T02:38:32,338 [Thread-2492] INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Mon Sep 9 02:38:32 Program: b8dwrap: PID=MERCHAPI_CACHE_PURGE_JOB: Aborted in PROCESS_JOB
Steps to Recreate:
1. Run the MERCHAPI_CACHE_PURGE_JOB.
2. Review the logs for the errors noted.
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 |