DSpace 7.5 migration from 6.3

[Milos Ivanovic]

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

[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

[Milos Ivanovic]

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

[Tim Donohue]

Hi Milos,

Unfortunately, the error messages displayed in the UI aren't enough information to debug the issue.  You'd need to locate the underlying exceptions behind those error messages, as those will provide more clues as to whether the problem is one of your configs or maybe something else with the installation.  We have a troubleshooting guide which walks you through finding underlying exceptions either in the UI or backend: https://wiki.lyrasis.org/display/DSPACE/Troubleshoot+an+error#Troubleshootanerror-DSpace7.x(orabove)

Once you locate the underlying exception, it's possible you'll find one of the common installation errors listed at https://wiki.lyrasis.org/display/DSDOC7x/Installing+DSpace#InstallingDSpace-CommonInstallationIssues  If not, and the error text doesn't make sense, you can send it to this list and hopefully someone here can provide more clues.

Tim

[Milos Ivanovic]

Dear Tim,

Thank you for the guidelines. I will dig deeper and understand what is going on.  Perhaps starting from the default workflow and submission form is better than trying to employ the migrated XMLs.

Kind regards

Milos

[Tim Donohue]

Hi Milos,

Yes, I'd recommend first starting from the default workflow/submission that comes with 7.5 just to ensure everything else is working properly.  Then, once you have everything working, you could try to migrate your old configs over (either manually or by using the provided migration scripts).

Tim