DSpace v7.6.2 after successful import AIP it gives an error "An exception has occurred" when trying to create a Community or Collection

[Alexey Volkovoy]

DSpace v7.6.2 after successful import AIP it gives an error "An exception has occurred" when trying to create a Community or Collection

import command was:

/dspace/bin/dspace packager -r -a -f -t AIP -e ******@gmail.com -i 123456789/0 -o skipIfParentMissing=true /home/**********ds_aip_*********.zip

dspace Log fragment with java error message in attached file 

[DSpace Technical Support]

Hi,

The error log says this:

025-01-24 01:22:48,292 ERROR 1c7f6519-728e-495a-9ce9-18f689656ba8 b783974d-bb51-4197-840b-8f2e3b34cf60 org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: duplicate key value violates unique constraint "handle_handle_key" Detail: Key (handle)=(123456789/25) already exists.

It's saying that you are attempting to add an object with the Handle "123456789/25" and that Handle *already exists* in your system.

You may need to run "./dspace database update-sequences" on your system to update your database sequence which selects the *next* Handle suffix.  See the last error message in this table of comment errors (as that's what you are hitting): https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore#AIPBackupandRestore-CommonIssuesorErrorMessages

Tim