Project

General

Profile

Task #3620

Task #3612: CN SystemMetadata has incomplete obsoletedBy information

Correct revision history on PISCO node

Added by Ben Leinfelder almost 12 years ago. Updated almost 12 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
-
Start date:
2013-02-27
Due date:
% Done:

100%

Milestone:
None
Product Version:
*
Story Points:
Sprint:

Description

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).

https://code.ecoinformatics.org/code/metacat/trunk/src/system_metadata_revisions.sql

History

#1 Updated by Ben Leinfelder almost 12 years ago

  • Status changed from New to Closed
  • translation missing: en.field_remaining_hours set to 0.0

Mike ran this and reported the update results:
Old entries not marked as such: 10604
Ones that should be marked as archived but were not: 3606

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 14.8 MB)