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 laterOracle 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! |