org.apache.openjpa.persistence.EntityExistsException: Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]

syncope-user | ernst Developer | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error while starting Syncope with an empty database

    syncope-user | 4 years ago | ernst Developer
    org.apache.openjpa.persistence.EntityExistsException: Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]

    Root Cause Analysis

    1. org.apache.openjpa.persistence.EntityExistsException

      Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]

      at org.apache.openjpa.jdbc.sql.DBDictionary.narrow()
    2. OpenJPA Aggregate Jar
      QueryImpl.executeUpdate
      1. org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4943)
      2. org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4918)
      3. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
      4. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:110)
      5. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:62)
      6. org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:172)
      7. org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1056)
      8. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:867)
      9. org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:904)
      10. org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:598)
      11. org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:377)
      11 frames
    3. org.apache.syncope
      ImportExport.startElement
      1. org.apache.syncope.core.util.ImportExport.startElement(ImportExport.java:277)
      1 frame
    4. Java RT
      SAXParser.parse
      1. com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:501)
      2. com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:179)
      3. com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1343)
      4. com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2755)
      5. com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
      6. com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:511)
      7. com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:808)
      8. com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
      9. com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)
      10. com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
      11. com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
      12. javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
      13. javax.xml.parsers.SAXParser.parse(SAXParser.java:198)
      13 frames
    5. org.apache.syncope
      ContentLoader.load
      1. org.apache.syncope.core.persistence.dao.impl.ContentLoader.loadDefaultContent(ContentLoader.java:177)
      2. org.apache.syncope.core.persistence.dao.impl.ContentLoader.load(ContentLoader.java:81)
      2 frames