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.


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



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.