oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access. ORA-01400: cannot insert NULL into ("EPMREP"."SNP_CONNECT_PROP"."PROP_KEY")

Oracle Community | Kimi | 7 months ago
  1. 0

    ODI Agent Failed

    Oracle Community | 7 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")
  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

    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")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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")
  6. 0

    OIM Connector Installation Error

    Oracle Community | 3 years ago | 871346
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OIM.OIMHOME_JARS_UNIQUE) violated
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-01400: cannot insert NULL into ("EPMREP"."SNP_CONNECT_PROP"."PROP_KEY")

    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. EclipseLink (non-OSGi)
    EntityTransactionImpl.commit
    1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:831)
    2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906)
    3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592)
    4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
    5. org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
    6. org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
    7. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
    8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
    9. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:236)
    10. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:216)
    11. org.eclipse.persistence.internal.queries.StatementQueryMechanism.executeNoSelect(StatementQueryMechanism.java:115)
    12. org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:85)
    13. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
    14. org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
    15. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
    16. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
    17. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
    18. org.eclipse.persistence.mappings.DirectCollectionMapping.performDataModificationEvent(DirectCollectionMapping.java:2080)
    19. org.eclipse.persistence.mappings.DirectMapMapping.performDataModificationEvent(DirectMapMapping.java:611)
    20. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:157)
    21. org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799)
    22. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415)
    23. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:636)
    24. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1505)
    25. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:267)
    26. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1143)
    27. org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:84)
    28. org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
    28 frames
  5. oracle.odi.core
    JpaOdiTransactionManager.doCommit
    1. oracle.odi.core.persistence.jpa.JpaOdiTransactionManager.doCommit(JpaOdiTransactionManager.java:365)
    1 frame
  6. Spring Tx
    AbstractPlatformTransactionManager.commit
    1. org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
    2. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
    2 frames
  7. oracle.odi.core
    TransactionTemplate.execute
    1. oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.commit(TransactionManagerSpringAdapter.java:66)
    2. oracle.odi.core.persistence.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:112)
    2 frames
  8. oracle.odi.repex
    EntityInstanceBean.entityInstanceUpdated
    1. oracle.odi.repex.model.utils.OdiUtils.mergeOdiEntity(OdiUtils.java:79)
    2. oracle.odi.repex.model.utils.OdiUtils.mergeOdiEntity(OdiUtils.java:72)
    3. oracle.odi.repex.view.browser.topology.dataserver.DataServerBean.updateEntityInstance(DataServerBean.java:636)
    4. oracle.odi.repex.view.common.beans.EntityInstanceBean.entityInstanceUpdated(EntityInstanceBean.java:51)
    4 frames
  9. 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
  10. EL
    MethodExpressionImpl.invoke
    1. com.sun.el.parser.AstValue.invoke(AstValue.java:187)
    2. com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
    2 frames
  11. org.apache.myfaces
    MethodExpressionMethodBinding.invoke
    1. org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)
    1 frame
  12. Apache MyFaces Trinidad API
    UIXCommand.broadcast
    1. org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodBinding(UIXComponentBase.java:1433)
    2. org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:183)
    2 frames
  13. oracle.adf.view
    UIXInclude.broadcast
    1. oracle.adf.view.rich.component.fragment.UIXRegion.broadcast(UIXRegion.java:181)
    2. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:92)
    3. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:361)
    4. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:96)
    5. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:103)
    6. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:92)
    7. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:361)
    8. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:96)
    9. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:97)
    9 frames
  14. oracle.adfinternal.view
    LifecycleImpl.execute
    1. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.broadcastEvents(LifecycleImpl.java:1100)
    2. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:446)
    3. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:219)
    3 frames
  15. JavaEE 7
    FacesServlet.service
    1. javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
    1 frame
  16. 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
  17. oracle.adfinternal.view
    RegistrationFilter.doFilter
    1. oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:128)
    1 frame
  18. org.apache.myfaces
    TrinidadFilterImpl$FilterListChain.doFilter
    1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
    1 frame
  19. oracle.adfinternal.view
    AdsFilter.doFilter
    1. oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
    1 frame
  20. org.apache.myfaces
    TrinidadFilterImpl.doFilter
    1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
    2. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)
    3. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)
    3 frames
  21. Apache MyFaces Trinidad API
    TrinidadFilter.doFilter
    1. org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
    1 frame
  22. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  23. oracle.adf.model
    ADFBindingFilter.doFilter
    1. oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:211)
    1 frame
  24. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  25. oracle.odi.repex
    AuthMustFilter.doFilterInternal
    1. oracle.odi.repex.view.main.auth.AuthMustFilter.doFilterInternal(AuthMustFilter.java:47)
    1 frame
  26. Spring
    OncePerRequestFilter.doFilter
    1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    1 frame
  27. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  28. oracle.odi.repex
    ThreadAuthFilter.doFilterInternal
    1. oracle.odi.repex.view.main.auth.ThreadAuthFilter.doFilterInternal(ThreadAuthFilter.java:38)
    1 frame
  29. Spring
    OncePerRequestFilter.doFilter
    1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    1 frame
  30. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  31. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    2. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
    3. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
    4. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
    5. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
    6. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    6 frames
  32. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  33. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
    1 frame
  34. 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
  35. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  36. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  37. 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
  38. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames