11/01/2023 9:26:12 AM subworkflow ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is insufficient system memory in resource pool 'default' to run this query. SQLState: 37000 | Community
Skip to main content
S
Shrutii
Level 4
November 3, 2023
Solved

11/01/2023 9:26:12 AM subworkflow ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is insufficient system memory in resource pool 'default' to run this query. SQLState: 37000

  • November 3, 2023
  • 1 reply
  • 572 views

Hi All, W e are facing below errors very frequenlty in our workflows:errror logs says it is because of 

insufficient system memory in resource pool 'default' to run this query, but when we check the memory on database server--we have more than enough memory freee  there

still facing--insufficient system memory in resource pool 'default' to run this query--error

 

any one else faced the same issuw please help??

 

Logs:

===========================

 

11/02/2023 9:26:24 AM WDB-200001 SQL statement 'DropTableIfExists 'wkf887252596_39_3'' could not be executed.
11/02/2023 9:26:24 AM ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is insufficient system memory in resource pool 'default' to run this query. SQLState: 37000
11/02/2023 9:26:12 AM subworkflow ROM wkf887986529_14_1' could not be executed.
11/02/2023 9:26:12 AM subworkflow WDB-200001 SQL statement 'INSERT INTO wkf887252596_39_5 (biDCNS_ID,sTpflg,biDCNS_CNSM_ID,biDCNS_CNSM_ID1,sEMDA_ADDRESS_,iDisasterAreaFlag,sSegmentCode) SELECT biDCNS_ID,sTpflg,biDCNS_CNSM_ID,biDCNS_CNSM_ID1,sEMDA_ADDRESS_,iDisasterAreaFlag,sSegmentCode F
11/02/2023 9:26:12 AM subworkflow ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is insufficient system memory in resource pool 'default' to run this query. SQLState: 37000

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

Hi @shrutii ,

Few complex query or workflow will consume huge space in temporary schema in the workflow. During such time, If there is no adequate space in database, you will be getting this error 'insufficient system memory' and once the temporary table is dropped, the space will come to normal.

If there are multiple workflows with 'keep interim' enabled in workflow property, it will occupy huge space. Try unchecking it by the method mentioned here, so you will have good space in database and won't be getting the same error again.

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
November 3, 2023

Hi @shrutii ,

Few complex query or workflow will consume huge space in temporary schema in the workflow. During such time, If there is no adequate space in database, you will be getting this error 'insufficient system memory' and once the temporary table is dropped, the space will come to normal.

If there are multiple workflows with 'keep interim' enabled in workflow property, it will occupy huge space. Try unchecking it by the method mentioned here, so you will have good space in database and won't be getting the same error again.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...