<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<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: https://archon.klnpa.org/psa?p=core/classifications&batch_start=1801</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>
</body>
</html>