Skip to Content
0
Aug 14, 2023 at 02:14 PM

SAP CAPM | Allocation memory failed error | HDI Container

109 Views

Hello Everyone,

I have a CAP service which basically consist of huge amount of data from ECC System. there are various associations used at calculation view level and then in the CAP layer they are all joined together in a flat structure. Everything works fine and as expected.

However there is other part of requirment, that the count should be based on visible fields and no duplicate records should be shown on the screen and also not counted. for eg when a user select sales order and posnr as visible fields following should be the output
sales order order item

1 00001

1 00002

count should be shown as 2. and when only sales order is shown as visible column count should be just 1.

this all works for me, I have made relevant adjustment at CAP layer. but there are 800k records in certain situations; and I get memory allocation error when the count query is executed. Main query already has pagination setup so that is no problem, but in count query I cannot make use of pagination as I want to have dynamic count based on visible fields.

Any idea how can I get rid of allocation memory error in HDI Container. Screenshot attached when I run the same query in Database explorer.

image.png

Attachments

image.png (78.7 kB)