ORDS restful calls result in 500 error, ORA-00942: table or view does not

Picture of Tim Davis

Tim Davis

Senior Cloud and Security Engineer

Share Post:


Out of nowhere, we started receiving  500 errors on the front end for any APEX restful api calls : “An unexpected error with the following message occurred: InternalServerException [statusCode=500, reasons=[]]” . This is very odd as we only rebooted service with no other changes. We monitor few URLs to ensure resful api is returning specific string, is string does not match our support receive email and text message alerts.

 At the back end ( tomcat catalina.out logs ), we noticed a lot of nasty jdbc and other errors related to restful api calls. At the top of the error block we noticed ORA-00942: table or view does not exist

What we did to resolve this?

1. Stopped tomcat service

2. We removed ords  and ords.war from tomcat/webapps directory

3. We ran java -jar ords.war validate , you should view output of validate command to see what changes were done.  Usually the output will be stored in a file ords_validate_core_20xx-mm-dd-xxxxx.log

After validate completed, copy ords.war into tomcat/webapps directory and restart tomcat. The issue should be resolved.



Stay Connected

More Updates

Log4j2 Vulnerability

Revion is not using Log4j2 tool for apache-tomcat, we are using default lightweight API – Java logging API — java.util.logging. Additionally, we are not exposing

Bind/DNS services upgraded

To address security vulnerability discovered in Bind 9.8.1. we have upgraded all bind dns servers to 9.8.1.-P1