After upgrading (and rebuild of frontend SSO with header auth) to APEX 24.1 noticed that dbactions / sdw launching via APEX sql workshop dropdown sql developer web fails to METHOD NOT ALLOWED. The Apex Instance has “Enable SQL Developer Web” = Yes. Also dbactions work normally via e.g. ORDS landing page or by accessing directly.
Any hint where to look next?
--
The offending url with return code 405 Method Not Allowed is like this:
https://fqdn/ords/con/r/restenaschemaalias/sign-in/exchange
And Apex pops this dialog:
Error Message
1 error has occurred
--with details:
Technical Info (only available for developers)
- Cause: undefined
- Action: undefined
It seems that in my setup the extra /r/ in the url breaks it, because if /r is removed then it works, IF you have logged in earlier to sdw then it opens.
https://fqdn/ords/con/r/restenaschemaalias/_sdw?nav=worksheet ← this fails
https://fqdn/ords/con/restenaschemaalias/_sdw?nav=worksheet ← this opens sdw worksheet
rgrds Paavo
ps. I remember having challenges earlier with this, but now can't remember the way to fix this