My Oracle Support Banner

ORA-12801: error signaled on server P000, instance 6 of queries parallel (Doc ID 2420960.1)

Last updated on JULY 16, 2018

Applies to:

Autonomous Data Warehouse Cloud - Version N/A to N/A
Information in this document applies to any platform.

Symptoms

Loading Data in the form of compressed file in object storage using  the DBMS_CLOUD.COPY_DATA in ADWS instance is failing with below error :

BEGIN
DBMS_CLOUD.COPY_DATA(
table_name => 'beneficio_categoria',
credential_name => 'CRED_XXXXX',
file_uri_list => 'https://uscom-central-1.storage.oraclecloud.com/v1/Storage-ageaadwc/container01/BENEFICIO_CATEGORIA_1.txt.gz',
format => json_object('delimiter' value '|'));
END;
/

This procedure runs successfully, but sometimes is obtained the following error, being this is ramdonly

ERROR en línea 1:
ORA-12801: error signaled on server P000, instance 6 of queries
parallel
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD", lfnea 801
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD", lfnea 782
ORA-29913: error when executing the ODCIEXTTABLEFETCH call
ORA-30653: the rejection limit has been reached
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD", lfnea 757
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD", lfnea 819
ORA-06512: en línea 2

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!

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