My Oracle Support Banner

ORA-01403: No Data Found Enabling REST In Configuration Of ORDS For APEX And Mapping For REST Only (Doc ID 2686456.1)

Last updated on JULY 13, 2020

Applies to:

Oracle REST Data Services - Version 19.4.6 and later
Information in this document applies to any platform.

Symptoms

On :ORDS 19.4.0 version, All Issues

When attempting to enable a schema
the following error occurs.

ERROR
-----------------------
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "ORDS_METADATA.ORDS", line 164
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 416
ORA-06512: at "ORDS_METADATA.ORDS_SERVICES_INTERNAL", line 2462
ORA-06512: at "ORDS_METADATA.ORDS_SERVICES_INTERNAL", line 3739
ORA-06512: at "ORDS_METADATA.ORDS_SERVICES_INTERNAL", line 3546
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 193
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 380
ORA-06512: at "ORDS_METADATA.ORDS_INTERNAL", line 430
ORA-06512: at "ORDS_METADATA.ORDS", line 149
ORA-06512: at line 2


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install ORDS for REST only as mapping on another ORDS already configured to access APEX
2.Connected to the new DB  try to enable a schema in sql*developer or sql*plus

Changes

 Add a new DB connection and mapping to an existing working ORDS that access APEX

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!


In this Document
Symptoms
Changes
Cause
Solution


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