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