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