Error ORA-00942: table or view does not exist

[boby saputra‏]

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

[Tim Donohue‏]

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

[Juan García García‏]

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?

[Tim Donohue‏]

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: dspace-c...@googlegroups.com <dspace-c...@googlegroups.com> on behalf of Juan García García <jua...@gmail.com>
Sent: Thursday, October 7, 2021 5:30 AM
To: DSpace Community <dspace-c...@googlegroups.com>
Subject: [dspace-community] Re: Error ORA-00942: table or view does not exist

 

--
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 dspace-communi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/33739851-b495-46ae-8972-cfaeab931a6an%40googlegroups.com.

[Aroldo Rique‏]

Hello Boby!

I'm having the same problem as you. Could you solve it?

Aroldo Rique

Recife/Brasil

[Aroldo Rique‏]

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.

[DSpace Community‏]

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