MetaSolv Solution "ORA-00001: unique constraint" errors after database import

(Doc ID 1311655.1)

Last updated on MARCH 01, 2016

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.15 and later
Information in this document applies to any platform.
*** Reviewed on August 25, 2014 ***

Symptoms

Users testing in a TEST or DEVELOPMENT environment report "ORA-00001: unique constraint" errors across various areas of the MetaSolv Solution application after the environment was refreshed using an exported database from PRODUCTION. Below is a sample error encountered when attempting to create a PSR order with new Custom Attributes.

The server encountered the following Exception: java.sql.SQLException: ORA-00001: unique constraint (ASAP.PK_SRSI_CA_VAL) violated
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
    at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2977)
    at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:147)
    at com.metasolv.jdbc.MSVPreparedStatement.executeUpdate(MSVPreparedStatement.java:85)
    at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:621)
    at MetaSolv.persistent.jdbc.JDSC.issueInsert(JDSC.java:716)
    at MetaSolv.persistent.jdbc.JDSC.issueInsert(JDSC.java:861)
    at com.mslv.core.api.internal.ca.value.CaValueManager.processInsertValue(CaValueManager.java:962)
    at com.mslv.core.api.internal.ca.value.CaValueUpdateManager.updateCaValues(CaValueUpdateManager.java:1441)
    at com.mslv.core.api.internal.ca.value.CaValueUpdateManager.updateOrderItemCaValues(CaValueUpdateManager.java:1722)
    at com.mslv.core.api.internal.ca.value.CaValueUpdateManager.updateCaValuesInOrder(CaValueUpdateManager.java:85)
    at com.mslv.core.api.internal.PSR.importData.ServiceItem.update(ServiceItem.java:1044)
    at com.mslv.core.api.internal.PSR.importData.ConnectionServiceItem.update(ConnectionServiceItem.java:903)
    at com.mslv.ejb.PSR.modifier.UpdateConnectionServItemModifier.initiateModification(UpdateConnectionServItemModifier.java:60)
    at com.mslv.ejb.MSLVSessionBean.initiateModification(MSLVSessionBean.java:771)
    at com.mslv.ejb.PSR.NgnOrderingBean.updateConnectionOnOrder(NgnOrderingBean.java:801)
    at com.mslv.ejb.PSR.NgnOrdering_d0fbgw_EOImpl.updateConnectionOnOrder(NgnOrdering_d0fbgw_EOImpl.java:3718)
    at com.mslv.ejb.PSR.NgnOrdering_d0fbgw_EOImpl_CBV.updateConnectionOnOrder(Unknown Source)
    at com.mslv.ejb.PSR.NgnOrderingHandler.updateConnectionOnOrder(NgnOrderingHandler.java:738)
    at com.mslv.webapp.psr.data.ConnectionAttributesData.updateConnectionOnOrder(ConnectionAttributesData.java:119)
    at com.mslv.webapp.psr.action.PostConnectionAttributes.execute(PostConnectionAttributes.java:163)
    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:760)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
    at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
    at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
    at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)

Changes

Database was refreshed using an exported copy of another database. 

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