Error installing dspace 7.2 - java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
55 views
Skip to first unread message
Aroldo Rique
Jun 8, 2022, 6:06:26 PM6/8/22
to dspac...@googlegroups.com
I'm installing dspace 7.2 backend on Suse with an Oracle server on another machine.
After the ant fresh_install command, the following database error occurs:
After the ant fresh_install command, the following database error occurs:
dspace@dspace:/data/dspace-src-backend/dspace/target/dspace-installer> ant fresh_install
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
Total time: 5 seconds
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
Total time: 5 seconds
Has anyone had this problem and managed to solve it?
Thanks in advance for any help.
Thanks in advance for any help.
Aroldo Rique
Recife/Brasil
Aroldo Rique
Jun 14, 2022, 4:59:30 PM6/14/22
to DSpace Technical Support
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:37:48 AM6/15/22
to DSpace Technical Support
This was answered on the dspace-community mailing list (in the same message posted there): https://groups.google.com/g/dspace-community/c/kNlhfGFec84/m/f0hBVBJiAgAJ
Reply all
Reply to author
Forward
0 new messages