Dear Tim,
Thank you for your quick response and explanation. It is good to know the
migration went well.
The next thing to look at is the item submission and workflow
configurations. According to the upgrade guide I did:
[dspace]/bin/dspace submission-forms-migrate -s
[dspace]/config/temp/item-submission.xml -f
[dspace]/config/temp/input-forms.xml
The "migrated" files are attached. If I leave the default workflow.xml, in
the UI I cannot submit a new item with the message "You have not the
privilege to make a new submission." Also, if an admin user goes to
"Administer workflow", the message "Error fetching search results" appears.
In 6.3 we used to have a simple "single reviewer" workflow and admins for
each collection (the old workflow-dspace63.xml is also attached). As you
can see, I am a little bit confused :)
Ti, thank you once again for considering our migration issues.
Kind regards
Milos
среда, 15. март 2023. у 17:23:08 UTC+1 Tim Donohue је написао/ла:
> Hi Milos,
>
> The "Out of Order" response from your migration scripts means that the
> migration was *successful* but it ran out-of-order. So, this is expected
> output after an upgrade.
>
> It's unclear to me why you are attempting to restart the workflow? Is
> there an error you are seeing in the UI?
>
> You should only need to run "dspace database migrate ignored" and then all
> your workflow tasks should migrate successfully. Based on what you've
> shared so far, it sounds like that process worked as expected. So, I don't
> think you need to run the "RestartWorkflow" command at all, unless I'm
> misunderstanding the issue you are hitting.
>
> Tim
>
> On Tuesday, March 14, 2023 at 7:58:02 AM UTC-5 [email protected] wrote:
>
>> Dear All,
>>
>> Thanks to this support group, I have (almost) successfully migrated the
>> 6.3 deployment to 7.5. Regarding the basic functionality, the only missing
>> element is the workflow. Upon executing
>>
>> bin/dspace database migrate ignored
>>
>> I have:
>>
>> | Versioned | 5.0.2014.11.04 | Enable XMLWorkflow Migration
>> | JDBC | 2023-03-12 16:33:44 | Out of Order |
>> | Versioned | 6.0.2015.09.01 | DS 2701 Enable XMLWorkflow Migration
>> | JDBC | 2023-03-12 16:33:44 | Out of Order |
>>
>> I found some older threads on this and similar issues, but still not sure
>> what the correct approach is. When trying:
>>
>> bin/dspace dsrun org.dspace.xmlworkflow.migration.RestartWorkflow -e admin
>> @myrespository.org
>>
>> I get the following error:
>>
>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> unique constraint "cwf_workflowitem_item_id_key"
>> Detail: Key (item_id)=(ba7ffb7a-7fa0-4b8b-84bb-68dfef778620) already
>> exists.
>>
>> Any hint?
>>
>> Kind regards
>> Milos
>>
>>
--
All messages to this mailing list should adhere to the Code of Conduct:
https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/899c0d5c-f4aa-43fa-8d0b-62341b220d2fn%40googlegroups.com.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE input-forms
SYSTEM "submission-forms.dtd">
<input-forms><form-definitions><form name="traditionalpage1"><row><field>
<dc-schema>dc</dc-schema>
<dc-element>type</dc-element>
<dc-qualifier/>
<repeatable>true</repeatable>
<label>Type</label>
<input-type value-pairs-name="common_types">dropdown</input-type>
<hint>Select the type(s) of content of the item. To select more than one value in the list, you may have to hold down the "CTRL" or "Shift" key.</hint>
<required>You must select a type for this item.</required>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>title</dc-element>
<dc-qualifier/>
<repeatable>false</repeatable>
<label>Title</label>
<input-type>onebox</input-type>
<hint>Enter the main title of the item.</hint>
<required>You must enter a main title for this item.</required>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>title</dc-element>
<dc-qualifier>alternative</dc-qualifier>
<repeatable>true</repeatable>
<label>Other Titles</label>
<input-type>onebox</input-type>
<hint>If the item has any alternative titles, please enter them here.</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>date</dc-element>
<dc-qualifier>issued</dc-qualifier>
<repeatable>false</repeatable>
<label>Date of Issue</label>
<input-type>date</input-type>
<hint>Please give the date of previous publication or public distribution.
You can leave out the day and/or month if they aren't
applicable.</hint>
<required>You must enter at least the year.</required>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>publisher</dc-element>
<dc-qualifier/>
<repeatable>false</repeatable>
<label>Publisher</label>
<input-type>onebox</input-type>
<hint>Enter the name of the publisher of the previously issued instance of this item.</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>identifier</dc-element>
<dc-qualifier>citation</dc-qualifier>
<repeatable>false</repeatable>
<label>Citation</label>
<input-type>onebox</input-type>
<hint>Enter the standard citation for the previously issued instance of this item.</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>contributor</dc-element>
<dc-qualifier>author</dc-qualifier>
<repeatable>true</repeatable>
<label>Authors</label>
<input-type>name</input-type>
<hint>Enter the names of the authors of this item.</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>relation</dc-element>
<dc-qualifier>ispartof</dc-qualifier>
<repeatable>false</repeatable>
<label>Journal</label>
<input-type>onebox</input-type>
<hint>Enter the name of the journal where the item has been published, if any.</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>description</dc-element>
<dc-qualifier>uri</dc-qualifier>
<repeatable>true</repeatable>
<label>Primary research data</label>
<input-type>onebox</input-type>
<hint>Enter the URL.</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>identifier</dc-element>
<dc-qualifier>issn</dc-qualifier>
<repeatable>false</repeatable>
<label>ISSN</label>
<input-type>onebox</input-type>
<hint>Enter the ISSN number in valid format xxxx-xxxx</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>identifier</dc-element>
<dc-qualifier>isbn</dc-qualifier>
<repeatable>false</repeatable>
<label>ISBN</label>
<input-type>onebox</input-type>
<hint>Enter the ISBN number</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>identifier</dc-element>
<dc-qualifier>doi</dc-qualifier>
<repeatable>false</repeatable>
<label>DOI</label>
<input-type>onebox</input-type>
<hint>Enter the DOI number</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>identifier</dc-element>
<dc-qualifier>scopus</dc-qualifier>
<repeatable>false</repeatable>
<label>SCOPUS</label>
<input-type>onebox</input-type>
<hint>Enter the SCOPUS number</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>identifier</dc-element>
<dc-qualifier>wos</dc-qualifier>
<repeatable>false</repeatable>
<label>WOS</label>
<input-type>onebox</input-type>
<hint>Enter the WOS number</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>type</dc-element>
<dc-qualifier>version</dc-qualifier>
<repeatable>false</repeatable>
<label>Version</label>
<input-type value-pairs-name="type_versions">dropdown</input-type>
<hint> Select the publication's version.</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>description</dc-element>
<dc-qualifier>version</dc-qualifier>
<repeatable>false</repeatable>
<label>Status</label>
<input-type value-pairs-name="publication_status">dropdown</input-type>
<hint> Select the publication's status.</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>language</dc-element>
<dc-qualifier>iso</dc-qualifier>
<repeatable>false</repeatable>
<label>Language</label>
<input-type value-pairs-name="common_iso_languages">dropdown</input-type>
<hint>Select the language of the main content of the item. If the language does not appear in the list, please select 'Other'. If the content does not really have a language (for example, if it is a dataset or an image) please select 'N/A'.</hint>
<required/>
</field></row><row><field><dc-schema>dc</dc-schema><dc-element>subject</dc-element><dc-qualifier/><repeatable>true</repeatable><label>Subject Keywords</label><input-type>onebox</input-type><hint>Enter appropriate subject keywords or phrases. </hint><required/><vocabulary>srsc</vocabulary></field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>description</dc-element>
<dc-qualifier>abstract</dc-qualifier>
<repeatable>false</repeatable>
<label>Abstract</label>
<input-type>textarea</input-type>
<hint>Enter the abstract of the item. </hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>description</dc-element>
<dc-qualifier>sponsorship</dc-qualifier>
<repeatable>false</repeatable>
<label>Sponsors</label>
<input-type>textarea</input-type>
<hint>Enter the names of any sponsors and/or funding codes in the box. </hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>relation</dc-element>
<dc-qualifier>conference</dc-qualifier>
<repeatable>true</repeatable>
<label>Conference</label>
<input-type>onebox</input-type>
<hint> Enter the name of the conference where the item has been presented, if any.</hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>relation</dc-element>
<repeatable>true</repeatable>
<label>Project</label>
<input-type>onebox</input-type>
<hint> Enter the name of project, if any, that has produced this publication. </hint>
<required/>
</field></row><row><field>
<dc-schema>dc</dc-schema>
<dc-element>description</dc-element>
<dc-qualifier/>
<repeatable>false</repeatable>
<label>Description</label>
<input-type>textarea</input-type>
<hint>Enter any other description or comments in this box. </hint>
<required/>
</field></row></form><form name="onepage1"><row><field>
<dc-schema>dc</dc-schema>
<dc-element>contributor</dc-element>
<dc-qualifier>author</dc-qualifier>
<repeatable>true</repeatable>
<label>One: Authors</label>
<input-type>name</input-type>
<hint>Enter the names of the authors of this item.</hint>
<required/>
</field></row></form><form name="bitstream-metadata"><row><field><dc-schema>dc</dc-schema><dc-element>title</dc-element><dc-qualifier/><repeatable>false</repeatable><label>Title</label><input-type>onebox</input-type><hint>Enter the name of the file.</hint><required>You must enter a main title for this item.</required></field></row><row><field><dc-schema>dc</dc-schema><dc-element>description</dc-element><repeatable>true</repeatable><label>Description</label><input-type>textarea</input-type><hint>Enter a description for the file</hint><required/></field></row></form></form-definitions><form-value-pairs>
<value-pairs value-pairs-name="common_identifiers" dc-term="identifier">
<pair>
<displayed-value>ISSN</displayed-value>
<stored-value>issn</stored-value>
</pair>
<pair>
<displayed-value>Other</displayed-value>
<stored-value>other</stored-value>
</pair>
<pair>
<displayed-value>ISMN</displayed-value>
<stored-value>ismn</stored-value>
</pair>
<pair>
<displayed-value>Gov't Doc #</displayed-value>
<stored-value>govdoc</stored-value>
</pair>
<pair>
<displayed-value>URI</displayed-value>
<stored-value>uri</stored-value>
</pair>
<pair>
<displayed-value>ISBN</displayed-value>
<stored-value>isbn</stored-value>
</pair>
</value-pairs>
<value-pairs value-pairs-name="common_types" dc-term="type">
<pair>
<displayed-value>article</displayed-value>
<stored-value>article</stored-value>
</pair>
<pair>
<displayed-value>bachelorThesis</displayed-value>
<stored-value>bachelorThesis</stored-value>
</pair>
<pair>
<displayed-value>masterThesis</displayed-value>
<stored-value>masterThesis</stored-value>
</pair>
<pair>
<displayed-value>doctoralThesis</displayed-value>
<stored-value>doctoralThesis</stored-value>
</pair>
<pair>
<displayed-value>book</displayed-value>
<stored-value>book</stored-value>
</pair>
<pair>
<displayed-value>bookPart</displayed-value>
<stored-value>bookPart</stored-value>
</pair>
<pair>
<displayed-value>review</displayed-value>
<stored-value>review</stored-value>
</pair>
<pair>
<displayed-value>conferenceObject</displayed-value>
<stored-value>conferenceObject</stored-value>
</pair>
<pair>
<displayed-value>lecture</displayed-value>
<stored-value>lecture</stored-value>
</pair>
<pair>
<displayed-value>workingPaper</displayed-value>
<stored-value>workingPaper</stored-value>
</pair>
<pair>
<displayed-value>preprint</displayed-value>
<stored-value>preprint</stored-value>
</pair>
<pair>
<displayed-value>report</displayed-value>
<stored-value>report</stored-value>
</pair>
<pair>
<displayed-value>annotation</displayed-value>
<stored-value>annotation</stored-value>
</pair>
<pair>
<displayed-value>contributionToPeriodical</displayed-value>
<stored-value>contributionToPeriodical</stored-value>
</pair>
<pair>
<displayed-value>patent</displayed-value>
<stored-value>patent</stored-value>
</pair>
<pair>
<displayed-value>other</displayed-value>
<stored-value>other</stored-value>
</pair>
</value-pairs>
<!-- default language order: (from dspace 1.2.1)
"en_US", "en", "es", "de", "fr", "it", "ja", "zh", "other", ""
-->
<value-pairs value-pairs-name="common_iso_languages" dc-term="language_iso">
<pair>
<displayed-value>N/A</displayed-value>
<stored-value/>
</pair>
<pair>
<displayed-value>English (United States)</displayed-value>
<stored-value>en_US</stored-value>
</pair>
<pair>
<displayed-value>English</displayed-value>
<stored-value>en</stored-value>
</pair>
<pair>
<displayed-value>Spanish</displayed-value>
<stored-value>es</stored-value>
</pair>
<pair>
<displayed-value>German</displayed-value>
<stored-value>de</stored-value>
</pair>
<pair>
<displayed-value>French</displayed-value>
<stored-value>fr</stored-value>
</pair>
<pair>
<displayed-value>Italian</displayed-value>
<stored-value>it</stored-value>
</pair>
<pair>
<displayed-value>Japanese</displayed-value>
<stored-value>ja</stored-value>
</pair>
<pair>
<displayed-value>Chinese</displayed-value>
<stored-value>zh</stored-value>
</pair>
<pair>
<displayed-value>Turkish</displayed-value>
<stored-value>tr</stored-value>
</pair>
<pair>
<displayed-value>Serbian</displayed-value>
<stored-value>sr</stored-value>
</pair>
<pair>
<displayed-value>Russian</displayed-value>
<stored-value>ru</stored-value>
</pair>
<pair>
<displayed-value>Hungarian</displayed-value>
<stored-value>hu</stored-value>
</pair>
<pair>
<displayed-value>Romanian</displayed-value>
<stored-value>ro</stored-value>
</pair>
<pair>
<displayed-value>Ruthenian</displayed-value>
<stored-value>ru</stored-value>
</pair>
<pair>
<displayed-value>(Other)</displayed-value>
<stored-value>other</stored-value>
</pair>
</value-pairs>
<value-pairs value-pairs-name="publication_status" dc-term="description">
<pair>
<displayed-value>N/A</displayed-value>
<stored-value/>
</pair>
<pair>
<displayed-value>Author's version</displayed-value>
<stored-value>Author's version</stored-value>
</pair>
<pair>
<displayed-value>Accepted for publishing</displayed-value>
<stored-value>Accepted for publishing</stored-value>
</pair>
<pair>
<displayed-value>Published</displayed-value>
<stored-value>Published</stored-value>
</pair>
</value-pairs>
<value-pairs value-pairs-name="type_versions" dc-term="description">
<pair>
<displayed-value>N/A</displayed-value>
<stored-value/>
</pair>
<pair>
<displayed-value>Published version</displayed-value>
<stored-value>PublishedVersion</stored-value>
</pair>
<pair>
<displayed-value>Working version</displayed-value>
<stored-value>WorkingVersion</stored-value>
</pair>
<pair>
<displayed-value>Unreviewed version</displayed-value>
<stored-value>UnreviewedVersion</stored-value>
</pair>
<pair>
<displayed-value>Reviewed version</displayed-value>
<stored-value>ReviewedVersion</stored-value>
</pair>
<pair>
<displayed-value>Corrected version</displayed-value>
<stored-value>CorrectedVersion</stored-value>
</pair>
</value-pairs>
</form-value-pairs></input-forms><?xml version="1.0" encoding="UTF-8"?>
<wf-config>
<workflow-map>
<name-map collection="default" workflow="default"/>
<!--<name-map collection="123456789/4" workflow="selectSingleReviewer"/>-->
<!--<name-map collection="123456789/5" workflow="scoreReview"/>-->
</workflow-map>
<!--Standard workflow step-->
<workflow start="reviewstep" id="default">
<roles>
<role id="reviewer" name="Reviewer" description="The people responsible for this step are able to edit the metadata of incoming submissions, and then accept or reject them." />
<role id="editor" name="Editor" description="The people responsible for this step are able to edit the metadata of incoming submissions, and then accept or reject them."/>
<role id="finaleditor" name="Final Editor" description="The people responsible for this step are able to edit the metadata of incoming submissions, but will not be able to reject them."/>
</roles>
<step id="reviewstep" role="reviewer" userSelectionMethod="claimaction">
<outcomes>
<step status="0">editstep</step>
</outcomes>
<actions>
<action id="reviewaction"/>
</actions>
</step>
<step id="editstep" role="editor" userSelectionMethod="claimaction">
<outcomes>
<step status="0">finaleditstep</step>
</outcomes>
<actions>
<action id="editaction"/>
</actions>
</step>
<step id="finaleditstep" role="finaleditor" userSelectionMethod="claimaction">
<actions>
<action id="finaleditaction"/>
</actions>
</step>
</workflow>
<!--Workflow where a reviewManager can select a single review who will then either accept/reject the item-->
<workflow id="selectSingleReviewer" start="selectReviewerStep">
<roles>
<role id="reviewer" name="Reviewer" scope="item" />
<role id="reviewmanagers" name="ReviewManagers" scope="repository"/>
</roles>
<step id="selectReviewerStep" role="reviewmanagers" userSelectionMethod="claimaction">
<outcomes>
<step status="0">singleUserReviewStep</step>
</outcomes>
<actions>
<action id="selectrevieweraction"/>
</actions>
</step>
<step id="singleUserReviewStep" role="reviewer" userSelectionMethod="autoassignAction">
<outcomes>
<step status="1">selectReviewerStep</step>
</outcomes>
<actions>
<action id="singleuserreviewaction"/>
</actions>
</step>
</workflow>
<!--Workflow where a number of users will perform reviews on an item and depending on the scores the item will be archived/rejected-->
<workflow id="scoreReview" start="scoreReviewStep">
<roles>
<role id="scoreReviewers" name="ScoreReviewers" scope="collection" description="The people responsible to select a single reviewer for the submission"/>
</roles>
<step id="scoreReviewStep" role="scoreReviewers" userSelectionMethod="claimaction" requiredUsers="2">
<outcomes>
<step status="0">evaluationStep</step>
</outcomes>
<actions>
<action id="scorereviewaction"/>
</actions>
</step>
<step id="evaluationStep" userSelectionMethod="noUserSelectionAction">
<actions>
<action id="evaluationaction"/>
</actions>
</step>
</workflow>
</wf-config>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE item-submission
SYSTEM "item-submission.dtd">
<item-submission>
<submission-map>
<name-map collection-handle="default" submission-name="traditional"/>
</submission-map>
<step-definitions>
<step-definition id="collection">
<heading/>
<processing-class>org.dspace.submit.step.StartSubmissionLookupStep</processing-class>
<type>collection</type>
<scope visibility="hidden" visibilityOutside="hidden">submission</scope>
</step-definition>
<step-definition id="complete">
<heading>submit.progressbar.complete</heading>
<processing-class>org.dspace.submit.step.CompleteStep</processing-class>
<type>submission-form</type>
</step-definition>
<step-definition id="sample">
<heading>Sample</heading>
<processing-class>org.dspace.submit.step.SampleStep</processing-class>
<type>sample</type>
</step-definition>
<step-definition mandatory="true" id="traditionalpage1">
<heading>submit.progressbar.describe.step1</heading>
<processing-class>org.dspace.app.rest.submit.step.DescribeStep</processing-class>
<type>submission-form</type>
</step-definition>
<step-definition mandatory="true" id="onepage1">
<heading>submit.progressbar.describe.step1</heading>
<processing-class>org.dspace.app.rest.submit.step.DescribeStep</processing-class>
<type>submission-form</type>
</step-definition>
<step-definition id="upload">
<heading>submit.progressbar.upload</heading>
<processing-class>org.dspace.app.rest.submit.step.UploadStep</processing-class>
<type>upload</type>
</step-definition>
<step-definition id="license">
<heading>submit.progressbar.license</heading>
<processing-class>org.dspace.app.rest.submit.step.LicenseStep</processing-class>
<type>license</type>
<scope visibilityOutside="read-only">submission</scope>
</step-definition>
</step-definitions>
<submission-definitions>
<submission-process name="traditional">
<step id="collection"/>
<step id="traditionalpage1"/>
<step id="upload"/>
<step id="license"/>
</submission-process>
<submission-process name="one">
<step id="collection"/>
<step id="onepage1"/>
<step id="upload"/>
<step id="license"/>
</submission-process>
</submission-definitions>
</item-submission>
