<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word;" fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;"><font face="Calibri, sans-serif"><span style="font-size: 14px;">Hi Phillip,</span></font>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
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.</div>
<div><font face="Calibri, sans-serif"><span style="font-size: 14px;"><b>select Title, ParentID, COUNT(*) FROM tblCollections_Content GROUP BY Title, ParentID HAVING count(*) > 1 \G</b></span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size: 14px;"><b><br>
</b></span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size: 14px;">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?</span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size: 14px;"><br>
</span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size: 14px;">~Patrick</span></font></div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 14px;">
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF244285" style="direction: ltr;"><font face="Tahoma" size="2" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org [archivesspace_users_group-bounces@lyralists.lyrasis.org] on behalf of Suda, Phillip J [psuda1@tulane.edu]<br>
<b>Sent:</b> Monday, January 11, 2016 10:12 AM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Archon migration SortOrder values<br>
</font><br>
</div>
<div></div>
<div>
<div>Patrick, </div>
<div><br>
</div>
<div> Check for duplicates in your classification hierarchy on the Archon side. It can cause the migration to fail. </div>
<div><br>
</div>
<div>Thanks, </div>
<div><br>
</div>
<div>Phil </div>
<div><br>
</div>
<div>
<div>
<div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:11pt">Phillip Suda</div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:11pt">Systems Librarian</div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:11pt">Howard-Tilton Memorial Library</div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:11pt">Tulane University</div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:11pt"><a href="mailto:psuda1@tulane.edu" class="" style="font-family:Verdana,sans-serif; color:rgb(149,79,114)" target="_blank">psuda1@tulane.edu</a></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:11pt">504-865-5607</div>
</div>
<div><br>
</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; border-bottom:medium none; border-left:medium none; padding-bottom:0in; padding-left:0in; padding-right:0in; border-top:#b5c4df 1pt solid; border-right:medium none; padding-top:3pt">
<span style="font-weight:bold">From: </span><<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf of "Flanagan, Patrick" <<a href="mailto:PJFlanagan@ship.edu" target="_blank">PJFlanagan@ship.edu</a>><br>
<span style="font-weight:bold">Reply-To: </span>Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<span style="font-weight:bold">Date: </span>Monday, January 11, 2016 at 9:10 AM<br>
<span style="font-weight:bold">To: </span>"Archivesspace Users Group ?[<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>]?" <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<span style="font-weight:bold">Subject: </span>[Archivesspace_Users_Group] Archon migration SortOrder values<br>
</div>
<div><br>
</div>
<div dir="ltr"><style type="text/css" id="owaParaStyle">
<!--
-->
</style>
<div>
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">Good morning,
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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;"</div>
<div><br>
</div>
<div>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:</div>
<div><br>
</div>
<div>
<div><i>Getting records for: ?p=core/classifications&batch_start=1801</i></div>
<div><i>get: <a href="https://archon.klnpa.org/psa?p=core/classifications&batch_start=1801" target="_blank">
https://archon.klnpa.org/psa?p=core/classifications&batch_start=1801</a></i></div>
<div><i>Status code: 200</i></div>
<div><i>Status text: Created</i></div>
<div><i>response: No matching record(s) found for batch_start=1801</i></div>
<div><i>java.lang.NullPointerException</i></div>
<div><i> at org.nyu.edu.dlts.utils.ArchonClient.getRootParent(ArchonClient.java:499)</i></div>
<div><i> at org.nyu.edu.dlts.utils.ArchonClient.getRootParent(ArchonClient.java:520)</i></div>
<div><i> at org.nyu.edu.dlts.utils.ArchonClient.getClassificationRecords(ArchonClient.java:431)</i></div>
<div><i> at org.nyu.edu.dlts.utils.ASpaceCopyUtil.copyClassificationRecords(ASpaceCopyUtil.java:918)</i></div>
<div><i> at org.nyu.edu.dlts.dbCopyFrame$1.run(dbCopyFrame.java:231)</i></div>
<div><i> at java.lang.Thread.run(Thread.java:745)</i></div>
</div>
<div><i><br>
</i></div>
<div>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,</div>
<div><br>
</div>
<div>~Patrick Flanagan</div>
<div>KLN Applications Administrator</div>
<div>Keystone Library Network Hub</div>
<div><br>
</div>
</div>
</div>
</div>
</span></div>
</div>
</div>
</div>
</body>
</html>