[ http://jira.dspace.org/jira/browse/DS-630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=11608#action_11608 ]
Claudia Jürgen commented on DS-630: ----------------------------------- Hello Vernedal, this seems more like an incomplete update to me (although I'm not using oracle). Did you by any chance upgraded your DSpace instance from 1.4* or lower to 1.6*. And if so did you run all the database upgrade scripts in between the versions? The METS_BITSTREAM_ID column was dropped from the bundle table, see [dspace-source]/dspace/etc/oracle/database_schema_142-15.sql Hope that helps Claudia Jürgen > During submit process, after upload file i have this error : > java.sql.SQLException: ORA-00904: "METS_BITSTREAM_ID" : invalid identifier > --------------------------------------------------------------------------------------------------------------------------------------- > > Key: DS-630 > URL: http://jira.dspace.org/jira/browse/DS-630 > Project: DSpace 1.x > Issue Type: Bug > Components: JSPUI > Affects Versions: 1.6.0, 1.6.2 > Environment: Windows server 2003 - Oracle 10g > Reporter: Vernedal > Original Estimate: 2 weeks > Remaining Estimate: 2 weeks > > During submit process, after upload file i have this error : > java.sql.SQLException: ORA-00904: "METS_BITSTREAM_ID" : invalid identifier > 2010-07-21 10:03:21,406 ERROR > org.dspace.app.webui.servlet.SubmissionController @ Error loading step > class'org.dspace.submit.step.UploadStep': > java.sql.SQLException: ORA-00904: "METS_BITSTREAM_ID" : identificateur non > valide > 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:745) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454) > 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:1429) > at > org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:736) > at > org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:490) > at org.dspace.content.Bundle.create(Bundle.java:206) > at org.dspace.content.Item.createBundle(Item.java:1244) > at org.dspace.content.Item.createSingleBitstream(Item.java:1387) > at > org.dspace.submit.step.UploadStep.processUploadFile(UploadStep.java:505) > at org.dspace.submit.step.UploadStep.doProcessing(UploadStep.java:168) > 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:709) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868) > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) > at java.lang.Thread.run(Thread.java:595) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.dspace.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d _______________________________________________ Dspace-devel mailing list Dspace-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-devel