[TECH SUPPORT] LPS-48165 Upgrade 6.1 GA2 > 6.2 fails with error com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: Subquery returns more than 1 row

Hi Julio,

I'm forwarding @norbertkocsis's pull. I was thinking of changing "distinct" to max or min aggregator function to make 100% sure there won't be duplicate records again, but I ended up keeping distinct because with this change we are expecting more records with the same uuid. Max or min would technically guarantee that only 1 record is returned but it may hide handling corrupt data which should possibly be solved another way.