"ORA-00001: unique constraint (ASAP.PK_MS_TABLE_KEY_VALUE) violated" Error Adding New Network Element Type in the GUI (Doc ID 2858607.1)

Last updated on AUGUST 22, 2023

Applies to:

Symptoms

When attempting to add a new Network Element Type in the GUI, a "ORA-00001: unique constraint (ASAP.PK_MS_TABLE_KEY_VALUE) violated" error and its stack trace is received after clicking "Save and Close". The error/ stack trace displays in red text (see below).


Recreation Steps

1. Application Setup.

2. Inventory Management Setup.

3. Network Element Types (under Network/Equipment section).

4. Add New.

5 Enter desired data in the Network Element Type window (w_websheet_tms / networkElementType.jsp).

6.Click "Save and Close" and the error is thrown.


Complete Error/Stack Trace as Displayed in GUI

The server encountered the following Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ASAP.PK_MS_TABLE_KEY_VALUE) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361) at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170) at com.metasolv.jdbc.MSVPreparedStatement.executeUpdate(MSVPreparedStatement.java:98) at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:616) at MetaSolv.persistent.jdbc.JDSC.issueInsert(JDSC.java:714) at MetaSolv.persistent.jdbc.JDSC.issueInsert(JDSC.java:852) at com.mslv.core.api.internal.netmgmt.template.BuildingBlockMaint.add(BuildingBlockMaint.java:150) at com.mslv.core.api.internal.netmgmt.template.BuildingBlockMaint.addForComponentType(BuildingBlockMaint.java:51) at com.mslv.core.api.internal.netmgmt.template.ComponentTypeAddData.add(ComponentTypeAddData.java:128) at com.mslv.core.api.internal.netmgmt.template.ComponentTypeMaintenanceManager.addComponentType(ComponentTypeMaintenanceManager.java:47) at com.mslv.core.api.internal.NetProv.Equipment.networkElement.busObj.NetworkElementTypeBusObj.createCompType(NetworkElementTypeBusObj.java:1090) at com.mslv.core.api.internal.NetProv.Equipment.networkElement.busObj.NetworkElementTypeBusObj.processCreateNetworkElementType(NetworkElementTypeBusObj.java:499) at com.mslv.core.api.internal.NetProv.Equipment.networkElement.busObj.NetworkElementTypeBusObj.createNetworkElementType(NetworkElementTypeBusObj.java:400) at com.mslv.ejb.netprov.modifier.networkElement.CreateNetworkElementTypeModifier.performModification(CreateNetworkElementTypeModifier.java:52) at com.mslv.ejb.BaseModifier.initiateModification(BaseModifier.java:72) at com.mslv.ejb.MSLVEJB3SessionBean.initiateModification(MSLVEJB3SessionBean.java:765) at com.mslv.ejb.netprov.NetworkElementBean.createNetworkElementType(NetworkElementBean.java:105) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101) at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:101) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73) at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52) at sun.reflect.GeneratedMethodAccessor319.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:94) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) at com.sun.proxy.$Proxy318.createNetworkElementType(Unknown Source) at com.mslv.ejb.netprov.NetworkElement_i7k9d8_INetworkElementImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invokeInternal(SessionRemoteMethodInvoker.java:54) at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:21) at com.mslv.ejb.netprov.NetworkElement_i7k9d8_INetworkElementImpl.createNetworkElementType(Unknown Source) at com.mslv.ejb.netprov.NetworkElement_i7k9d8_INetworkElementImpl_CBV.createNetworkElementType(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:86) at com.sun.proxy.$Proxy217.createNetworkElementType(Unknown Source) at com.mslv.ejb.netprov.NetworkElementHandler.createNetworkElementType(NetworkElementHandler.java:104) at com.mslv.webapp.netprov.action.PostNetworkElementType.execute(PostNetworkElementType.java:117) 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:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) at com.mslv.webapp.filter.ParamFilter.doFilter(ParamFilter.java:39) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3683) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326) at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197) at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203) at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71) at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259) at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1691) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1651) at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270) at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348) at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333) at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54) at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406) at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)

Cause

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