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
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
