I recently upgraded to ORDS 26.1.2.r1401916.
Most of the time apex works fine, but occasionally I am getting a "HTTP Status code 500" error. (have experienced the same with ORDS 24)
When this happens, I get error in Apex Workspace login page and it won't open. Application login opens but give same error after login.
after I grant these rights, it works fine.
ALTER SESSION SET CONTAINER=dev;
GRANT SELECT ON ORDS_METADATA.ORDS_PARAMETERS TO <my_schema>;
GRANT SELECT ON ORDS_METADATA.ORDS_SCHEMAS TO <my_schema>;
Weblogic log shows this error
weblogic.work.ExecuteThread.run(ExecuteThread.java:370)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, h.mle_env_name, m.origins_allowed, cursor(select p.name, p.bind_variable_name, p.source_type,p.access_method, p.param_type from ORDS_METADATA.user_ords_parameters p where p.handler_id = h.id) parameters, h.source from ORDS_METADATA.user_ords_modules m, ORDS_METADATA.user_ords_templates t, ORDS_METADATA.user_ords_handlers h where m.status = 'PUBLISHED' and t.id = h.template_id and m.id = t.module_id and h.id = :1 , Original SQL = select nvl(h.items_per_page,m.items_per_page) items_per_page, t.etag_type, t.etag_query, h.source_type, h.mle_env_name, m.origins_allowed, cursor(select p.name, p.bind_variable_name, p.source_type,p.access_method, p.param_type from ORDS_METADATA.user_ords_parameters p where p.handler_id = h.id) parameters, h.source from ORDS_METADATA.user_ords_modules m, ORDS_METADATA.user_ords_templates t, ORDS_METADATA.user_ords_handlers h where m.status = 'PUBLISHED' and t.id = h.template_id and m.id = t.module_id and h.id = ?, Error Message = ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist
@thatjeffsmith-oracle
If anyone can help identify or solve the issue, it would be greatly appreciated.