Hi Boby, I'd recommend looking to see if any additional error messages are logged in your DSpace logs, or maybe your Oracle logs. Oracle seems to be saying some table is missing ( java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ) . But, in the message you sent, it doesn't say which table is missing -- which makes it harder to debug this issue. Sometimes a missing table is a bug in our code, but other times, it might simply be a permission or connection issue with the database. If you can find additional errors, it could help to send them to this list to allow us to narrow down the issue.
I will also note that most DSpace development occurs on PostgreSQL these days. Unfortunately, our volunteer dev team no longer includes Oracle experts. But, that said, if there are Oracle specific issues with the installation, we'll obviously work to get them resolved. For additional troubleshooting tips for DSpace 7, see https://wiki.lyrasis.org/display/DSPACE/Troubleshoot+an+error#Troubleshootanerror-DSpace7.x(orabove) Tim On Wednesday, August 25, 2021 at 7:52:00 PM UTC-5 [email protected] wrote: > > Hello, > > I'm trying to install DSpace 7 with Oracle database(different machine). > I have some problem when i try to execute : ant fresh_install, i had some > error like this : > > Buildfile: /opt/DSpace-7.0/dspace/target/dspace-installer/build.xml > > init_installation: > > prepare_configs: > [mkdir] Created dir: > /opt/DSpace-7.0/dspace/target/dspace-installer/config-temp > [copy] Copying 185 files to > /opt/DSpace-7.0/dspace/target/dspace-installer/config-temp > [copy] Copying 1 file to > /opt/DSpace-7.0/dspace/target/dspace-installer/config-temp > [copy] Copying 14 files to > /opt/DSpace-7.0/dspace/target/dspace-installer/config-temp > > init_configs: > [copy] Copying 1 file to > /opt/DSpace-7.0/dspace/target/dspace-installer/opt/DSpace-7.0/build/config > [delete] Deleting directory > /opt/DSpace-7.0/dspace/target/dspace-installer/config-temp > > test_database: > [java] 2021-08-26 07:05:47,492 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:808) > > ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1279) > > ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) > > ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] > [java] at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) > > ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] > [java] at > org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1114) > > ~[spring-context-5.2.5.RELEASE.jar:5.2.5.RELEASE] > [java] at > org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) > > [dspace-services-7.0.jar:7.0] > [java] at > org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:33) > > [dspace-api-7.0.jar:7.0] > [java] at > org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) > [dspace-api-7.0.jar:7.0] > [java] at > org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) > [dspace-api-7.0.jar:7.0] > [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:1377) > [java] at > org.dspace.storage.rdbms.FlywayUpgradeUtils.upgradeFlywayTable(FlywayUpgradeUtils.java:83) > [java] at > org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:111) > [java] at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > [java] at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > [java] at > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > [java] at > java.base/java.lang.reflect.Method.invoke(Method.java:566) > [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] 2021-08-26 07:05:48,628 WARN > org.dspace.services.sessions.StatelessRequestServiceImpl @ Request > interceptor > (org.dspace.services.events.SystemEventService$EventRequestInterceptor@29bbd7b8) > > failed to execute on end (request-60-1629936347516): null > > BUILD FAILED > /opt/DSpace-7.0/dspace/target/dspace-installer/build.xml:770: Java > returned: 1 > > Is something wrong ? What should i check..? > > Thank you, > Boby > -- 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/5ae9e101-4da1-46d8-97b3-3376055d5716n%40googlegroups.com.
