Hello,
I am facing a really strange issue, I installed ORDS18.2 on database 18c and apex 18.1, tomcat 8. Everything works fine the first time but some days later it began to appear the error 500 internal server error when I try to access the restful services created. The log in tomcat shows the following:
Caused by: Error : 604, Position : 0, Sql = select nvl(h.items_per_page,m.items_per_page) items_per_page, t.etag_type, t.etag_query, h.source_type, cursor(select p.name, p.bind_variable_name, p.source_type,p.access_method, p.param_type from user_ords_parameters p where p.handler_id = h.id) parameters, h.source from user_ords_modules m, user_ords_templates t, user_ords_handlers h where m.status = 'PUBLISHED' and t.id = h.template_id and m.id = t.module_id and h.id = :1 , OriginalSql = select nvl(h.items_per_page,m.items_per_page) items_per_page, t.etag_type, t.etag_query, h.source_type, cursor(select p.name, p.bind_variable_name, p.source_type,p.access_method, p.param_type from user_ords_parameters p where p.handler_id = h.id) parameters, h.source from user_ords_modules m, user_ords_templates t, user_ords_handlers h where m.status = 'PUBLISHED' and t.id = h.template_id and m.id = t.module_id and h.id = ?, Error Msg = ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
I uninstall ords and install it again and works fine for some days but again the error appears (without any apparent reason)
If I run the query connected directly to the database as ords_public_user, apex_rest_public_user, apex_listener or apex_public_user the query run succesfully, returning 0 rows, but no errors on table or view does not exists, so I cant understand why this error is showing.
Which user does ORDS use to execute the query?
Connection to apex does work fine always, the problem is only accesing the restful services.
Any help or tip to pinpoint the error is appreciated.