I discovered an issue when trying to delete an unused environment. I needed to first delete an environment binding for a certificate, but this wasn’t allowed because of an unexpected value.
Digging a little deeper, i was able to find the integrity checks that were failing for the same reasons.
The RelatedDocumentId 'certificates' for Event Id 'Events-17215' is not in the expected format. The RelatedDocumentId 'certificates' for Event Id 'Events-17216' is not in the expected format. The RelatedDocumentId 'certificates' for Event Id 'Events-17218' is not in the expected format.
Digging even deeper into the SQL database itself. I can see that
Event.RelatedDocumentIds has a reference to a bunch of IDs, including one called
certificates. I also looked in the
EventRelatedDocument and see that there is an entry in there for “certificates” in the
I had a look on the following Github issue, but the proposed SQL query fix doesn’t appear to be appropriate for my issue.
We’re currently running version
v2020.6 (Build 4915).
Is there anything we can do to resolve this? As it’s stopping us tidying up some old applications, certificates and environments.