org.springframework.dao.DataIntegrityViolationException: Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]; nested exception is <openjpa-2.2.1-r422266:1396819 fatal store error> 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
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Error while starting Syncope with an empty database

    syncope-user | 4 years ago | ernst Developer
    org.springframework.dao.DataIntegrityViolationException: Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]; nested exception is <openjpa-2.2.1-r422266:1396819 fatal store error> 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.springframework.dao.DataIntegrityViolationException

      Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]; nested exception is <openjpa-2.2.1-r422266:1396819 fatal store error> 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.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean()
    2. Spring Beans
      DefaultListableBeanFactory.preInstantiateSingletons
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455)
      2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
      3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
      4. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
      5. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
      6. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
      7. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
      8. org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:605)
      8 frames
    3. Spring Context
      AbstractApplicationContext.refresh
      1. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:925)
      2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:472)
      2 frames
    4. Spring
      ContextLoaderListener.contextInitialized
      1. org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)
      2. org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
      3. org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
      3 frames
    5. Glassfish Core
      Catalina.start
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
      2. org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
      3. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
      4. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
      5. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
      6. org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
      7. org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
      8. org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
      9. org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
      10. org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
      11. org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
      12. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
      13. org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
      14. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      15. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
      16. org.apache.catalina.core.StandardService.start(StandardService.java:525)
      17. org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
      18. org.apache.catalina.startup.Catalina.start(Catalina.java:595)
      18 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    7. Glassfish Core
      Bootstrap.main
      1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
      2 frames