A Small Deployment On An Upgraded OAG Instance Causes Error: OAuthAuthorizations Does Not Exist (Doc ID 2076343.1)

Last updated on AUGUST 01, 2023

Applies to:

Symptoms

On : 11.1.2 version, Oracle API Gateway

When attempting to start a new migrated OAG installation from 11.1.2.3.0 to 11.1.2.4.0, the following error is reported in the gateway trace file.

ERROR
-----------------------
DEBUG 08/Oct/2015:11:21:03.470 [6567:de971656020078b8c1baac6c] Found entity in federated store [PrimaryStore-<...........>.xml] for key: [], real key: [1968]
DEBUG 08/Oct/2015:11:21:03.475 [6567:de971656020078b8c1baac6c] Found entity in federated store [PrimaryStore-<...........>.xml] for key: [], real key: [1968]
DEBUG 08/Oct/2015:11:21:03.475 [6567:de971656020078b8c1baac6c] Circuit 'Authorization Request' {
DEBUG 08/Oct/2015:11:21:03.476 [6567:de971656020078b8c1baac6c] Starting filter: PrimaryStore-<...........>:1969
DEBUG 08/Oct/2015:11:21:03.476 [6567:de971656020078b8c1baac6c] Fault handler: -1
DEBUG 08/Oct/2015:11:21:03.674 [6567:de971656020078b8c1baac6c] OAuthAuthorizationRequestFilter {
DEBUG 08/Oct/2015:11:21:03.674 [6567:de971656020078b8c1baac6c] ESPK: PrimaryStore-<...........>:1969
DEBUG 08/Oct/2015:11:21:03.674 [6567:de971656020078b8c1baac6c] ParentPK: (<PARENT PK>)
DEBUG 08/Oct/2015:11:21:03.674 [6567:de971656020078b8c1baac6c] Key Fields:
DEBUG 08/Oct/2015:11:21:03.674 [6567:de971656020078b8c1baac6c] name: {OAuthAuthZ}
DEBUG 08/Oct/2015:11:21:03.674 [6567:de971656020078b8c1baac6c] Fields:
DEBUG 08/Oct/2015:11:21:03.674 [6567:de971656020078b8c1baac6c] logSuccess: {Filter passed}
DEBUG 08/Oct/2015:11:21:03.674 [6567:de971656020078b8c1baac6c] subjectAttr: {${authentication.subject.id}}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] logFailure: {Filter failed}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] logMask: {7}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] abortProcessingOnLogError: {0}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] logFatal: {Filter aborted due to exception}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] resourceOwnerCookieName: {<RESOURCEOWNERCOOKIE>}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] grantAccessTemplateLocation: {${environment.VDISTDIR}/samples/oauth/templates/requestAccess.html}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] scopeCircuitPK: {-1}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] recordOutboundTxns: {1}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] serviceName: {}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] circuitPK: {-1}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] loginTemplateLocation: {${environment.VDISTDIR}/samples/oauth/templates/login.html}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] logMaskType: {FILTER}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] accessCodeTemplateLocation: {${environment.VDISTDIR}/samples/oauth/templates/showAccessCode.html}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] authzCodeCache: {}
DEBUG 08/Oct/2015:11:21:03.675 [6567:de971656020078b8c1baac6c] refreshTokenExpiresInSecs: {43200}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] accessTokenExpiresInSecs: {3600}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] clientAttributeName: {authentication.subject.id}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] refreshChoice: {NewRefresh}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] authNWith: {<INTERNAL_AUTHN_FLOW>}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] scopesForToken: {${scopes.for.token}}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] authzCodeExpiresInSecs: {600}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] accessTokenlength: {54}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] scopesMustMatch: {Any}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] tokenStore: {}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] refreshTokenlength: {46}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] category: {PrimaryStore-<...........>:454}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] scopeChoice: {Application}
DEBUG 08/Oct/2015:11:21:03.676 [6567:de971656020078b8c1baac6c] authzCodeLength: {30}
DEBUG 08/Oct/2015:11:21:03.677 [6567:de971656020078b8c1baac6c] metricsMask: {3}
DEBUG 08/Oct/2015:11:21:03.677 [6567:de971656020078b8c1baac6c] successNode:
DEBUG 08/Oct/2015:11:21:03.677 [6567:de971656020078b8c1baac6c] accessTokenType: {Bearer}
DEBUG 08/Oct/2015:11:21:03.677 [6567:de971656020078b8c1baac6c] compositeContext: {0}
DEBUG 08/Oct/2015:11:21:03.677 [6567:de971656020078b8c1baac6c] _version: {5}
DEBUG 08/Oct/2015:11:21:03.677 [6567:de971656020078b8c1baac6c] class: {com.vordel.circuit.oauth.provider.authorize.OAuthAuthorizationRequestFilter}
DEBUG 08/Oct/2015:11:21:03.677 [6567:de971656020078b8c1baac6c] }
DEBUG 08/Oct/2015:11:21:03.680 [6567:de971656020078b8c1baac6c] Found entity in federated store [ExtConnsStore-<...........>.xml] for key: [], real key: [10]
DEBUG 08/Oct/2015:11:21:03.681 [6567:de971656020078b8c1baac6c] Found entity in federated store [ExtConnsStore-<...........>.xml] for key: [], real key: [35]
DEBUG 08/Oct/2015:11:21:03.682 [6567:de971656020078b8c1baac6c] Found entity in federated store [ExtConnsStore-<...........>.xml] for key: [], real key: [12]
DEBUG 08/Oct/2015:11:21:03.683 [6567:de971656020078b8c1baac6c] Found entity in federated store [ExtConnsStore-<...........>.xml] for key: [], real key: [38]
ERROR 08/Oct/2015:11:21:03.688 [6567:de971656020078b8c1baac6c] KPS Table with alias: OAuthAuthorizations does not exist.
DEBUG 08/Oct/2015:11:21:03.696 [6567:de971656020078b8c1baac6c] There is no fault handler filter configured for the circuit: Authorization Request, using default fault handler
DEBUG 08/Oct/2015:11:21:03.696 [6567:de971656020078b8c1baac6c] }

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.