Erro na instalação do dspace 7.2 - ORA-00942: table or view does not exist
61 views
Skip to first unread message
Aroldo Rique
Jun 9, 2022, 4:52:44 PM6/9/22
to Dspace Brasil
Pessoal, alguém já instalou o dspace 7.2 no Linux (Suse) e com um banco Oracle em outra máquina?
Estou apanhando aqui no ant fresh_install, dá erro no test_database:
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
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
A conexão com o banco acontece, porque se eu colocar o nome do usuário ou a senha errada, é acusado esse erro.
Antecipadamente agradeço qualquer ajuda!
Att,
Aroldo Rique
Aroldo Rique
Jun 19, 2022, 3:01:39 PM6/19/22
to Dspace Brasil
Pessoal, descobri que o dspace 7.2 não é compatível com o Oracle 2.1. O Tim Donohue, um dos que mantém o dspace, respondeu-me em outro fórum.
Erick Eas
Jun 23, 2022, 9:08:22 AM6/23/22
to DSpace Brasil
Oi Aroldo,
Eu tentei por 3x instalar a versão 7.2 num Debian e depois Ubuntu usando Posgresql mas falhava na ativação da interface frontend. Segui as instruções da página https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace. Isso foi em janeiro/fevereiro. Revisamos tudo. Foi frustrante.
Decidimos então instalar a versão 6.3 que funcionou de primeira.
Abçs, Erick
Aroldo Rique
Jun 23, 2022, 10:56:44 AM6/23/22
to Erick Eas, DSpace Brasil
Aqui conseguimos instalar a versão 7.2.1 no SLES + PostgreSQL. Não participei direto dessa instalação, mas já tá rodando. Perdi muito tempo tentando instalar no Oracle 12.
--
Você recebeu essa mensagem porque está inscrito no grupo "DSpace Brasil" dos Grupos do Google.
Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um e-mail para dspace-brasi...@googlegroups.com.
Para ver essa discussão na Web, acesse https://groups.google.com/d/msgid/dspace-brasil/80db741d-bdc5-43b8-bd51-cfbc93ccedf4n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages