[Dspace-tech] Problem submitting new item using Oracle

[Brouns, Francis]

Hi,

We are testing Dspace 1.5.2 on an Oracle database. When we try to submit a new item, we receive an internal error after the upload step. We are able to upload files, but the error occurs when moving to the next step.

According to the log file, the sql statements tries to insert values for METS_BITSTREAM_ID in the bundle table. However this column is dropped from the table when running the database_schema_142-15.sql. Earlier it was already confirmed that this field was no longer used. Because we upgraded Oracle from 1.4.2 to 1.5.2 the table bundle no longer contains the field, but somehow the code still does use it.

2010-02-19 11:26:29,672 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query "INSERT INTO BUNDLE ( NAME,METS_BITSTREAM_ID,PRIMARY_BITSTREAM_ID,BUNDLE_ID) VALUES ( ?,?,?,?)"
2010-02-19 11:26:29,673 ERROR org.dspace.app.webui.servlet.SubmissionController @ Error loading step class'org.dspace.submit.step.UploadStep':
java.sql.SQLException: ORA-00904: "METS_BITSTREAM_ID": invalid identifier

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:1355)
at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:666)
at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:420)
at org.dspace.content.Bundle.create(Bundle.java:207)
at org.dspace.content.Item.createBundle(Item.java:1118)
at org.dspace.content.Item.createSingleBitstream(Item.java:1261)
at org.dspace.submit.step.UploadStep.processUploadFile(UploadStep.java:504)
at org.dspace.submit.step.UploadStep.doProcessing(UploadStep.java:170)
at org.dspace.app.webui.submit.JSPStepManager.doStepEnd(JSPStepManager.java:429)
at org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:284)
at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:408)
at org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:344)
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147)
at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595)

Best wishes,
Francis Brouns