Tim, thank you very much for the reply. Our company also has Oracle 19c. Do you know if Flyway is compatible with Oracle 19c?
Em quarta-feira, 15 de junho de 2022 às 12:12:19 UTC-3, Tim Donohue escreveu: > Hi, > > It looks like one of those log lines gives you the answer... see this > message: > > "*Flyway Enterprise Edition or Oracle upgrade required: Oracle 12.1 is no > longer supported by Flyway Community Edition, but still supported by Flyway > Enterprise Edition.'"* > > It sounds like Flyway Community Edition (which DSpace 7 relies on) no > longer supports Oracle 12.1. So, you'd have to upgrade Oracle. > > Please keep in mind we are dropping support for Oracle as of Summer 2023. > So if this is a new install, I'd **high recommend** using PostgreSQL > instead. See this announcement: > https://github.com/DSpace/DSpace/issues/8214 > > Tim > > On Tuesday, June 14, 2022 at 3:59:07 PM UTC-5 [email protected] wrote: > >> Another part of the log in debug mode: >> >> >> >> >> >> >> >> >> >> >> >> >> >> *[java] 2022-06-14 17:06:59,609 DEBUG org.flywaydb.core.Flyway @ Memory >> usage: 66 of 146M [java] 2022-06-14 17:06:59,609 INFO >> org.dspace.storage.rdbms.FlywayUpgradeUtils @ Flyway table >> 'schema_version' appears to be outdated. Will attempt to upgrade it >> automatically. Flyway Exception was >> 'org.flywaydb.core.internal.license.FlywayEditionUpgradeRequiredException: >> Flyway Enterprise Edition or Oracle upgrade required: Oracle 12.1 is no >> longer supported by Flyway Community Edition, but still supported by Flyway >> Enterprise Edition.' [java] 2022-06-14 17:06:59,611 DEBUG >> org.apache.http.impl.conn.PoolingHttpClientConnectionManager @ Closing >> expired connections [java] 2022-06-14 17:06:59,612 DEBUG >> org.apache.http.impl.conn.PoolingHttpClientConnectionManager @ Closing >> connections idle longer than 30 SECONDS [java] 2022-06-14 17:06:59,620 >> DEBUG org.springframework.context.support.ClassPathXmlApplicationContext @ >> Closing >> org.springframework.context.support.ClassPathXmlApplicationContext@3ffb3598, >> started on Tue Jun 14 17:06:56 BRT 2022 [java] 2022-06-14 17:06:59,644 >> INFO org.dspace.services.caching.CachingServiceImpl @ destroy() [java] >> 2022-06-14 17:06:59,646 INFO >> org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Shutting >> down EhCache CacheManager 'org.dspace.services' [java] 2022-06-14 >> 17:06:59,646 DEBUG net.sf.ehcache.CacheManager @ CacheManager already >> shutdown [java] 2022-06-14 17:06:59,646 INFO >> org.dspace.services.sessions.StatelessRequestServiceImpl @ shutdown >> [java] 2022-06-14 17:06:59,647 DEBUG >> org.dspace.services.caching.CachingServiceImpl @ instantiateMapCache(String >> eventQueueCache) [java] 2022-06-14 17:06:59,647 WARN >> org.dspace.services.sessions.StatelessRequestServiceImpl @ Request >> interceptor >> (org.dspace.services.events.SystemEventService$EventRequestInterceptor@6b01558a) >> >> failed to execute on end (request-440-1655237218986): Cannot invoke >> "org.dspace.services.model.Cache.getKeys()" because "queueCache" is null >> [java] 2022-06-14 17:06:59,651 INFO >> org.dspace.servicemanager.DSpaceServiceManager @ DSpace service manager is >> shut down. [java] 2022-06-14 17:06:59,651 INFO >> org.dspace.servicemanager.DSpaceKernelImpl @ DSpace kernel shutdown >> completed and unregistered MBean: >> org.dspace:name=2daf4d2d-028f-4a30-a681-8febdbc98984,type=DSpaceKernel* >> >> Em quarta-feira, 8 de junho de 2022 às 18:59:08 UTC-3, Aroldo Rique >> escreveu: >> >>> Hello everybody. >>> >>> I'm trying to install *dspace 7.2* with Oracle client on another >>> machine. When I run the command >>> dspace@dspace/data/dspace-src-backend/dspace/target/dspace-installer> ant >>> fresh_install, the following *database error* occurs: >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> *Buildfile: >>> /data/dspace-src-backend/dspace/target/dspace-installer/build.xmlinit_installation:prepare_configs: >>> >>> [mkdir] Created dir: >>> /data/dspace-src-backend/dspace/target/dspace-installer/config-temp >>> [copy] Copying 193 files to >>> /data/dspace-src-backend/dspace/target/dspace-installer/config-temp >>> [copy] Copying 1 file to >>> /data/dspace-src-backend/dspace/target/dspace-installer/config-temp >>> [copy] Copying 14 files to >>> /data/dspace-src-backend/dspace/target/dspace-installer/config-tempinit_configs: >>> >>> [copy] Copying 1 file to /dspace/config [delete] Deleting directory >>> /data/dspace-src-backend/dspace/target/dspace-installer/config-temptest_database: >>> >>> [java] 2022-06-08 18:44:49,681 WARN >>> org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by >>> name or id=database. Will try to look up bean by type next. [java] >>> org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean >>> named 'database' available [java] at >>> org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:816) >>> >>> ~[spring-beans-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>> org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1288) >>> >>> ~[spring-beans-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) >>> >>> ~[spring-beans-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) >>> >>> ~[spring-beans-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>> org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1115) >>> >>> ~[spring-context-5.2.20.RELEASE.jar:5.2.20.RELEASE] [java] at >>> org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) >>> >>> [dspace-services-7.2.1.jar:7.2.1] [java] at >>> org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:33) >>> >>> [dspace-api-7.2.1.jar:7.2.1] [java] at >>> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) >>> >>> [dspace-api-7.2.1.jar:7.2.1] [java] at >>> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) >>> [dspace-api-7.2.1.jar:7.2.1] [java] Caught exception: [java] >>> java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist >>> [java] [java] at >>> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) [java] >>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) >>> [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) >>> [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) >>> [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) >>> [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) >>> [java] at >>> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) >>> >>> [java] at >>> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) >>> >>> [java] at >>> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) >>> >>> [java] at >>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) >>> >>> [java] at >>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) >>> >>> [java] at >>> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) >>> >>> [java] at >>> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) >>> >>> [java] at >>> org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) >>> >>> [java] at >>> org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) >>> >>> [java] at >>> org.dspace.storage.rdbms.DatabaseUtils.getCurrentFlywayState(DatabaseUtils.java:1414) >>> >>> [java] at >>> org.dspace.storage.rdbms.FlywayUpgradeUtils.upgradeFlywayTable(FlywayUpgradeUtils.java:83) >>> >>> [java] at >>> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:112) >>> [java] at >>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native >>> Method) [java] at >>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) >>> >>> [java] at >>> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> >>> [java] at >>> java.base/java.lang.reflect.Method.invoke(Method.java:568) [java] >>> at >>> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:277) >>> >>> [java] at >>> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:133) >>> >>> [java] at >>> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) >>> [java] 2022-06-08 18:44:50,182 WARN >>> org.dspace.services.sessions.StatelessRequestServiceImpl @ Request >>> interceptor >>> (org.dspace.services.events.SystemEventService$EventRequestInterceptor@22848820) >>> >>> failed to execute on end (request-16-1654724689695): Cannot invoke >>> "org.dspace.services.model.Cache.getKeys()" because "queueCache" is >>> nullBUILD >>> FAILED/data/dspace-src-backend/dspace/target/dspace-installer/build.xml:770: >>> >>> Java returned: 1* >>> >>> Has anyone had this problem and managed to solve it? Thanks in advance >>> for any help. >>> >>> Aroldo Rique >>> Recife/Brasil >>> >> -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/5b32094e-b9a0-4ab6-a547-2bbd6796e7d1n%40googlegroups.com.
