SAP Knowledge Base Article - Preview

1578274 - insufficient system memory in resource pool


  • 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
    DF_F42119_Incremental|Loader Query_SOSALESORDERDETAILHISTORY
    The load
    operation for table <SOSALESORDERDETAILHISTORY> failed because the
    SQL buffer used to batch multiple rows has
    exceeded the
    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


SAP Data Integrator XI R2 Accelerated ; SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2


BODS, BODI, DI, DS, Edge, DSXI, DS XI, BO DI, insufficient memory, al_engine, bufferSize , KBA , EIM-DS , Data Services , EIM-DI , Data Integrator, Composer , 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.