<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body class="" style="word-wrap:break-word" fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<div>Hi Chris,</div>
<div><br>
</div>
<div>I think I understand. Any rows with identical ParentID and Title would be the problem? I tried:</div>
<div>
<div><i>select Title, ParentID, COUNT(*) FROM tblCollections_Classifications GROUP BY Title, ParentID HAVING count(*) > 1 \G</i></div>
<div><i>Empty set (0.02 sec)</i></div>
</div>
<div><br>
</div>
<div>... Which I'm fairly certain is correct. (The other query I tried was in tblCollections_Content, which did have many rows come up.)</div>
<div><br>
</div>
<div>I'll keep looking for now. Thank you!</div>
<div><br>
</div>
<div>~Patrick</div>
<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF925232" 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 Prom, Christopher John [prom@illinois.edu]<br>
<b>Sent:</b> Monday, January 11, 2016 10:58 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>Patrick,
<div class=""><br class="">
</div>
<div class="">The Archonsort order values are relative to the parent ID-- in other words, not unique. However, I don’t think that this problem is related to the query you tried to do below, since the issue you are having is with the classifications. For that
reason, you may wish to look for a duplicate parent ID/SortOrder combination in the classification table instead. </div>
<div class=""><br class="">
</div>
<div class="">It will be a much shorter group of records, so if you can’t find it via a query, you may be able to identify the problem via manual inspection.</div>
<div class=""><br class="">
</div>
<div class="">Chris Prom</div>
<div class="">
<div class=""><br class="">
</div>
<div class="">
<div>
<blockquote type="cite" class="">
<div class="">On Jan 11, 2016, at 7:10 AM, Flanagan, Patrick <<a href="mailto:PJFlanagan@ship.edu" class="" target="_blank">PJFlanagan@ship.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class=""><style type="text/css" id="owaParaStyle" class="">
<!--
-->
</style>
<div class="">
<div class="" style="direction:ltr; font-family:Tahoma; font-size:10pt">Good morning,
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">
<div class=""><i class="">Getting records for: ?p=core/classifications&batch_start=1801</i></div>
<div class=""><i class="">get: <a href="https://archon.klnpa.org/psa?p=core/classifications&batch_start=1801" class="" target="_blank">
https://archon.klnpa.org/psa?p=core/classifications&batch_start=1801</a></i></div>
<div class=""><i class="">Status code: 200</i></div>
<div class=""><i class="">Status text: Created</i></div>
<div class=""><i class="">response: No matching record(s) found for batch_start=1801</i></div>
<div class=""><i class="">java.lang.NullPointerException</i></div>
<div class=""><i class=""> at org.nyu.edu.dlts.utils.ArchonClient.getRootParent(ArchonClient.java:499)</i></div>
<div class=""><i class=""> at org.nyu.edu.dlts.utils.ArchonClient.getRootParent(ArchonClient.java:520)</i></div>
<div class=""><i class=""> at org.nyu.edu.dlts.utils.ArchonClient.getClassificationRecords(ArchonClient.java:431)</i></div>
<div class=""><i class=""> at org.nyu.edu.dlts.utils.ASpaceCopyUtil.copyClassificationRecords(ASpaceCopyUtil.java:918)</i></div>
<div class=""><i class=""> at org.nyu.edu.dlts.dbCopyFrame$1.run(dbCopyFrame.java:231)</i></div>
<div class=""><i class=""> at java.lang.Thread.run(Thread.java:745)</i></div>
</div>
<div class=""><i class=""><br class="">
</i></div>
<div class="">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 class=""><br class="">
</div>
<div class="">~Patrick Flanagan</div>
<div class="">KLN Applications Administrator</div>
<div class="">Keystone Library Network Hub</div>
<div class=""><br class="">
</div>
</div>
</div>
_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
</div>
</body>
</html>