Expand my Community achievements bar.

SOLVED

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, we are facing this error,

can u please help next steps to fix this issue

 

 

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Shrutii ,

 

Can you Please ping us the query which you tried , so that this error is coming.

 

Also Can you tell us when you are getting this error with brief steps(In a workflow or a Schema etc)...

 

Regards,

Pravallika.

 

 

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

Hi @Shrutii ,

 

Can you Please ping us the query which you tried , so that this error is coming.

 

Also Can you tell us when you are getting this error with brief steps(In a workflow or a Schema etc)...

 

Regards,

Pravallika.

 

 

Avatar

Community Advisor

Hi @Shrutii ,

 

Can you Please share the Workflow query you are trying to run or the sample snippet of the Workflow to look into it.

 

Regards,

Pravallika.

Avatar

Community Advisor

Hi @Shrutii 

 

You can refer the link which might explain your query. It looks like your query result is fetching more rows than the allocated RAM space, Could you please relook the SQL query code.

 

Regards

Akshay