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 | 2 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Errors creating a new site

    Google Groups | 2 years 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).

    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