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

Last updated on DECEMBER 02, 2016

Applies to:

Oracle API Gateway - Version 11.1.2 and later
Information in this document applies to any platform.

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-6b1f62df-d6d1-4d45-9fc8-31f186a74f31.xml] for key: [], real key: [1968]
DEBUG 08/Oct/2015:11:21:03.475 [6567:de971656020078b8c1baac6c] Found entity in federated store [PrimaryStore-6b1f62df-d6d1-4d45-9fc8-31f186a74f31.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-6b1f62df-d6d1-4d45-9fc8-31f186a74f31: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-6b1f62df-d6d1-4d45-9fc8-31f186a74f31:1969
DEBUG 08/Oct/2015:11:21:03.674 [6567:de971656020078b8c1baac6c] ParentPK: (ES_NULL_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-6b1f62df-d6d1-4d45-9fc8-31f186a74f31: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-b1ea4c06-616d-4fd6-a915-fe979f3d47d8.xml] for key: [], real key: [10]
DEBUG 08/Oct/2015:11:21:03.681 [6567:de971656020078b8c1baac6c] Found entity in federated store [ExtConnsStore-b1ea4c06-616d-4fd6-a915-fe979f3d47d8.xml] for key: [], real key: [35]
DEBUG 08/Oct/2015:11:21:03.682 [6567:de971656020078b8c1baac6c] Found entity in federated store [ExtConnsStore-b1ea4c06-616d-4fd6-a915-fe979f3d47d8.xml] for key: [], real key: [12]
DEBUG 08/Oct/2015:11:21:03.683 [6567:de971656020078b8c1baac6c] Found entity in federated store [ExtConnsStore-b1ea4c06-616d-4fd6-a915-fe979f3d47d8.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] }



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms