3359257 - Error "Unable to perform action: reset" when resetting a password

When attempting to change a user's password, the customer encountered the error "Unable to perform action: reset." The stack trace indicates a unique constraint violation in the database.
 

java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.workforcesoftware.Jsp.Util.ActionHandler.doAction(ActionHandler.java:218)
    at com.workforcesoftware.Jsp.Security.UserManagementAction.doAction(UserManagementAction.java:53)
    at com.workforcesoftware.ClientRequests.JspUtils.WActionBase.performNoSynchronize(WActionBase.java:639)
    at com.workforcesoftware.ClientRequests.JspUtils.WActionBase.handleNormalRequest(WActionBase.java:510)
    at com.workforcesoftware.ClientRequests.JspUtils.WActionBase.handleRequest(WActionBase.java:246)
    at com.workforcesoftware.ClientRequests.JspUtils.WActionBase.perform(WActionBase.java:183)
    at org.apache.struts.action.Action.execute(Action.java:420)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.ezest.util.TargetToSystemFeatureFilter.doFilter(TargetToSystemFeatureFilter.java:108)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.workforcesoftware.ClientRequests.WFServletFilter$1.execute(WFServletFilter.java:59)
    at com.workforcesoftware.runtime.ResourceTracker.executeThenRelease(ResourceTracker.java:194)
    at com.workforcesoftware.runtime.ResourceTracker.executeOperationAndReleaseResources(ResourceTracker.java:111)
    at com.workforcesoftware.ClientRequests.WFServletFilter.doFilter(WFServletFilter.java:50)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.workforcesoftware.Security.CsrfTokenFilter.doFilter(CsrfTokenFilter.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.workforcesoftware.ClientRequests.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Caused by: com.workforcesoftware.Exceptions.InternalApplicationException: java.sql.SQLException: ORA-00001: unique constraint (CUSA_PROD_SCHEMA.Z_AU_SID) violated
    at com.workforcesoftware.ClientRequests.Security.ResetPassword.resetPasswordForUser(ResetPassword.java:77)
    at com.workforcesoftware.ClientRequests.Security.ResetPassword.execute(ResetPassword.java:50)
    at com.workforcesoftware.Jsp.Security.UserManagementActionHandler.reset(UserManagementActionHandler.java:139)
    ... 50 more
Caused by: java.sql.SQLException: ORA-00001: unique constraint (CUSA_PROD_SCHEMA.Z_AU_SID) violated
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
    at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.workforcesoftware.Util.LoggingInvocationHandler.invoke(LoggingInvocationHandler.java:70)
    at com.workforcesoftware.Util.DB.SQLInvocationHandler.invoke(SQLInvocationHandler.java:48)
    at com.workforcesoftware.Util.DB.StatementProxyHandler.executeLikeCall(StatementProxyHandler.java:130)
    at com.workforcesoftware.Util.DB.StatementProxyHandler.invoke(StatementProxyHandler.java:182)
    at com.workforcesoftware.Util.DB.PreparedStatementProxyHandler.invoke(PreparedStatementProxyHandler.java:171)
    at com.sun.proxy.$Proxy19.executeUpdate(Unknown Source)
    at com.workforcesoftware.Util.DB.OracleDBOps$OracleBatchExecutor.addToBatch(OracleDBOps.java:110)
    at com.workforcesoftware.Util.DB.StandardDbListWriter.doInsertAudits(StandardDbListWriter.java:195)
    at com.workforcesoftware.Util.DB.ListWriter.doAudits(ListWriter.java:501)
    at com.workforcesoftware.Util.DB.ListWriter.writeListsImpl(ListWriter.java:278)
    at com.workforcesoftware.Util.DB.ListWriter.writeListsImpl(ListWriter.java:232)
    at com.workforcesoftware.Util.DB.ListWriter.writeLists(ListWriter.java:210)
    at com.workforcesoftware.Util.DB.ListWriter.writeLists(ListWriter.java:220)
    at com.workforcesoftware.Util.DB.ListWriter.writeLists(ListWriter.java:175)
    at com.workforcesoftware.Util.DB.ListWriter.writeLists(ListWriter.java:142)
    at com.workforcesoftware.ClientRequests.Security.ResetPassword.resetPasswordForUser(ResetPassword.java:75)
    ... 52 more

SAP Time and Attendance Management by WorkForce Software (Version 9.7 and earlier )

Error, password, expiry, reset, Change password, Java Exception , KBA , XX-PART-WFR-TAM , SAP Time and Attendance Management by Workforce Software , Problem