Hi experts,
We're using APEX 24.1.7 and we have a strange recurrent incident in lower environments.
After few days of running we can't log into any APEX app, even the apex-builder (4550) application.
After entering login (workspace, user, pwd), we this this error:
It also affects to custom apps, where you can't go further the login page.
It's temporarily solved by bouncing Tomcat, but it's reproduced consistently after 2-3 days.
In APEX Log we get to this error:
Error: Application "4550" Page "" not found.
- Additional info: Contact your application administrator.
Details about this incident are available via debug id "1044146".
- Display location: ON_ERROR_PAGE
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: true
- Common runtime error: false
- APEX error code: APEX.PAGE.NOT_FOUND
- SQL code: -28500
- SQL error: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[MySQL][ODBC 9.1(w) Driver]Lost connection to MySQL server during query {HY000,NativeErr = 2013}
ORA-02063: preceding 2 lines from ODSDIST
ORA-06512: at "APEX_240100.WWV_FLOW_LANG", line 610
- Backtrace: ORA-06512: at "APEX_240100.WWV_FLOW_LANG", line 610
ORA-06512: at "APEX_240100.WWV_FLOW", line 241
- Statement:
- Component: APEX_APPLICATIONS (4550)
So it seems it's caused by a custom SQL which is accessing a known db-link (ODSDIST). DB link is working correctly, but it seems like a missing object.
My goal is to find where the hell is that SQL to analyze the error. The exception is thrown in APEX_240100.wwv_flow_lang.reset_nls
Any ideas?
Thanks,
Jose.