[
https://issues.apache.org/jira/browse/OPENMEETINGS-1410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maxim Solodovnik closed OPENMEETINGS-1410.
------------------------------------------
> Om failed to install using Oracle
> ---------------------------------
>
> Key: OPENMEETINGS-1410
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-1410
> Project: Openmeetings
> Issue Type: Bug
> Components: BuildsAndReleases
> Affects Versions: 3.1.1
> Reporter: Maxim Solodovnik
> Assignee: Maxim Solodovnik
> Fix For: 3.1.2, 3.2.0, 4.0.0
>
>
> According to user list:
> Hi.
> I'm trying to install openmeetings on Oracle (through command line admin, but
> I have problems. Any ideas would be appreciated.
> First I had this exception:
> Caused by: org.apache.openjpa.persistence.PersistenceException: ORA-00904: :
> invalid identifier
> {stmnt 251155815 CREATE TABLE appointment (id NUMBER NOT NULL,
> is_connected_event NUMBER, deleted NUMBER, description CLOB, end TIMESTAMP,
> icalId VARCHAR2(255), inserted TIMESTAMP, isdaily NUMBER, ismonthly NUMBER,
> isweekly NUMBER, isyearly NUMBER, language_id NUMBER, location VARCHAR2(255),
> password VARCHAR2(255), is_password_protected NUMBER, reminder VARCHAR2(20),
> is_reminder_email_send NUMBER, start TIMESTAMP, appointmentname
> VARCHAR2(255), updated TIMESTAMP, user_id NUMBER, room_id NUMBER, PRIMARY KEY
> (id))} [code=904, state=42000]
> ...
> I tried to run the create command on sql developer (directly on oracle) and I
> had the same error. It turns out that the error was caused by the start
> TIMESTAMP column. The word "start" is reserved by oracle and needs special
> treatment. So I ran the command through sql developer using "START" TIMESTAMP
> (with the ") and the table was created. I ran again the admin command line
> and it seemed to have created the DB.
> Unfortunately, it crashes later on with the stacktrace shown at the end of
> the mail. It seems to have something to do with the Naviglobal entity. Any
> ideas?
> {code}
> 2016-05-26 10:56:04,134 [main] ERROR org.apache.openmeetings.cli.Admin -
> Install failed
> org.springframework.orm.jpa.JpaSystemException: 10; nested exception is
> <openjpa-2.4.1-r422266:1730418 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: 10
> 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$$b65241b9.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.cli.Admin.process(Admin.java:278)
> at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
> Caused by: org.apache.openjpa.persistence.PersistenceException: 10
> at
> org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2029)
> 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 common frames omitted
> Caused by: java.lang.ArrayIndexOutOfBoundsException: 10
> at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
> at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
> at
> oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:1212)
> at
> oracle.jdbc.driver.T4CPreparedStatement.<init>(T4CPreparedStatement.java:28)
> at
> oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
> at
> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3140)
> at
> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
> at
> oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:6022)
> at
> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
> at
> org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:807)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:450)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:517)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:448)
> at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:441)
> at
> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:288)
> 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)
> 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)
> 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)
> ... 18 common frames omitted
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
