[Archivesspace_Users_Group] Archon migration SortOrder values

Flanagan, Patrick PJFlanagan at ship.edu
Mon Jan 11 10:20:24 EST 2016

Hi Phillip,

I've tried doing this through an SQL query; does the query look correct to you? I assume anything with the name Title and ParentID is a duplicate, but that might be wrong.
select Title, ParentID, COUNT(*) FROM tblCollections_Content GROUP BY Title, ParentID HAVING count(*) > 1 \G

That returned 7506 rows with various counts, so I hope I'm incorrect! Or would it be easier to look and see from the Archon interface itself?

From: archivesspace_users_group-bounces at lyralists.lyrasis.org [archivesspace_users_group-bounces at lyralists.lyrasis.org] on behalf of Suda, Phillip J [psuda1 at tulane.edu]
Sent: Monday, January 11, 2016 10:12 AM
To: Archivesspace Users Group
Subject: Re: [Archivesspace_Users_Group] Archon migration SortOrder values


     Check for duplicates in your classification hierarchy on the Archon side. It can cause the migration to fail.



Phillip Suda
Systems Librarian
Howard-Tilton Memorial Library
Tulane University
psuda1 at tulane.edu<mailto:psuda1 at tulane.edu>

From: <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of "Flanagan, Patrick" <PJFlanagan at ship.edu<mailto:PJFlanagan at ship.edu>>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Date: Monday, January 11, 2016 at 9:10 AM
To: "Archivesspace Users Group ?[archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>]?" <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: [Archivesspace_Users_Group] Archon migration SortOrder values

Good morning,

A little while ago I messaged the group about a null pointer exception during migration from Archon -> ArchivesSpace. This question is semi-related to that.

Among the checks to perform before migration is one relating to duplicate SortOrder values in tblCollections_Content. The associated query to perform is: "SELECT ParentID, SortOrder, count(*) from tblCollections_Content Group by ParentID, SortOrder HAVING count(*) > 1;"

I didn't fix that in the current instance I'm migrating because count(*) adds up across 144 rows to be well over 10,000. I'm wondering if that might be the cause of a null pointer exception when attempting to migrate from Archon. A sample of the latest error I've received:

Getting records for: ?p=core/classifications&batch_start=1801
get: https://archon.klnpa.org/psa?p=core/classifications&batch_start=1801
Status code: 200
Status text: Created
response: No matching record(s) found for batch_start=1801
        at org.nyu.edu.dlts.utils.ArchonClient.getRootParent(ArchonClient.java:499)
        at org.nyu.edu.dlts.utils.ArchonClient.getRootParent(ArchonClient.java:520)
        at org.nyu.edu.dlts.utils.ArchonClient.getClassificationRecords(ArchonClient.java:431)
        at org.nyu.edu.dlts.utils.ASpaceCopyUtil.copyClassificationRecords(ASpaceCopyUtil.java:918)
        at org.nyu.edu.dlts.dbCopyFrame$1.run(dbCopyFrame.java:231)
        at java.lang.Thread.run(Thread.java:745)

I was wondering: are the SortOrder values largely arbitrary? If I write up a quick script just to ensure each one has a unique value, would that potentially solve the issue? It's affecting numerous migration attempts. Thank you for your time,

~Patrick Flanagan
KLN Applications Administrator
Keystone Library Network Hub

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20160111/63f2140b/attachment.html>

More information about the Archivesspace_Users_Group mailing list