Cannot allocate memory

Ramco Ramco

when i write below statement in query then i get error - cannot allocate enough memory. When i comment it works fine

WHEN T1."TransType" = '1470000049' THEN (

SELECT STRING_AGG(A0."Location", ', ')

FROM OITM A0 WHERE A0."ItemCode" IN (SELECT distinct("ItemCode") FROM ACQ1 WHERE "DocEntry" = T1."CreatedBy" AND "ObjType" = '1470000049'))

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

sasikala s1y ago

WITH AggregatedLocations AS (

    SELECT

        A1."DocEntry",

        STRING_AGG(O."Location", ', ') AS Locations

    FROM ACQ1 A1

    JOIN OITM O ON A1."ItemCode" = O."ItemCode"

    WHERE A1."ObjType" = '1470000049'

    GROUP BY A1."DocEntry"

)

SELECT

    ...,

    CASE

        WHEN T1."TransType" = '1470000049' THEN AL.Locations

        ELSE NULL

    END AS AggregatedLocation

FROM YourMainTable T1

LEFT JOIN AggregatedLocations AL ON T1."CreatedBy" = AL."DocEntry"

0