POWLs and CX_SHM_OUT_OF_MEMORY

[julieplummer20]

Hi, I'm starting a new discussion, because I know this was raised some time back (by Damean?), but I can't find the original thread. Apologies - shabby form. However, I hope that the following answer, though late, will help someone:

The developer has not seen this error before. his type of error is described in SAP Note 1322182 - Memory consumption of ABAP Shared Objects. The Note contains lots of cross-references. Generally, the approach is to set the SHM parameter to 10-500MB – depending on the specific application.

We cannot be sure (without more details) whether the problem is really with abap/shared_objects_size_MB, but here are our settings:

Non HANA RT5: 512 MB:

HANA System RT7: 1024 MB.

We searched for a relevant note for the combination of NWBC + POWL or Customer Cockpit, but didn’t find anything.

For problems with the Customer Cockpit, we have created 2 components:

EP-PCT-SD-S (Portal Content)

SD-SLS (Feeder Class for  Customer Cockpit)

So, if you’ve worked through Notes 1322182  , 1784556 , and 972757 , could you please create an OSS message under one of these two component? Just make sure to mention that you’re on NWBC, not Portal.

Best wishes,

Julie.

[Damean]

Julie

  Thanks, I think I am the first person who raise this. The issue is that majority of the standard POWL Queries SAP deliver will grab ALL data in the first run. As example, when I ran the Material Document POWL report for the first time, it ran for almost 4 hours (we're NON-HANA today) as it attempt to grab the few millions material document we have in our system.

   Based on this experience, I think it will be a good practice for the NWBC configurer\administrator to create a duplicate of SAP POWL query that you intend to use with a more limited selection of data (e.g. Last 10 posting days or force certain fields to be mandatory). This could typically be achieve in mere minutes via Tcode POWL_QUERY. Of course, this query is just the default value, user could then proceed to change them as desired.

[julieplummer20]

Hi Damean, That's a good tip, thanks. I'll pass this on.

best wishes,

Julie.