Could you please clarify your steps at DB screen?
(maybe you can record short video?)
On Thu, 2 Apr 2020 at 17:18, Xavier M <xa...@hotmail.com> wrote:
> Hi there,
>
> I was still using OM 5.0.0-M1 and had suddenly an unidentified problem
> connection the Media Server, as if Kurento wasn't loaded. I decided to
> install "from fresh" OM 5.0.0-M3, using Alavaro's tutorial.
>
> All worked fine (I noticed that I had to change Kurento's user) until I
> had to press "Finish". Especially, I checked the DB-configuration (named
> open503, but with another username/password) with the button of the
> web-installer.
>
> A I clicked in "Finish", I received following error (please see below).
> Does anyone know what went wrong?
> Nota Bene: I deleted /opt/open503/ and /opt/omdb.mv.db and installed OM
> 5.0.0-M3 again: and the same happened.
> It seems that there is a problem with a table named open503.configuration
> which would not exist...
>
> Thanks in advance,
> Xavier
>
> -----
>
> L'installation a échoué
>
> <openjpa-3.1.0-rafcec21a1d489dff682a3ce7986fac6a1c80e8e0 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@7ce099e2
> at
> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308)
> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199)
> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962)
> at org.apache.openjpa.kernel.QueryImpl.isInMemory(QueryImpl.java:1028)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:902)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
> at
> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
> at
> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
> at
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:190)
> at
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:197)
> at
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.getString(ConfigurationDao.java:247)
> at
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.reloadCrypt(ConfigurationDao.java:416)
> at
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:317)
> at
> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:285)
> at
> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke(<generated>)
> at
> org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
> at
> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
> at
> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
> at
> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
> at
> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
> at
> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$ffb65391.update(<generated>)
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadConfiguration(ImportInitvalues.java:363)
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:553)
> at
> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:563)
> at
> org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$FastClassByCGLIB$$14cc0e15.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
> at
> org.apache.wicket.proxy.LazyInitProxyFactory$AbstractCGLibInterceptor.intercept(LazyInitProxyFactory.java:364)
> at
> org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$EnhancerByCGLIB$$fc81f545.loadAll(<generated>)
> at
> org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:751)
> at java.base/java.lang.Thread.run(Thread.java:834)
> Caused by: <openjpa-3.1.0-rafcec21a1d489dff682a3ce7986fac6a1c80e8e0 fatal
> general error> org.apache.openjpa.persistence.PersistenceException: Table
> 'open503.configuration' doesn't exist {prepstmnt 1187243401 INSERT INTO
> configuration (deleted, inserted, updated, comment, fromVersion, om_key,
> type, value, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1146,
> state=42S02]
> FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@7ce099e2
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5250)
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146)
> at
> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90)
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:554)
> at
> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:110)
> at
> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61)
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108)
> at
> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81)
> at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757)
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146)
> at
> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:679)
> at
> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146)
> ... 35 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
> 'open503.configuration' doesn't exist {prepstmnt 1187243401 INSERT INTO
> configuration (deleted, inserted, updated, comment, fromVersion, om_key,
> type, value, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1146,
> state=42S02]
> 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:58)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188)
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308)
> at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121)
> ... 47 more
>
>
>
--
WBR
Maxim aka solomax
