Environment:
- Oracle AI Database 26ai Free (23.26.0.0)
- APEX 26.1.0
- ORDS 26.1.1.r1321130 (Docker container: container-registry.oracle.com/database/ords:latest)
- Apache HTTP Server with reverse proxy
- Single PDB: XEPDB1
Problem Description:
After upgrading ORDS from 25.3.1 to 26.1.1 and APEX from 24.2 to 26.1, the new APEXlang import feature fails for existing workspaces with the error:
ORDS Authentication request failed. Reason: Not Found
ORDS logs show:
POST /ords/maxapex_api/sign-in/exchange HTTP/1.1 404 Not Found
DispatcherNotFoundException [statusCode=404]
What We Tried:
-
De-register and re-register schema from APEX Builder UI multiple times
-
Delete schema from ORDS_METADATA.ORDS_SCHEMAS and ORDS_URL_MAPPINGS and re-register
-
ORDS.ENABLE_SCHEMA via PL/SQL
-
ORDS_ADMIN.PROVISION_RUNTIME_ROLE
-
Switching plsql.gateway.mode between direct and proxied
-
Running apex_rest_config.sql
-
Manually extracting and running ords_apex_sso.pls/plb from ORDS WAR
-
Creating sys.v_$pdbs synonym for ORDS_PUBLIC_USER
-
Granting SELECT ON sys.v_$pdbs TO PUBLIC
-
Forcing ORDS schema version back to 25.3.1 and re-running install
-
Multiple ORDS container restarts
How we can solve this issue i also sahre the screenshot with error that we faced.
Questions: