🦄 Gather up Issues Regarding Adventist ADL Production Data

[jeremyf]

The goal of this spike is to get an list of the various issues we're discovering regarding production data.

Slack messages regarding data issues:

• https://assaydepot.slack.com/archives/C0313NJV9PE/p1682610040930439
• ~https://assaydepot.slack.com/archives/C0313NJV9PE/p1683122476265479~ resolved manually

Errors to investigate and find examples:

• PDF split child works are still showing in UI One of many examples - why? (are they all in PendingRelationships table? How can we fix this?)
• PDF splitting which didn't complete according to PendingRelationships table
• Filesets where files failed to attach
  • 22250199
• Works where filesets failed to attach
• There were numerous works with duplicate titles (All titled "Seventh Day Adventist Library) where the child works got connected incorrectly. Two examples follow, but there are many more with the same title.
  • 22250128
  • 22250130
• Works with derivative errors such as 22253233

Are there other issues?

Done looks like: Create tickets and associate them with this Spike.

Remediation Tickets

• https://github.com/scientist-softserv/adventist_knapsack/issues/400
• https://github.com/scientist-softserv/iiif_print/issues/233
• Child works without relationships to parent work
• Duplicate child works
• PDF did not split
• Filesets with missing files
• Works with duplicate titles
• Works still in IiifPrint::PendingRelationships table which exist in Fedora but not Solr

[jillpe]

possibly helpful: https://assaydepot.slack.com/archives/C0313NJV9PE/p1689611025243569?thread_ts=1688740330.826599&cid=C0313NJV9PE