The processing of an SQL statement containing at least one correlated subquery requires the generation of an internal result whose rows would exceed the permitted length.
Check whether some columns within the SELECT statement can be omitted or the SQL statement can be reformulated in such a way that less or no corresponding (correlated) columns are used.