Error while starting Syncope with an empty database

[ernst Developer <er...@gmail.com>]

Hi,

Today I run into errors, while starting Syncope 1.1.0-SNAPSHOT, clean build
of today morning. Can somebody help me with these errors?

Regards,
Ernst


======== first error ==========
54  syncopePersistenceUnit  WARN   [main] openjpa.Runtime - An error
occurred while registering a ClassTransformer with PersistenceUnitInfo:
name 'syncopePersistenceUnit', root URL
[file:/opt/syncope/webapps/syncope/WEB-INF/classes]. The error has been
consumed. To see it, set your openjpa.Runtime log level to TRACE. Load-time
class transformation will not be available.

======== second error =========

Jan 21, 2013 4:31:14 AM org.apache.catalina.core.StandardContext
listenerStart
SEVERE: Exception sending context initialized event to listener instance of
class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'springContextInitializer' defined in file
[/opt/syncope/webapps/syncope/WEB-INF/classes/org/apache/syncope/core/init/SpringContextInitializer.class]:
Invocation of init method failed; nested exception is
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(AbstractAutowireCapableBeanFactory.java:1455)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:605)
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:925)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:472)
at
org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: 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.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:318)
at
org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:516)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:392)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at
org.apache.syncope.core.persistence.dao.impl.ContentLoader$$EnhancerByCGLIB$$137dc029.load(<generated>)
at
org.apache.syncope.core.init.SpringContextInitializer.afterPropertiesSet(SpringContextInitializer.java:61)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
... 36 more
Caused by: <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.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4943)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4918)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:110)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:62)
at
org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:172)
at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1056)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:867)
at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:904)
at
org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:598)
at
org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:377)
at
org.apache.syncope.core.util.ImportExport.startElement(ImportExport.java:277)
at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:501)
at
com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:179)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1343)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2755)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:511)
at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:808)
at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
at
com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119)
at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
at
com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
at javax.xml.parsers.SAXParser.parse(SAXParser.java:198)
at
org.apache.syncope.core.persistence.dao.impl.ContentLoader.loadDefaultContent(ContentLoader.java:177)
at
org.apache.syncope.core.persistence.dao.impl.ContentLoader.load(ContentLoader.java:81)
at
org.apache.syncope.core.persistence.dao.impl.ContentLoader$$FastClassByCGLIB$$f39a221d.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
... 42 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: 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.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:59)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1134)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1765)
at
org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:277)
at
org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:168)
... 68 more
Jan 21, 2013 4:31:14 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext

Re: Error while starting Syncope with an empty database

[ernst Developer <er...@gmail.com>]

Hi Francesco,

Thanks a lot for the fast reply.
You are right, I have the <ACT- stuff in my content.xml. Your development
is going too fast for me ;)

Regards,
Ernst



2013/1/21 Francesco Chicchiriccò <il...@apache.org>

>  On 21/01/2013 10:34, ernst Developer wrote:
>
> Hi,
>
>  Today I run into errors, while starting Syncope 1.1.0-SNAPSHOT, clean
> build of today morning. Can somebody help me with these errors?
>
>
> Hi Ernst,
> read my replies below.
>
>
>  ======== first error ==========
>  54  syncopePersistenceUnit  WARN   [main] openjpa.Runtime - An error
> occurred while registering a ClassTransformer with PersistenceUnitInfo:
> name 'syncopePersistenceUnit', root URL [
> file:/opt/syncope/webapps/syncope/WEB-INF/classes]. The error has been
> consumed. To see it, set your openjpa.Runtime log level to TRACE. Load-time
> class transformation will not be available.
>
>
> This is harmless, as reported by OpenJPA at
> http://openjpa.apache.org/integration.html#integrating-with-spring
>
> I have also updated the FAQ list with this:
> https://cwiki.apache.org/confluence/display/SYNCOPE/FAQ
>
>
>   ======== second error =========
>
>  Jan 21, 2013 4:31:14 AM org.apache.catalina.core.StandardContext
> listenerStart
> SEVERE: Exception sending context initialized event to listener instance
> of class org.springframework.web.context.ContextLoaderListener
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'springContextInitializer' defined in file
> [/opt/syncope/webapps/syncope/WEB-INF/classes/org/apache/syncope/core/init/SpringContextInitializer.class]:
> Invocation of init method failed; nested exception is
> 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]
>
>
> This is due to recent modification introduced by SYNCOPE-241.
>
> Basically, you have to remove any entry starting with <ACT... from your
> content.xml and place it in a new file activiticontent.xml
>
> Regards.
>
> --
> Francesco Chicchiriccò
>
> ASF Member, Apache Syncope PMC chair, Apache Cocoon PMC Memberhttp://people.apache.org/~ilgrosso/
>
>

Re: Error while starting Syncope with an empty database

[Francesco Chicchiriccò <il...@apache.org>]

On 21/01/2013 10:34, ernst Developer wrote:
> Hi,
>
> Today I run into errors, while starting Syncope 1.1.0-SNAPSHOT, clean 
> build of today morning. Can somebody help me with these errors?

Hi Ernst,
read my replies below.

> ======== first error ==========
> 54  syncopePersistenceUnit  WARN   [main] openjpa.Runtime - An error 
> occurred while registering a ClassTransformer with 
> PersistenceUnitInfo: name 'syncopePersistenceUnit', root URL 
> [file:/opt/syncope/webapps/syncope/WEB-INF/classes]. The error has 
> been consumed. To see it, set your openjpa.Runtime log level to TRACE. 
> Load-time class transformation will not be available.

This is harmless, as reported by OpenJPA at 
http://openjpa.apache.org/integration.html#integrating-with-spring

I have also updated the FAQ list with this: 
https://cwiki.apache.org/confluence/display/SYNCOPE/FAQ

> ======== second error =========
>
> Jan 21, 2013 4:31:14 AM org.apache.catalina.core.StandardContext 
> listenerStart
> SEVERE: Exception sending context initialized event to listener 
> instance of class org.springframework.web.context.ContextLoaderListener
> org.springframework.beans.factory.BeanCreationException: Error 
> creating bean with name 'springContextInitializer' defined in file 
> [/opt/syncope/webapps/syncope/WEB-INF/classes/org/apache/syncope/core/init/SpringContextInitializer.class]: 
> Invocation of init method failed; nested exception is 
> 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]

This is due to recent modification introduced by SYNCOPE-241.

Basically, you have to remove any entry starting with <ACT... from your 
content.xml and place it in a new file activiticontent.xml

Regards.

-- 
Francesco Chicchiriccò

ASF Member, Apache Syncope PMC chair, Apache Cocoon PMC Member
http://people.apache.org/~ilgrosso/