Hi, It looks like (from your other email thread) the problem is that Oracle 12.1 is no longer supported by Flyway (which DSpace uses). See this response: https://groups.google.com/g/dspace-community/c/kNlhfGFec84/m/f0hBVBJiAgAJ
Again, I'd stress for anyone looking at installing DSpace 7 on Oracle... *Please be aware that Oracle Support is deprecated and will be unsupported in Summer 2023. I'd highly recommend installing DSpace 7 on PostgreSQL*. See https://github.com/DSpace/DSpace/issues/8214 Tim On Tuesday, June 14, 2022 at 1:59:32 PM UTC-5 [email protected] wrote: > Juan, how did you know it was this table that was missing? Did you see > it in any log files? I'm having the same problem and I don't know how to > solve it. > > Em segunda-feira, 18 de outubro de 2021 às 04:08:00 UTC-3, Juan García > García escreveu: > >> 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/3d5bbb0d-5253-4d29-850f-ce6cfd526397n%40googlegroups.com.
