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

ords_error_500

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.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *