0PRODUCT_HIER Memory Allocation Failure

[aleksandrs_antonuks2]

Hi all,

Recently faced an issue of a load failing in 0PRODUCT_HIER with load memory allocation.

Upon debugging found out that base tables contain millions of records causing the load to fail.

The hierarchy is always loaded as full and the only possible selection criteria is hierarchy technical name.

What would be the best way to mitigate this issue?

- data archiving in the tables?

- if udate subtree in Hierarchy Selection tab is used, would that help?

What could be other options?

[Former Member · Accepted solution]

Hi Aleks,

According to the dump ( SEND_HIERARCHY_20 ), you need to change data settings of Datasource. Please run hierarchy load in lower environment for test first:

(1).Source system: Change the field ROOSOURCE-TFMETHODS from 1 (=IDOC) to 2 (=PSA) for Datasource with A version only!

(2).BW system: Replicate and activate the Datasource once again to update this PSA method and hierarchy extraction report will be generated

(3).BW system: If the Datasource replication and activation works fine then afterwards you can run the Infopackage to upload the hierarchy to PSA please.

Additionally, check also this consulting note: 654243

P_T_HIENODE[] Table IT_74 contains record number: [3124160x228]

This seems to be too much records.... hierarchies with more than 100,000 nodes are not officially supported.

Best regards, Andras

[aleksandrs_antonuks2]

Hi Andras,

Thank you for your fast reply. Will try that approach and let you know.

Br,

Aleks.

[aleksandrs_antonuks2]

Hi Andras,

Here is the link to the document with the dump.

dump

Br,

Aleks.

[Former Member]

Hi Aleksandrs,

Is it possible to attach the full log of dump?

Best regards, Andras

[aleksandrs_antonuks2]

Hi Andras,

Sorry, it took a while. At the end the solution was to extend the memory and the hierarchy remained the same.

Br,

Aleks.