Task UI User Preferences Not Saving (Doc ID 2014682.1)

Last updated on APRIL 03, 2023

Applies to:

Symptoms

Customer is unable to save changes to user preferences in the Task UI. The following exception appears in the log:

com.mslv.oms.dataaccesslayer.ProxyException: Exception when [insert into om_user_attributes values(?,?,?,?,?,?)]. Nested Exception: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_ATTRIBUTES) violated Nested Exception: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_ATTRIBUTES) violated Nested Exception: com.mslv.oms.dataaccesslayer.ProxyException: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_ATTRIBUTES) violated Nested Exception: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_ATTRIBUTES) violated Nested Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_ATTRIBUTES) violated at com.mslv.oms.model.userinfo.UserInfoMgr.a(Unknown Source) at com.mslv.oms.model.userinfo.UserInfoMgr.a(Unknown Source) at com.mslv.oms.model.userinfo.UserInfoMgr.updateUserOrderListActionDefault(Unknown Source) at com.mslv.oms.security.OMSSessionEJB.updateUserOrderListActionDefault(Unknown Source) at com.mslv.oms.security.OMSSession_wnx5m2_EOImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
 at com.mslv.oms.security.OMSSession_wnx5m2_EOImpl.updateUserOrderListActionDefault(Unknown Source) at com.mslv.oms.jsp.processor.OptionProcessor.a(Unknown Source) at com.mslv.oms.jsp.processor.OptionProcessor.processRequest(Unknown Source) at com.mslv.oms.jsp.controller.RequestController.a(Unknown Source) at com.mslv.oms.jsp.controller.RequestController.processRequest(Unknown Source) at com.mslv.oms.jsp.controller.MainServlet.a(Unknown Source) at com.mslv.oms.jsp.controller.MainServlet.doProcess(Unknown Source) at com.mslv.oms.jsp.controller.MainServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
 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.TailFilter.doFilter(TailFilter.java:26)
 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
 at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
 at java.security.AccessController.doPrivileged(Native Method) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
 at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
 at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
 at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
 at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
 at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
 at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: com.mslv.oms.dataaccesslayer.ProxyException: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_ATTRIBUTES) violated Nested Exception: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_ATTRIBUTES) violated Nested Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_ATTRIBUTES) violated at com.mslv.oms.dataaccesslayer.AbstractProxy.execute(Unknown Source) ... 40 more Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT1.XPKOM_USER_ATTRIBUTES) violated at

Cause

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