Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
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

Avatar

Level 4

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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.