Hi Andrea
thanks for the suggestion.
I tried enabling XML Workflow but received the error:
"ERROR: relation "cwf_claimtask" does not exist Position: 15"
I followed the wiki
https://wiki.duraspace.org/display/DSDOC5x/Configurable+Workflow:
Edit:
dspace/config/xmlui.xconf
commenting out:
<aspect name="Original Workflow"
path=
"resource://aspects/Workflow/" />
and uncommenting:
<aspect name="XMLWorkflow"
path=
"resource://aspects/XMLWorkflow/" />
dspace/config/modules/workflow.cfg
commenting:
#workflow.framework: originalworkflow
and uncommenting:
workflow.framework: xmlworkflow
I also migrated the db using:
[dspace]/bin/dspace database migrate
even though a restart of Tomcat is apparently enough with the
xmlworkflow configured in workflow.cfg.
I also ran the Java-based migration. This resulted in:
# /opt/dspace/bin/dspace dsrun
org.dspace.xmlworkflow.migration.RestartWorkflow -e
[email protected]
All workflowitems will be sent back to the first workflow step.
Sending all workflow items back to the workspace
Processing workflow item 0 of 5
Removing pooled tasks
org.postgresql.util.PSQLException: ERROR: syntax error at or
near ")"
Position: 32
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1752)
at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:700)
at
org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:461)
at
org.dspace.xmlworkflow.storedcomponents.XmlWorkflowItem.create(XmlWorkflowItem.java:54)
at
org.dspace.xmlworkflow.XmlWorkflowManager.start(XmlWorkflowManager.java:60)
at
org.dspace.xmlworkflow.XmlWorkflowManager.startWithoutNotify(XmlWorkflowManager.java:111)
at
org.dspace.xmlworkflow.migration.RestartWorkflow.main(RestartWorkflow.java:149)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:226)
at
org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:78)
Thanks
On Sunday, November 26, 2017 at 9:07:59 PM UTC, Andrea Schweer
wrote:
Hi
Hayden,
On 11/26/2017 06:43 AM, Hayden Young wrote:
> It appears that reviewers cannot review past items in
workflow? Is
> this correct behaviour? We have a number of items in
workflow which
> could be addressed by adding new reviewers but this does
not seem
> possible?
This is the standard behaviour for the traditional DSpace
workflow. An
existing task will appear for the new reviewer when someone
else takes
the task, then immediately puts it back into the pool.
If you switch to the configurable workflow then permissions
will be
checked in real time and new reviewers will be able to see
tasks that
existed before they were made a reviewer. Please note, the
configurable
workflow isn't available for JSPUI, and if you currently use
curation
tasks during the workflow then these will probably require
custom code
to still work.
https://wiki.duraspace.org/display/DSDOC6x/Configurable+Workflow
cheers,
Andrea
--
Dr Andrea Schweer
Lead Software Developer, ITS Information Systems
The University of Waikato, Hamilton, New Zealand
+64-7-837 9120
