java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CSFINTSTG"."PUBLISHEDASSETS"."ASSETDATE")

Oracle Community | Gerardo Rodriguez | 2 years ago
  1. 0

    Translation issue in static publication

    Oracle Community | 2 years ago | Gerardo Rodriguez
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CSFINTSTG"."PUBLISHEDASSETS"."ASSETDATE")
  2. 0

    Translation error in static publication

    GitHub | 2 years ago | GerardoRodriguezVisus
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CSFINTSTG"."PUBLISHEDASSETS"."ASSETDATE")
  3. 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")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

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

    Problems with HibernateUtil exceptions handling

    GitHub | 3 years ago | jgambarios
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DOTCMS.USERS_CMS_ROLES1_UNIQUE) violated

  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 ("CSFINTSTG"."PUBLISHEDASSETS"."ASSETDATE")

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    T4CTTIoer.processError
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)[...]
    2 frames
  3. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    1 frame
  4. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame