Hello folks,
As the title says, as part of a migration from vRA 7.5 to 7.6 we need to cleanup some duplicate entries from old tenants as per procedure: https://kb.vmware.com/s/article/58002
However there are a lot of entries from a deleted tenant that have referencies between tables which limit us to delete the tenant. For doing the cleanup of the references we have to jump between tables and is easy to do but the issue is that the DELETE ON CASCADE cannot be done as the Foreign Keys are limiting that operation. I can do the manual cleanup one by one by deleting the referenceces of the row between tables but this is not a proper solutions as there are more than 800 stale entries between multiple tables which is really time consuming.
I already opened a ticket with VMware GSS but in the meanwhile, did somebody faced this issue or something similar? Is there a way to temporarily allow the deletion of the chilf references automatically by only deleting the parent row?
Thanks!
