Hello Daniel,
What DB are you using? Is it mysql?
According to error log database with name KAM270 does not exist.
have you created it with CREATE DATABASE .... query (please don't
forget to set UTF-8 encoding while DB creating)
On Sun, Sep 11, 2016 at 3:58 PM, Daniel Baker
<i...@collisiondetection.biz> wrote:
> Hi Hemant,
>
> I copied over the mysql-connector-java-5.1.39-bin.jar into
> ~webapps/OM_CONTEXT/WEB-INF/lib
>
>
> I checked the derby persistence.xml file it has the correct url, username,
> and password details.
>
>
> The progress bar on the last step moved across about 25% then gave another
> error :
>
> I have not made any other changes to the database.
>
> OpenMeetings
> OpenMeetings
> 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.4.1-r422266:1730418 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:485)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
> 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:655)
> at
> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$8d335b5b.addGlobalStructure(<generated>)
>
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
> 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:642)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: <openjpa-2.4.1-r422266:1730418 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.1-r422266:1730418 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: Schema 'KAM270' 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
> 'KAM270' 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
>
>
>
>
>
>
> On 09/11/2016 03:13 PM, Coscend@OM wrote:
>>
>> Hello Daniel,
>>
>> "See the nested exceptions for details on the errors that occurred.;
>> nested exception is <openjpa-2.4.1-r422266:1730418 fatal general error>
>> ...
>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Schema
>> 'KAM270' 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]"
>>
>> Have you made any changes to the database schema?
>>
>> Two other pointers to check:
>> 1. Copy mysql-connector-java-5.1.39-bin.jar in
>> ~webapps/OM_CONTEXT/WEB-INF/lib
>> 2. choose right persistence.xml file
>> url: Database name
>> Username
>> password
>>
>> Thank you.
>>
>> Sincerely,
>>
>> Hemant K. Sabat
>>
>> Coscend Communications Solutions
>> Web site: www.Coscend.com
>> ------------------------------------------------------------------
>> CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail
>> Messages from Coscend Communications Solutions' posted at:
>> http://www.Coscend.com/Terms_and_Conditions.html
>>
>>
>>
>> -----Original Message-----
>> From: Daniel Baker [mailto:i...@collisiondetection.biz]
>> Sent: Sunday, September 11, 2016 3:06 AM
>> To: user@openmeetings.apache.org
>> Subject: error installing 3.1.2 on ubuntu
>>
>> Hi, I am trying to install openmeetings 3.1.2 on Ubuntu 14.04
>>
>> I am using the red5.sh script.
>>
>> I get the following error at the last stage of the install:
>>
>>
>>
>>
>>
>>
>>
>> OpenMeetings
>> OpenMeetings
>> 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.4.1-r422266:1730418 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:485)
>> at
>>
>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
>> 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:655)
>> at
>>
>> org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCGLIB$$41d64e21.addGlobalStructure(<generated>)
>> at
>>
>> org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(ImportInitvalues.java:118)
>> 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:642)
>> at java.lang.Thread.run(Thread.java:745)
>> Caused by: <openjpa-2.4.1-r422266:1730418 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.1-r422266:1730418 fatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Schema 'KAM270'
>> 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
>> 'KAM270' 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
>>
>>
>> Any ideas how to solve this much appreciated.
>>
>>
>> Thanks,
>>
>>
>> Dan
>>
>>
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 2016.0.7752 / Virus Database: 4649/12992 - Release Date: 09/11/16
>>
>>
>>
>
--
WBR
Maxim aka solomax
