Hi. I have encountered the same problem. I am migrating from version 1.7.2 to 7. The Oracle error is because the "schema_version" table does not exist: SELECT version FROM schema_version ORDER BY version desc I have assumed that Flyway creates the table the first time it is run, but it doesn't seem to. My database schema does not contain that table, should I create it?
On Thursday, August 26, 2021 at 6:44:38 PM UTC+2 Tim Donohue wrote: > 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/33739851-b495-46ae-8972-cfaeab931a6an%40googlegroups.com.
