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

[Shrutii]

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

[ParthaSarathy · Accepted solution]

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.