AttributeValue records with both and Active and Inactive record for the same content

Hi everyone

We've found several AttributeValue records (193 pairs) which have 2 states in the files for the same effectiveTime - one Active and one Inactive.

For example:
id effectivetime active moduleid refsetid referencedcomponentid valueid
34105af2-75df-4851-bb1b-10481862a050 20170131 1 900000000000207008 900000000000490003 2475924014 900000000000495008
402ef83b-0033-5802-b73e-a9d92c98fa48 20170131 0 900000000000207008 900000000000490003 2475924014 900000000000495008

Our first thought was that we can't remove the inactive rows as they have been published, and therefore we shouldn't "change history" and break the RF2 standard.

However, on further consideration the audit trail of what we have published is ambiguous, and so in this particular case it might be better to remove the incorrect rows completely. The reason this wouldn't be contravening the RF2 standard, is because it wouldn't technically be "changing the past", it would instead be making it clear what the past actually was.

Anyway, as always please provide your thoughts!

Kind regards

Andrew