My Oracle Support Banner

ORDS 500 Internal Server Error (SEVERE ... Java.sql.SQLException: Missing Defines) (Doc ID 2473885.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle REST Data Services - Version 17.4 to 18.2
Information in this document applies to any platform.

Symptoms

1. Everything usually runs fine, but lately they have been getting more and more intermittent
InternalServerException [statusCode=500, reasons=[]] that are reported to the front end users

2 The error can occur at any time, however mostly occurs after a period of inactivity - say 10-20 minutes or more and can be resolved by refreshing.

The Tomcat logs show errors as below;

catalina.2018-10-02.log_500error
02-Oct-2018 10:14:43.283 SEVERE [https-jsse-nio-8181-exec-13] . java.sql.SQLException: Missing defines
 InternalServerException [statusCode=500, reasons=[]]
  at oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:276)
  at oracle.dbtools.apex.OWA.init(OWA.java:471)
  at oracle.dbtools.apex.ModApex.doGet(ModApex.java:132)
  at oracle.dbtools.apex.ModApex.service(ModApex.java:104)
  at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:125)
...
...

Changes

 None

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
References


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