My Oracle Support Banner

How to Get Details for Why an External Table Load Has Failed (Doc ID 2931646.1)

Last updated on MARCH 06, 2023

Applies to:

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

Goal

While trying to get the details for why an external table load has failed, the logs shows this:

2023-02-21T14:06:49,776 [pool-13-thread-504] ERROR AbstractJobExecutor - Status check shows failed job, due to [ORA-20003: Reject limit reached, query table "RADM01"."COPY$10424_LOG" for error details

The Ops Guide says to run SQL but this is the result:

select * from table (ri_support_util.get_file_load_result('LOG', '10424'));

ORA-20001: Error occurred in RI_SUPPORT_UTIL.ri_support_util

Why?

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.