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.