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, 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

[LakshmiPravallika · Accepted solution]

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.

[Shrutii]

getting this error, while running a wkf

[LakshmiPravallika]

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.

[AkshayAnand]

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