[Dspace-tech] "Unfinished Submissions" problem

[Carlos Walter Blandon Alvarez]

Good day.

We are experimenting sending items to our DSPACE and we have a problem.

In step to approve the license, then to click on the "accept license" button, get a message that says "The system has experienced an internal error. Please try again, and if the problem persists, please contact with us to fix it.".

If I go to "My DSpace", the item previously sent is, with its own file, but says it's as "Shipping without end"

DSPACE version 1.8.2. It's a new instalation

--

Walter Blandón
Analista Técnico
Centro Cultural Biblioteca "Luis Echavarría Villegas"
Tel: (57) (4) 2619500, extensión 9365
E-mail: cbla...@eafit.edu.co
Universidad EAFIT, Medellín, Colombia

[helix84]

On Thu, Aug 2, 2012 at 12:34 AM, Carlos Walter Blandon Alvarez
<cbla...@eafit.edu.co> wrote:
> button, get a message that says "The system has experienced an internal
> error. Please try again, and if the problem persists, please contact with us
> to fix it.".

Hi Carlos,

this is a generic error message, we'll need the details from your log files.

This guide helps you locate errors in log files:
https://wiki.duraspace.org/display/DSPACE/Troubleshoot+an+error

Send any errors detailed in the log files to this list (along with the
full error stack trace). They may help us to figure out what the issue
may be.

> If I go to "My DSpace", the item previously sent is, with its own file, but
> says it's as "Shipping without end"
> DSPACE version 1.8.2. It's a new instalation

This seems like a reverse translation from your language to English.
Please, configure your browser to prefer English and send us the
actual English message. (something like "Unfinished submissions"?)

Regards,
~~helix84

[Carlos Walter Blandon Alvarez]

Hi helix.

I offer my apologies for the translation, but I do not know what happened to the previous post, I had corrected the English texts are in DSPACE.

It is the error in DSPACE/log:

2012-08-02 09:06:08,936 ERROR org.dspace.submit.step.CompleteStep @ Caught exception in submission step:
java.sql.SQLException: bad_dublin_core schema=dc, description provenance
        at org.dspace.content.Item.update(Item.java:1580)
        at org.dspace.workflow.WorkflowManager.recordStart(WorkflowManager.java:1140)
        at org.dspace.workflow.WorkflowManager.start(WorkflowManager.java:158)
        at org.dspace.submit.step.CompleteStep.doProcessing(CompleteStep.java:96)
        at org.dspace.app.webui.submit.JSPStepManager.doStepStart(JSPStepManager.java:301)
        at org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:246)
        at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:382)
        at org.dspace.app.webui.servlet.SubmissionController.doNextStep(SubmissionController.java:452)
        at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:398)
        at org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:318)
        at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)
        at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
2012-08-02 09:06:08,938 ERROR org.dspace.app.webui.servlet.SubmissionController @ Error loading step class'org.dspace.submit.step.CompleteStep':
javax.servlet.ServletException: java.sql.SQLException: bad_dublin_core schema=dc, description provenance
        at org.dspace.submit.step.CompleteStep.doProcessing(CompleteStep.java:103)
        at org.dspace.app.webui.submit.JSPStepManager.doStepStart(JSPStepManager.java:301)
        at org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:246)
        at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:382)
        at org.dspace.app.webui.servlet.SubmissionController.doNextStep(SubmissionController.java:452)
        at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:398)
        at org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:318)
        at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)
        at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: bad_dublin_core schema=dc, description provenance
        at org.dspace.content.Item.update(Item.java:1580)
        at org.dspace.workflow.WorkflowManager.recordStart(WorkflowManager.java:1140)
        at org.dspace.workflow.WorkflowManager.start(WorkflowManager.java:158)
        at org.dspace.submit.step.CompleteStep.doProcessing(CompleteStep.java:96)
        ... 32 more

In Tomcat log does not appear any error.

Regards,

Walter Blandón

El 08/02/12, helix84 <hel...@centrum.sk> escribió:

--

[helix84]

On Thu, Aug 2, 2012 at 4:20 PM, Carlos Walter Blandon Alvarez
<cbla...@eafit.edu.co> wrote:
> I offer my apologies for the translation, but I do not know what happened to
> the previous post, I had corrected the English texts are in DSPACE.

I'm sorry, I didn't understand what you just said.

> 2012-08-02 09:06:08,936 ERROR org.dspace.submit.step.CompleteStep @ Caught
> exception in submission step:
> java.sql.SQLException: bad_dublin_core schema=dc, description provenance

This are the relevant source lines:
https://github.com/DSpace/DSpace/blob/dspace-1_8_x/dspace-api/src/main/java/org/dspace/content/Item.java#L1564

It looks like you don't have the dc.description.provenance field
defined for some reason. This is a standard field used by DSpace to
store provenance data and should not be remove. Perhaps you removed it
accidentally?

1) Check if it's really missing:

SELECT * FROM metadatafieldregistry WHERE qualifier = 'provenance'

2) If it's missing, re-create it:

INSERT INTO "metadatafieldregistry" ("metadata_field_id",
"metadata_schema_id", "element", "qualifier", "scope_note") VALUES
(28, 1, 'description', 'provenance', 'The history of custody of the
item since its creation, including any changes successive custodians
made to it.');


Let us know whether it helped.

Regards,
~~helix84

[Carlos Walter Blandon Alvarez]

Hi helix.

 

I reviewed and we don't have the dc.description.provenance field.

 

I ran the INSERT query, I checked again and the problem was resolved.

 

But we have other problem in "Workflow Process"

 

When I click in "Perform this task" button and then click in "Approve" button in "Perform Task" section, again appears:

"The system has experienced an internal error. Please try to do what you were doing again, and if the problem persists, please contact us so we can fix the problem."

This is DSPACE log:

 

2012-08-03 09:06:54,341 WARN  org.dspace.content.Item @ cbla...@eafit.edu.co:session_id=B86C222E54191898FB995119CAA66DD8:ip_addr=200.12.176.57:bad_dc:Bad DC field. schema=dc, element\colon; "date" qualifier\colon; "accessioned" value\colon; "2012-08-03T14\colon;06\colon;54Z"

2012-08-03 09:06:54,341 WARN  org.dspace.app.webui.servlet.DSpaceServlet @ cbla...@eafit.edu.co:session_id=B86C222E54191898FB995119CAA66DD8:ip_addr=200.12.176.57:database_error:java.sql.SQLException\colon; bad_dublin_core schema=dc, date accessioned

java.sql.SQLException: bad_dublin_core schema=dc, date accessioned

        at org.dspace.content.Item.update(Item.java:1580)

        at org.dspace.content.InstallItem.finishItem(InstallItem.java:228)

        at org.dspace.content.InstallItem.installItem(InstallItem.java:83)

        at org.dspace.content.InstallItem.installItem(InstallItem.java:42)

        at org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:701)

        at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:651)

        at org.dspace.workflow.WorkflowManager.advance(WorkflowManager.java:414)

        at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:629)

        at org.dspace.workflow.WorkflowManager.advance(WorkflowManager.java:405)

        at org.dspace.workflow.WorkflowManager.advance(WorkflowManager.java:334)

        at org.dspace.app.webui.servlet.MyDSpaceServlet.processPerformTask(MyDSpaceServlet.java:429)

        at org.dspace.app.webui.servlet.MyDSpaceServlet.doDSPost(MyDSpaceServlet.java:109)

Regards,

Walter Blandón

El 08/02/12, helix84 <hel...@centrum.sk> escribió:

On Thu, Aug 2, 2012 at 4:20 PM, Carlos Walter Blandon Alvarez

--