org.postgresql.util.PSQLException: ERROR: null value in column "approvedby" violates not-null constraint Detail: Failing row contains (7, mmc2, /site/components/headers/global-header.xml, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null).

Google Groups | michae_mmc | 1 year ago
  1. 0

    Errors creating a new site

    Google Groups | 1 year ago | michae_mmc
    org.postgresql.util.PSQLException: ERROR: null value in column "approvedby" violates not-null constraint Detail: Failing row contains (7, mmc2, /site/components/headers/global-header.xml, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null).
  2. 0

    GitHub comment 52#151558461

    GitHub | 1 year ago | ghsnd
    org.springframework.dao.DataIntegrityViolationException: A different object with the same identifier value was already associated with the session : [eu.freme.common.persistence.model.Template#1]; nested exception is javax.persistence.EntityExistsException: A different object with the same identifier value was already associated with the session : [eu.freme.common.persistence.model.Template#9]
  3. 0

    StdTextProductDao: Error storing text product

    GitHub | 8 months ago | mjames-upc
    org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into stdTextProducts (bbbid, insertTime, product, refTime, cccid, dataCrc, hdrtime, nnnid, site, wmoid, xxxid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Removing an entity and create new one with same primary key

    Stack Overflow | 11 months ago | Dmitry Shipaev
    org.springframework.dao.DataIntegrityViolationException: A different object with the same identifier value was already associated with the session : [com.test.core.model.subsubentity.SubSubEntity#3440120160113000103]; nested exception is javax.persistence.EntityExistsException: A different object with the same identifier value was already associated with the session : [com.test.core.model.subsubentity.SubSubEntity#3440120160113000103]

    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. org.springframework.dao.DataIntegrityViolationException

      ------------ My next step was to create a new site without a blueprint : This appears to succeed however not completely The error stack is included below: 1. The crafter database is not being updated 2. The java code complained about file systems and doesn't create the folders 3. Solr index : site is not added 3. The site folders are successfully created in Alfresco. tail -f /opt/crafter/apache-tomcat/logs/catalina.out

      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run()
    2. Grizzly HTTP
      JIoEndpoint$SocketProcessor.run
      1. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
      1 frame
    3. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      2 frames
    4. Tomcat Util
      TaskThread$WrappingRunnable.run
      1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      1 frame
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame