- Data Services Job Server's server_event log shows: "There is insufficient system memory in resource pool 'default' to run this query."
- Error log shows error similar to this one (will be reflect objects in your environment):
(12.2) 02-24-11 02:30:27 (E) (6700:11388) RUN-051002: |Data flow
operation for table <SOSALESORDERDETAILHISTORY> failed because the
SQL buffer used to batch multiple rows has
underlying database buffer size. The current buffer size is <24000>.
This size can be reset by adding or changing
<AL_EngineLoaderSQLBufferSize> in the [AL_Engine] section in the
DSConfig.txt file. For example, to set the new buffer
size to be 30K,
you would type AL_EngineLoaderSQLBufferSize=30000.
- Data Integrator
- Data Services
BODS, BODI, DI, DS, Edge, DSXI, DS XI, BO DI, insufficient memory, al_engine, bufferSize , KBA , EIM-DS , Data Services (Use Subcomponent) , EIM-DI , Data Integrator, Composer , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.