Hi Juan, Flyway should create that database table for you automatically (when you run the "dspace database migrate" command).
If it is not doing so, there may be some other error occurring...perhaps check the DSpace logs or Oracle logs for any additional errors that occur when you run "dspace database migrate". Let us know on this list if you need further help, Tim ________________________________ From: [email protected] <[email protected]> on behalf of Juan García García <[email protected]> Sent: Thursday, October 7, 2021 5:30 AM To: DSpace Community <[email protected]> Subject: [dspace-community] Re: Error ORA-00942: table or view does not exist 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 a topic in the Google Groups "DSpace Community" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/dspace-community/49rxpRujdwk/unsubscribe. To unsubscribe from this group and all its topics, send an email to [email protected]<mailto:[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<https://groups.google.com/d/msgid/dspace-community/33739851-b495-46ae-8972-cfaeab931a6an%40googlegroups.com?utm_medium=email&utm_source=footer>. -- 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/DM5PR2201MB1148A67AA43C039E14A9655FEDBC9%40DM5PR2201MB1148.namprd22.prod.outlook.com.
