I noticed yesterday that my {php}IPAM integration for vRA 8 (https://virtuallypotato.com/integrating-phpipam-with-vrealize-automation-8) was failing every time it tried to retrieve the list of available IP ranges.
Seems it's a known issue - updating to vRA 8.4.2 should fix it.
https://kb.vmware.com/s/article/84027
PS: You need to apply Product Support Pack v8.4.1.1 in LCM, and then install LCM 8.4.1 PATCH1 before you can use LCM to upgrade vRA to 8.4.2.
#CoSoTech
I ran into an issue with vRA failing to start after the 8.4.2 upgrade. I worked with #VMware support to get around the problem and complete the upgrade.
And I just found this great blog post which has the details on what's wrong and how to fix it - and those steps exactly mirror what support had me do - including the PL/pgSQL query I mentioned yesterday:
https://www.nukescloud.com/post/identity-service-app-initialization-failure-after-upgrading-to-vrealize-automation-8-4-2