Please do not cross-post This is question for user@ list, no need to write to dev@
There is no screenshot in your email But according to stack trace you are using derby DB So you most probably hit this issue: https://issues.apache.org/jira/browse/OPENMEETINGS-1675 Workaround described here: http://markmail.org/message/frglho6bnbevp7lx On Fri, Aug 25, 2017 at 5:07 PM, Alexey Pakhomov <[email protected]> wrote: > Hello! > > I have some problem with OM 3.3.0. On first step I configured DB > connection (see screenshot). And on last step I get error (see screenshot). > > > > Stacktrace: > Ошибка установки > > 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.4.2-r422266:1777108 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. > > at > org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418) > > at > org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122) > > at > org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521) > > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) > > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) > > at > org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:504) > > at > org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292) > > at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) > > at > org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656) > > at > org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$eceb7dd6.addGlobalStructure(<generated>) > > at > org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:131) > > at > org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:517) > > at > org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:533) > > at > org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:755) > > at java.lang.Thread.run(Thread.java:745) > > Caused by: <openjpa-2.4.2-r422266:1777108 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. > > at > org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2368) > > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205) > > at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103) > > at > org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021) > > at > org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) > > at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526) > > at > org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932) > > at > org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571) > > at > org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517) > > ... 13 more > > Caused by: <openjpa-2.4.2-r422266:1777108 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Schema 'USER' does not > exist {INSERT INTO naviglobal (comment, deleted, icon, inserted, label_id, > level_id, name, naviorder, tooltip_label_id, updated) VALUES (?, ?, ?, ?, ?, > ?, ?, ?, ?, ?)} [code=20000, state=42Y07] > > at > org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5003) > > at > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4963) > > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133) > > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:107) > > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59) > > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) > > 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:104) > > at > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77) > > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731) > > at > org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) > > at > org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668) > > at > org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) > > ... 21 more > > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Schema 'USER' > does not exist {INSERT INTO naviglobal (comment, deleted, icon, inserted, > label_id, level_id, name, naviorder, tooltip_label_id, updated) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, state=42Y07] > > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218) > > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:198) > > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:58) > > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:250) > > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > > at > org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:139) > > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133) > > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1642) > > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122) > > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:290) > > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:113) > > 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) > > ... 30 more > > > > > > > > > -- WBR Maxim aka solomax
