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/60efb2a6-d20c-4fc3-b166-9dfd92043c14n%40googlegroups.com.
