Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Authorization Bearer 401 errors after APEX/ORDS upgrade

Ed SJun 8 2021 — edited Jun 8 2021

Yesterday I posted that our APIs no longer work, given 401 errors, after upgrading to APEX 19.1. We turned some debugging on and our getting the following error. Anyone have any ideas?
[TE] url-mapping start: 2021-06-08T15:43:51.811Z duration: 0ms
Mapped request to mapping: *MY_SCHEMA|test|pu|, cryptoKeys=*****, id=xxxxxxxx, identityDomain=__NO_IDENTITY_DOMAIN__
Approval still valid: TRUE
java.sql.SQLDataException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-06512: at "ORDS_METADATA.OAUTH", line 756
ORA-06512: at "ORDS_METADATA.OAUTH_INTERNAL", line 543
ORA-06512: at "ORDS_METADATA.OAUTH", line 748
ORA-06512: at line 1

OAuthException [error=SERVER_ERROR, description=null, cause=java.sql.SQLDataException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-06512: at "ORDS_METADATA.OAUTH", line 756
ORA-06512: at "ORDS_METADATA.OAUTH_INTERNAL", line 543
ORA-06512: at "ORDS_METADATA.OAUTH", line 748
ORA-06512: at line 1

No user authenticated, public access to: example_priv is not permitted
Comments
Post Details
Added on Jun 8 2021
0 comments
63 views