Symptom
CI-DS task which extracts data from IBP fails with the error shown in CI-DS task's View History >> Error Log:
- 2024-01-01 00:00:00 (R)(8020:9032) R3C-150417 |Data flow <DATAFLOW>
E: MESSAGE - A database error occured. The error message in the database was: "cannot allocate enough memory: "SAPHANADB"."(DO
statement)": line 2 col 3 (at pos 12): [9] Memory allocation failed;exception 1000002: Allocation failed ;
$failure_type$=TOTAL_STATEMENT_MEMORY_LIMIT_FROM_WORKLOAD_CLASS; $failure_flag$=; $size$=16; $name$=Job;
...
E: MESSAGE - An error occurred. Please refer to the logs of batch <BATCH> ...
Searching in the IBP Application Logs app with the UUID from the same CI-DS task's View History >> Trace Log (e.g. '<EV_QUERY_UUID : > <00000000001111111111AAAAAAAABBBB>') the below errors shown:
- Exception 'A database error occured. The error message in the database was: "cannot allocate enough memory: "SAPHANADB"."(DO statement)": line 2 col 3 (at pos 12): Allocation failed; Reason: configured total statement memory limit from workload class 'HCI_INTEGRATION' reached (SAP Note 3191224)".
- Out-of-memory error found. Contact your IBP admin, mention log handle '00000000001111111111AAAAAAAABBBB'.
Read more...
Environment
- SAP Integrated Business Planning
- SAP Cloud Integration for data services
Product
Keywords
memory allocation, failure, IBP, CPI, HCI, CI-DS, data transfer, calc scen, failure, oom, statement memory limit, allocation error, Out-of-memory, , KBA , SCM-IBP-INT-TS-DS , CPI-DS Integration , LOD-HCI-DS , HANA Cloud Integration for Data Services , SCM-IBP-INT-TS , Time-Series-Based Integration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview