What DB are you using? (MySQL, Postrges etc.)
have you specified correct database name in persistence.xml file? (is it
for the right DB?)
According to stacktrace you were installing using web installer and it
fails to create default values, really weird :(
On 4 June 2014 18:49, Alexei Fedotov <alexei.fedo...@gmail.com> wrote:
> >> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data
> truncation: Data too long for column 'conf_value' at row 1 {prepstmnt
> 515643217 INSERT INTO configuration (comment_field, conf_key, conf_value,
> deleted, starttime, updatetime, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)}
> [code=1406, state=22001]
>
> It seems upgrade didn't work as expected for your version
> --
> With best regards / с наилучшими пожеланиями,
> Alexei Fedotov / Алексей Федотов,
> http://dataved.ru/
> +7 916 562 8095
>
> [1] Start using Apache Openmeetings today, http://openmeetings.apache.org/
> [2] Join Alexei Fedotov @linkedin, http://ru.linkedin.com/in/dataved/
> [3] Join Alexei Fedotov @facebook, http://www.facebook.com/openmeetings
>
>
> On Wed, Jun 4, 2014 at 3:43 PM, [heureka] Ulrich Huber
> <ulrich.hu...@heureka.co.at> wrote:
> > I was following the guide @ http://openmeetings.apache.org/Upgrade.html;
> > upgrade was recommended by maxim in order to address the
> generatingURL/mail
> > invitation-issue.
> >
> >
> >
> > At the end of the installation process, I got an error@
> > /openmeetings/install?6 (I dumped the databases and created a new one,
> > following the recommendations in the upgrade-guide…)
> >
> >
> >
> > Installation is failed
> >
> > org.springframework.orm.jpa.JpaSystemException: The transaction has been
> > rolled back. See the nested exceptions for details on the errors that
> > occurred.; nested exception is <openjpa-2.2.2-r422266:1468616 fatal
> general
> > error> org.apache.openjpa.persistence.PersistenceException: The
> transaction
> > has been rolled back. See the nested exceptions for details on the
> errors
> > that occurred.
> >
> > FailedObject:
> org.apache.openmeetings.db.entity.basic.Configuration@286a0559
> >
> > at
> >
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:326)
> >
> > 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:393)
> >
> > 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.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerByCGLIB$$fcc723cb.add(<generated>)
> >
> > at
> >
> org.apache.openmeetings.installation.ImportInitvalues.loadConfiguration(ImportInitvalues.java:365)
> >
> > at
> >
> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:985)
> >
> > at
> >
> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:997)
> >
> > at
> >
> org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:389)
> >
> > at java.lang.Thread.run(Thread.java:662)
> >
> > Caused by: <openjpa-2.2.2-r422266:1468616 fatal general error>
> > org.apache.openjpa.persistence.PersistenceException: The transaction has
> > been rolled back. See the nested exceptions for details on the errors
> that
> > occurred.
> >
> > FailedObject:
> org.apache.openmeetings.db.entity.basic.Configuration@286a0559
> >
> > at
> >
> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2347)
> >
> > at
> org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2184)
> >
> > at
> > org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2082)
> >
> > at
> >
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2000)
> >
> > at
> >
> org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
> >
> > at
> org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1524)
> >
> > at
> >
> org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
> >
> > at
> >
> org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
> >
> > at
> >
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512)
> >
> > ... 12 more
> >
> > Caused by: <openjpa-2.2.2-r422266:1468616 fatal general error>
> > org.apache.openjpa.persistence.PersistenceException: Data truncation:
> Data
> > too long for column 'conf_value' at row 1 {prepstmnt 515643217 INSERT
> INTO
> > configuration (comment_field, conf_key, conf_value, deleted, starttime,
> > updatetime, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)} [code=1406,
> state=22001]
> >
> > FailedObject:
> org.apache.openmeetings.db.entity.basic.Configuration@286a0559
> >
> > at
> > org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4962)
> >
> > at
> >
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4922)
> >
> > at
> >
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
> >
> > at
> > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:144)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:105)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:78)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:732)
> >
> > at
> >
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> >
> > at
> >
> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:661)
> >
> > at
> >
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> >
> > ... 20 more
> >
> > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data
> > truncation: Data too long for column 'conf_value' at row 1 {prepstmnt
> > 515643217 INSERT INTO configuration (comment_field, conf_key, conf_value,
> > deleted, starttime, updatetime, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)}
> > [code=1406, state=22001]
> >
> > 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:275)
> >
> > at
> >
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:268)
> >
> > at
> >
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:119)
> >
> > ... 32 more
> >
> >
> >
> >
> >
> > Any idea?
>
--
WBR
Maxim aka solomax
