3300366 - High memory usage when moving ADSO to cold storage

For moving ADSO data to the cold storage, a statement similar to the following one is executed:

insert into "/BIC/OADSO13" (
  "ARCHREQTSN",
  "ARCHDPAKID_SID",
  "ARCHRECNO_SID",
  "ARCHDOBJID_SID",
  "CALDAY",
...
  "RECORDMODE"
)
select
  w."_ARCHREQTSN" as "ARCHREQTSN",
  floor((w."_WINDOW_ROW_NUMBER" - 1) / 2147000000) + w."_ARCHDPAKID_SID" + 1 as "ARCHDPAKID_SID",
  mod((w."_WINDOW_ROW_NUMBER" - 1) , 2147000000) + 1 as "ARCHRECNO_SID",
  floor((w."_WINDOW_ROW_NUMBER" - 1) / 1000000) + w."_ARCHDOBJID_SID" + 1 as "ARCHDOBJID_SID",
  w."CALDAY",
...
  w."RECORDMODE"
from (
  select u.*, row_number() over (partition by u."_ARCHREQTSN") as "_WINDOW_ROW_NUMBER"
  from(
select *, 20221209111957000098000 as "_ARCHREQTSN", 0 as "_ARCHDPAKID_SID", 0 as "_ARCHDOBJID_SID" from "/BIC/AADSO32" where "CALYEAR" = '2015'
  ) as u
) as w

This statement fails with a Composite OOM (Out Of Memory) error on HANA side.

• SAP HANA, platform edition 2.0
• BW/4HANA
• SAP IQ

out of memory , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , BC-DB-DBI , DB Independent Database Interface , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , BW4-DM-DTO , Data Tiering Optimization , Problem