java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OIM.PK_PRF) violated

Oracle Community | 3268928 | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error While Installing DBAT Connector- Duplicate PRF

    Oracle Community | 7 months ago | 3268928
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OIM.PK_PRF) violated
  2. 0

    Oracle Access Manager default installation issue: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated

    Oracle Community | 2 years ago | Bram van Pelt
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated
  3. 0

    ODI Agent Failed

    Oracle Community | 9 months ago | Kimi
    oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access. ORA-01400: cannot insert NULL into ("EPMREP"."SNP_CONNECT_PROP"."PROP_KEY")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Active Directory Group Recon Error in OIM11gR2

    Oracle Community | 4 years ago | Srivatsa.kashyap
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("DEV_OIM"."UD_ADGRP"."UD_ADUSER_KEY")
  6. 0

    while saving Blanket purchase Agreements in oaf page i am getting this error

    Oracle Community | 1 year ago | 2996619
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PO"."PO_ATTRIBUTE_VALUES_TLP_DRAFT"."DESCRIPTION")
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLIntegrityConstraintViolationException

    ORA-00001: unique constraint (DEV_OIM.PK_PRF) violated

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeUpdate
    1. weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
    1 frame
  4. com.thortech.xl
    tcImportOperationsBean.performImport
    1. com.thortech.xl.dataaccess.tcDataBase.writePreparedStatement(tcDataBase.java:1745)
    2. com.thortech.xl.dataobj.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:186)
    3. com.thortech.xl.dataobj.tcTableDataObj.insertImplementation(tcTableDataObj.java:514)
    4. com.thortech.xl.dataobj.tcLinkDataObj.insertImplementation(tcLinkDataObj.java:134)
    5. com.thortech.xl.dataobj.tcTableDataObj.saveDDM(tcTableDataObj.java:2891)
    6. com.thortech.xl.ddm.repositories.rdbms.datatypes.data.TableInstance.finishDataObject(TableInstance.java:819)
    7. com.thortech.xl.ddm.repositories.rdbms.impl.RDBMSRepository.finishdataObject(RDBMSRepository.java:970)
    8. com.thortech.xl.ddm.engine.visitor.ImportVisitor.dataDependencyVisitComplete(ImportVisitor.java:636)
    9. com.thortech.xl.ddm.repositories.rdbms.impl.RDBMSRepository.handleDataBaseDependencies(RDBMSRepository.java:694)
    10. com.thortech.xl.ddm.engine.data.datatypes.SchemaInstance.traverse(SchemaInstance.java:282)
    11. com.thortech.xl.ddm.engine.data.datatypes.SchemaInstance.visitChildren(SchemaInstance.java:370)
    12. com.thortech.xl.ddm.engine.data.datatypes.SchemaInstance.traverse(SchemaInstance.java:287)
    13. com.thortech.xl.ddm.engine.data.datatypes.SchemaInstance.visitChildren(SchemaInstance.java:370)
    14. com.thortech.xl.ddm.engine.data.datatypes.SchemaInstance.traverse(SchemaInstance.java:287)
    15. com.thortech.xl.ddm.engine.SchemaInstanceFacade.performImport(SchemaInstanceFacade.java:437)
    16. com.thortech.xl.ejb.beansimpl.tcImportOperationsBean.performImport(tcImportOperationsBean.java:1198)
    16 frames
  5. Thor.API.Operations
    tcImportOperationsIntfEJB.performImportx
    1. Thor.API.Operations.tcImportOperationsIntfEJB.performImportx(Unknown Source)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  7. com.bea.core
    ReflectiveMethodInvocation.proceed
    1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
    2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    6 frames
  8. com.oracle.pitchfork
    MethodInvocationVisitorImpl.visit
    1. com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
    1 frame
  9. weblogic.ejb.container
    EnvironmentInterceptorCallbackImpl.callback
    1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
    1 frame
  10. com.oracle.pitchfork
    EnvironmentInterceptor.invoke
    1. com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)
    1 frame
  11. com.bea.core
    JdkDynamicAopProxy.invoke
    1. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    7. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    7 frames
  12. Unknown
    $Proxy425.performImportx
    1. $Proxy425.performImportx(Unknown Source)
    1 frame
  13. Thor.API.Operations
    tcImportOperationsIntf_uawk3z_tcImportOperationsIntfRemoteImpl.__WL_invoke
    1. Thor.API.Operations.tcImportOperationsIntf_uawk3z_tcImportOperationsIntfRemoteImpl.__WL_invoke(Unknown Source)
    1 frame
  14. weblogic.ejb.container
    SessionRemoteMethodInvoker.invoke
    1. weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
    1 frame
  15. Thor.API.Operations
    tcImportOperationsIntf_uawk3z_tcImportOperationsIntfRemoteImpl.performImportx
    1. Thor.API.Operations.tcImportOperationsIntf_uawk3z_tcImportOperationsIntfRemoteImpl.performImportx(Unknown Source)
    1 frame
  16. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  17. weblogic.ejb.container
    RemoteBusinessIntfProxy.invoke
    1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
    1 frame
  18. Unknown
    $Proxy445.performImportx
    1. $Proxy445.performImportx(Unknown Source)
    1 frame
  19. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  20. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
    2 frames
  21. Unknown
    $Proxy446.performImportx
    1. $Proxy446.performImportx(Unknown Source)
    1 frame
  22. Thor.API.Operations
    tcImportOperationsIntfDelegate.performImport
    1. Thor.API.Operations.tcImportOperationsIntfDelegate.performImport(Unknown Source)
    1 frame
  23. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  24. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  25. oracle.iam.platform
    DMSMethodInterceptor.invoke
    1. oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25)
    1 frame
  26. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  27. Unknown
    $Proxy447.performImport
    1. $Proxy447.performImport(Unknown Source)
    1 frame
  28. com.thortech.xl
    ConnectorInstallProcessAction.completeInstallation
    1. com.thortech.xl.webclient.actions.ConnectorInstallProcessAction.importXmlForInstallation(ConnectorInstallProcessAction.java:713)
    2. com.thortech.xl.webclient.actions.ConnectorInstallProcessAction.completeInstallation(ConnectorInstallProcessAction.java:209)
    2 frames
  29. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  30. struts
    DispatchAction.dispatchMethod
    1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
    1 frame
  31. com.thortech.xl
    ConnectorInstallProcessAction.execute
    1. com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(tcLookupDispatchAction.java:133)
    2. com.thortech.xl.webclient.actions.tcActionBase.execute(tcActionBase.java:900)
    3. com.thortech.xl.webclient.actions.tcAction.execute(tcAction.java:213)
    4. com.thortech.xl.webclient.actions.ConnectorInstallProcessAction.execute(ConnectorInstallProcessAction.java:108)
    4 frames
  32. Struts Core
    ActionCommandBase.execute
    1. org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
    2. org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
    3. org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
    3 frames
  33. Commons Chain
    ChainBase.execute
    1. org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
    2. org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
    3. org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
    3 frames
  34. Struts Core
    ComposableRequestProcessor.process
    1. org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
    1 frame
  35. struts
    ActionServlet.doPost
    1. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
    2. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
    2 frames
  36. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  37. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  38. com.thortech.xl
    CSRFFilter.doFilter
    1. com.thortech.xl.webclient.security.CSRFFilter.doFilter(CSRFFilter.java:76)
    1 frame
  39. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  40. oracle.iam.platform
    OIMAuthContextFilter.doFilter
    1. oracle.iam.platform.auth.web.OIMAuthContextFilter.doFilter(OIMAuthContextFilter.java:112)
    1 frame
  41. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  42. oracle.security.jps
    JpsAbsFilter$1.run
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    1 frame
  43. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  44. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
    2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
    3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
    4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
    5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    5 frames
  45. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  46. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
    1 frame
  47. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
    3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    5 frames
  48. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  49. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  50. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    3 frames
  51. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames