My Oracle Support Banner

oracle.security.fed.jvt.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-00957: duplicate column name (Doc ID 2442805.1)

Last updated on SEPTEMBER 06, 2018

Applies to:

Oracle Access Manager - Version 11.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.2.3.171017 version, Authentication Engine

Customer getting noticing below error message on their OAM environment.

[2018-08-01T00:37:20.360-04:00] [game004] [ERROR] [FEDSTS-12036] [oracle.security.fed.eventhandler.fed.authn.LoginResultEventHandler] [tid: [ACTIVE].ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000MJnle_2ATOl5kvCCyZ1RNK_S00H_KL,0] [APP: oam_server#11.1.2.0.0] [DSID: 0000MJnle^XATOl5kvCCyZ1RNK_S00H_KJ] Persistence Exception: error while creating or modifying data in the backend store {0}[[
oracle.security.fed.jvt.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-00957: duplicate column name
        at oracle.security.fed.model.session.rdbms.RDBMSSession.update(RDBMSSession.java:587)
        at oracle.security.fed.model.session.rdbms.RDBMSSession.persist(RDBMSSession.java:603)
        at oracle.security.fed.eventhandler.fed.authn.LoginResultEventHandler.perform(LoginResultEventHandler.java:269)
        at oracle.security.fed.controller.ActionStateMachine.processEvent(ActionStateMachine.java:173)
        at oracle.security.fed.controller.EventControllerImpl.processEvent(EventControllerImpl.java:87)
        at oracle.security.fed.controller.ApplicationController.publishEvent(ApplicationController.java:454)
        at oracle.security.fed.controller.frontend.action.RequestHandlerContext.publishEvent(RequestHandlerContext.java:50)
        at oracle.security.fed.controller.frontend.action.RequestHandlerSupport.perform(RequestHandlerSupport.java:15)
        at oracle.security.fed.controller.web.servlet.FederationServlet.processServletRequest(FederationServlet.java:386)
        at oracle.security.fed.controller.web.servlet.FederationServlet.doGet(FederationServlet.java:194)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
        at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
        at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)
        at oracle.security.am.pbl.transport.http.AMServlet.doForward(AMServlet.java:820)
        at oracle.security.am.pbl.transport.http.AMServlet.handleResponse(AMServlet.java:634)
        at oracle.security.am.pbl.transport.http.AMServlet.handleRequest(AMServlet.java:228)
        at oracle.security.am.pbl.transport.http.AMServlet.doPost(AMServlet.java:179)
        at oracle.security.am.pbl.transport.http.AMServlet.doGet(AMServlet.java:1040)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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