[ 
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

Reply via email to