Task #3612: CN SystemMetadata has incomplete obsoletedBy information
Correct revision history on PISCO node
There are quite a few instances of unidirectional revision history for the PISCO objects. These are generated SystemMetadata entries (probably from the original Metacat 2.0.0 upgrade) that did not correctly write bidirectional obsoletes/obsoeltedBy information to both the new and old revisions.
To correct this, the following SQL can be used (first to investigate, and finally to update the objects in question).