Process chain in DTP to aDSO stopped working with error: sql error with code '2.048

[jananipriya]

Hi Experts,

I'm using S/4 Hana as source system and BW 7.5 on HANA as BW system.

We created a process chain with the following flow:

In the above process chain the DTP from Data source to ADSO1 is working without any issue till date, but the DTP from ADSO1 to ADSO2 has stopped loading since last month with the following error:

sql error with code '2.048'. see the following sql message: column store error:search table error:column store error: search table error:[9] Memory allocation failed;exception 1000002:Allocation failed; $size$=85814206720;$name$= Results; $type$=pool; $inuse_count$=13; $allocated_size$= 88863481680; $alignments$=8; $failure_types$=GLOBAL_ALLOCATION_LIMIT;$failure_flag$=,Exception in executor plan29809899@chs4hprd01:30040 while executing pop 11 (please check lines :13, 30, 45) Exception CX_RSDHA_MSG logged

I'm a newbie to BW so please help me to resolve this error with yours suggestions ASAP 😊😃.

[former_member577849]

Dear Jananipriya,

Unfortunately, it seems to be taking longer than usual for your question to be answered. You might want to try an alternative route to speed things up.

Please check if a similar question has already been asked in the Community. We have found that sometimes questions that have been answered before are no longer receiving responses.

The easiest way to do this, is to visit the All Questions page and search for your specific topic.

You could also check the SAP Support Portal and search for SAP Notes, SAP Knowledge Base Articles and more.

Thanks,

Marvin