java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("OIM"."UD_ADUSRC"."UD_ADUSER_KEY")

Oracle Community | Pallavi Chaudhari | 5 years ago
  1. 0

    AD child table insert

    Oracle Community | 5 years ago | Pallavi Chaudhari
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("OIM"."UD_ADUSRC"."UD_ADUSER_KEY")
  2. 0

    This error can occur when the group is set as lowercase in Crowd when actually the original group in LDAP is uppercase. {code} caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.crowd.embedded.hibernate2.HibernateMembership#188383471]; SQL []; ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110) caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) 2012-12-18 15:07:49,153 INFO [TP-Processor14] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] updateGroups Deleted user "user1"'s imported membership of remote group "group1" to directory "Delegated Authentication Directory". 2012-12-18 15:07:49,158 INFO [TP-Processor14] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] importMembership Imported user "user1"'s membership of remote group "group1" to directory "Delegated Authentication Directory". 2012-12-18 15:07:49,162 ERROR [TP-Processor14] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated {code} Workaround: 1) Compare the groups in your Crowd with the groups in your LDAP to find out which are different (lowercase instead of uppercase). 2) Remove the users from all these groups. 3) Use GUI or SQL to remove the lowercase groups from the DB. 4) Perform a Flush - Administration->Cache Statistics->Flush All 5) Try to login with using a user that was inside on of this groups. 6) RESTART Confluence Application

    Atlassian JIRA | 4 years ago | Bruna Griebeler [Atlassian]
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated
  3. 0

    Problems with HibernateUtil exceptions handling

    GitHub | 3 years ago | jgambarios
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DOTCMS.USERS_CMS_ROLES1_UNIQUE) violated
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    startSQLRepository error in data importing

    Oracle Community | 3 years ago | 1005719
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("ATGUSER"."CRS_PRODUCT"."ASSET_VERSION") **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog **** Error Sun Jun 23 22:12:00 IST 2013 1372005720063 /atg/commerce/catalog/ProductCatalog
  6. 0

    item-descriptor related fail on deployment

    Oracle Community | 3 years ago | antback
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PRODUCTION"."SHOP_PILL"."ACTIONBUTTON_ID")

  1. Michael 1 times, last 4 months ago
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 ("OIM"."UD_ADUSRC"."UD_ADUSER_KEY")

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    T4CTTIoer.processError
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
    1 frame