Error installing dspace 7.2 - table or view does not exist
133 views
Skip to first unread message
Aroldo Rique
Jun 8, 2022, 5:59:08 PM6/8/22
to DSpace Community
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.xml
init_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-temp
init_configs:
[copy] Copying 1 file to /dspace/config
[delete] Deleting directory /data/dspace-src-backend/dspace/target/dspace-installer/config-temp
test_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 null
BUILD FAILED
/data/dspace-src-backend/dspace/target/dspace-installer/build.xml:770: Java returned: 1
init_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-temp
init_configs:
[copy] Copying 1 file to /dspace/config
[delete] Deleting directory /data/dspace-src-backend/dspace/target/dspace-installer/config-temp
test_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 null
BUILD 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
Aroldo Rique
Jun 14, 2022, 4:59:07 PM6/14/22
to DSpace Community
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
[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
Tim Donohue
Jun 15, 2022, 11:12:19 AM6/15/22
to DSpace Community
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
Aroldo Rique
Jun 15, 2022, 2:01:15 PM6/15/22
to DSpace Community
Tim, thank you very much for the reply. Our company also has Oracle 19c. Do you know if Flyway is compatible with Oracle 19c?
Tim Donohue
Jun 17, 2022, 9:57:45 AM6/17/22
to DSpace Community
Hi,
According to Flyway documentation they support Oracle 12.2, 18.3 and 19.3. https://flywaydb.org/documentation/database/oracle
Again though, I would stress that if this is a new installation, I'd recommend using PostgreSQL instead of Oracle, because DSpace doesn't plan to support Oracle much longer: https://github.com/DSpace/DSpace/issues/8214 (In mid 2023, we plan to remove all Oracle specific code from DSpace which means you will be locked into the last version of DSpace which had Oracle specific code.)
Tim
Reply all
Reply to author
Forward
0 new messages