My Oracle Support Banner

Accessing Restful services in Multitenant Database when "preHook" is defined in ORDS. (Doc ID 2729294.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Oracle Application Express (APEX) - Version 20.1 to 20.2
Oracle REST Data Services - Version 19.1 to 20.3
Information in this document applies to any platform.

Symptoms

When you are trying to access the restful services created in one of the PDB's of a Multitenant Database which is configured with multiple database of the ORDS,

And getting the below mentioned errors.

Errors:
========

503 Service Unavailable
2020-11-02T15:49:19.552Z | W7alMOpWzRpwRZWV05J9Rg

The request could not be processed because the database stored function pre-hook associated with this resource could not be invoked
Debug Trace
[TE] url-mapping start: 2020-11-02T15:49:19.553Z duration: 121ms

Stack Trace
ServiceUnavailableException [statusCode=503, logLevel=SEVERE, reasons=[The request could not be processed because the database stored function pre-hook associated with this resource could not be invoked]]
at oracle.dbtools.rest.owa.OracleWebAgentPreHook.before(OracleWebAgentPreHook.java:86)
at oracle.dbtools.http.dispatch.hooks.DispatchHookChain.before(DispatchHookChain.java:34)
at oracle.dbtools.http.dispatch.hooks.DispatchHooks.before(DispatchHooks.java:49)

Changes

 defauls.xml file is updated with a specific parameter.

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.