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

jananipriya — Fri, 11 Jun 2021 11:06:43 GMT

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 😊😃.

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

former_member577849 — Thu, 17 Jun 2021 06:17:30 GMT

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

Question Re: Process chain in DTP to aDSO stopped working with error: sql error with code '2.048 in Technology Q&A

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

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