My Oracle Support Banner

ZIP_FILE_WAIT_JOB Fails Even Though RI_RMS_DATA.zip Is Present (Doc ID 2970976.1)

Last updated on JANUARY 18, 2024

Applies to:

Oracle Retail Science Platform Cloud Service - Version 23.1 and later
Oracle Retail AI Foundation Cloud Service - Version 23.2 and later
Information in this document applies to any platform.

Goal

Why is ZIP_FILE_WAIT_JOB failing when RI_RMS_DATA.zip is present in ris/incoming? The log may say this:

INFO AbstractShellJobExecutor - <JLB> EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 12-01-2024_22:08:38 SCRIPT ZipFileWait.ksh FAILED, NO ACTIVE ZIPS IN DATABASE FOR PROCESSING. EXITING FROM ZipFileWait.ksh ### <JLE>

Or the logs may confirm that it is present, yet it still fails and loops. This log says password will expire in 30 days.

INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: Mon Aug 28 18:08:27 Program: ri_object_store_wrapper.ksh: PID=87823: File scan status fetched successfully. File Scan Status: Failed. Read Allowed: true. Object exceeds FTS max size. objStrGetStatus
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023_18:08:27 SLEEPING FOR 30 SECONDS
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023_18:08:57 CHECKING FOR EXPECTED ZIPS IN object store
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh:
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 MISSING:ERROR:
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 MISSING:ORA-28002:
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 MISSING:the
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 MISSING:password
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 MISSING:will
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 MISSING:expire
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 MISSING:within
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 MISSING:30
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 MISSING:days
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 PRESENT:RI_RMS_DATA.zip
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: ### 28-08-2023 Mon Aug 28 18:08:59 Program: ri_object_store_wrapper.ksh: PID=87988: Request type is FILESTATUS. Main
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: Mon Aug 28 18:08:59 Program: ri_object_store_wrapper.ksh: PID=87988: Object Store Prefix is ris/incoming. Main
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: Mon Aug 28 18:08:59 Program: ri_object_store_wrapper.ksh: PID=87988: Search pattern is RI_RMS_DATA.zip. Main
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: Mon Aug 28 18:09:00 Program: ri_object_store_wrapper.ksh: PID=87988: Successfully retrieved credentials for object storage. checkCredentials
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: Mon Aug 28 18:09:01 Program: ri_object_store_wrapper.ksh: PID=87988: Waiting for file to be available. Current Scan Status is Failed . 1/5 retry. Sleeping for 30 seconds. objStrGetStatus
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: Mon Aug 28 18:09:01 Program: ri_object_store_wrapper.ksh: PID=87988: Object exceeds FTS max size. objStrGetStatus
INFO AbstractShellJobExecutor - EXT_PROG_SYS_OUT:zipfilewait.ksh: Mon Aug 28 18:09:01 Program: ri_object_store_wrapper.ksh: PID=87988: File scan status fetched successfully. File Scan Status: Failed. Read Allowed: true. Object exceeds FTS max size. objStrGetStatus

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!

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