Thanks for the input, I appreciate the help!! I got that error when I was trying to install OpenMeetins with Derby after a few unsuccessful tries installing with a remote MySQL (Actually MariaDB)
I deleted the installation and reinstalled OpenMeetings. I was able to successfully install with Derby, but not with the MySQL install. So I have a couple of questions: The MySQL install fails because I'm using MariaDB (I use it with several projects never an issue) ? Or does the MySQL install fail because it's a remote Data Base ? Thanks for the help!!! Carlos -----Original Message----- From: Maxim Solodovnik [mailto:[email protected]] Sent: Friday, August 12, 2016 2:13 PM To: Openmeetings user-list <[email protected]>; [email protected] Subject: Re: installing openmeetins on windows 10 According to your error: Schema 'CARLOS' does not exist you haven't created database On Sat, Aug 13, 2016 at 1:09 AM, Coscend@OM <[email protected]> wrote: > Dear Carlos, > > > > Assuming you have not done any customization in DB, and navigation > files of OM application, you might want to check your persistence.xml > in “webapps/openmeetings/WEB-INF/classes/META-INF/” folder. > > > > Is it the right *.xml file, does it have the correct username, and > correct 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 > > > > From: Carlos Cruz [mailto:[email protected]] > Sent: Friday, August 12, 2016 8:14 AM > To: [email protected] > Subject: installing openmeetins on windows 10 > > > > Can someone tell me why I get the error bellow during openmeeting setup? > > > > I have Java 1.7 JDK (7) installed. > > > > Thanks! > > Carlos > > 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 > error> transaction > has been rolled back. See the nested exceptions for details on the > errors that occurred. > > at > org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccess > ExceptionIfPossible(EntityManagerFactoryUtils.java:415) > > at > org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPoss > ible(DefaultJpaDialect.java:122) > > at > org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransact > ionManager.java:521) > > at > org.springframework.transaction.support.AbstractPlatformTransactionMan > ager.processCommit(AbstractPlatformTransactionManager.java:757) > > at > org.springframework.transaction.support.AbstractPlatformTransactionMan > ager.commit(AbstractPlatformTransactionManager.java:726) > > at > org.springframework.transaction.interceptor.TransactionAspectSupport.c > ommitTransactionAfterReturning(TransactionAspectSupport.java:521) > > at > org.springframework.transaction.interceptor.TransactionAspectSupport.i > nvokeWithinTransaction(TransactionAspectSupport.java:291) > > at > org.springframework.transaction.interceptor.TransactionInterceptor.inv > oke(TransactionInterceptor.java:96) > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R > eflectiveMethodInvocation.java:179) > > at > org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedIntercep > tor.intercept(CglibAopProxy.java:653) > > at > org.apache.openmeetings.db.dao.basic.NavigationDao$$EnhancerBySpringCG > LIB$$481ea8e4.addGlobalStructure(<generated>) > > at > org.apache.openmeetings.installation.ImportInitvalues.loadMainMenu(Imp > ortInitvalues.java:117) > > at > org.apache.openmeetings.installation.ImportInitvalues.loadSystem(Impor > tInitvalues.java:607) > > at > org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportIn > itvalues.java:626) > > at > org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess > .run(InstallWizard.java:641) > > 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(LocalManagedRunti > me.java:81) > > at > org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526) > > at > org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.jav > a:932) > > at > org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerI > mpl.java:571) > > at > org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransact > ionManager.java:517) > > ... 13 more > > Caused by: <openjpa-2.4.1-r422266:1730418 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Schema 'CARLOS' > does not exist {INSERT INTO naviglobal (action, comment, deleted, > icon, inserted, isleaf, isopen, 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(DBDictionar > y.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(Prep > aredStatementManagerImpl.java:90) > > at > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(Constrain > tUpdateManager.java:550) > > at > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(Constrain > tUpdateManager.java:106) > > at > org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(B > atchingConstraintUpdateManager.java:59) > > at > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpd > ateManager.java:104) > > at > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpd > ateManager.java:77) > > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager > .java:731) > > at > org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStore > Manager.java:131) > > at > org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStor > eManager.java:668) > > at > org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStore > Manager.java:131) > > ... 21 more > > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Schema > 'CARLOS' does not exist {INSERT INTO naviglobal (action, comment, > deleted, icon, inserted, isleaf, isopen, label_id, level_id, name, > naviorder, tooltip_label_id, updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?)} [code=20000, state=42Y07] > > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCon > nectionDecorator.java:218) > > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCon > nectionDecorator.java:198) > > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(Logg > ingConnectionDecorator.java:58) > > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnecti > on.prepareStatement(LoggingConnectionDecorator.java:250) > > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(Dele > gatingConnection.java:133) > > at > org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$Configuring > Connection.prepareStatement(ConfiguringConnectionDecorator.java:139) > > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(Dele > gatingConnection.java:133) > > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.pre > pareStatement(JDBCStoreManager.java:1642) > > at > org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(Dele > gatingConnection.java:122) > > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareSta > tement(PreparedStatementManagerImpl.java:290) > > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUp > date(PreparedStatementManagerImpl.java:113) > > at > org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.fl > ushAndUpdate(BatchingPreparedStatementManagerImpl.java:79) > > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInter > nal(PreparedStatementManagerImpl.java:100) > > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(Prep > aredStatementManagerImpl.java:88) > > ... 30 more > > > > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2016.0.7752 / Virus Database: 4633/12797 - Release Date: > 08/12/16 -- WBR Maxim aka solomax
