ORDS 500 Internal Server Error (SEVERE ... Java.sql.SQLException: Missing Defines)
(Doc ID 2473885.1)
Last updated on OCTOBER 17, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle 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 |