Dear All,

I am doing a backup of the entire site using the instructions 
here: 
https://wiki.duraspace.org/display/DSDOC5x/AIP+Backup+and+Restore#AIPBackupandRestore-ExportingEntireSite.
 
The backup was not successful because of this error:

Exception: Error exporting METS for DSpace Object, type=ITEM, 
handle=10665.1/8822, dbID=8907 
org.dspace.content.packager.PackageValidationException: Error exporting 
METS for DSpace Object, type=ITEM, handle=10665.1/8822, dbID=8907, Reason: 
edu.harvard.hul.ois.mets.helper.MetsException: ID "bitstream_2" already 
exists at 
org.dspace.content.packager.AbstractMETSDisseminator.disseminate(AbstractMETSDisseminator.java:280)

Searching for this error, I came across this 
thread: 
http://dspace.2283337.n4.nabble.com/Is-Bitstream-sequence-id-supposed-to-be-unique-per-Bundle-or-per-Item-tp3937626.html.
 
Locating the problematic item, I found out that this item have 2 
(identical) license bundles (see attachment). Deleting one license bundle 
and then doing the export again resolved this issue until another 
problematic item with the same error comes up again.

Is there a way to find all these problematic items with bundles that have 
duplicate sequence_id in their bitstreams? In the error stated above, I 
executed the SQL query mentioned in the thread that I referenced and below 
is the result:

 bundle_id | bitstream_id | sequence_id
-----------+--------------+-------------
     39844 |        46401 |           4
     39844 |        46400 |           3
     42083 |        53559 |          42
     42083 |        53558 |          41
     33805 |        39798 |           2
     46843 |        57468 |          44
     46843 |        57467 |          43
     33806 |        39799 |           2
(8 rows)

Note the duplicate sequence_id=2. I would like to find all items that have 
these duplicate sequence_id and delete all them.

Thanks in advance and regards,
euler.

-- 
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Reply via email to