[Archivesspace_Users_Group] Archon migration SortOrder values
PJFlanagan at ship.edu
Mon Jan 11 10:10:36 EST 2016
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
Status code: 200
Status text: Created
response: No matching record(s) found for batch_start=1801
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,
KLN Applications Administrator
Keystone Library Network Hub
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Archivesspace_Users_Group