Hi All
we are facing this error in wkf very frequnetly:
09/19/2023 6:05:04 AM enrich223 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
if anyone faced same issue
please help to undertand the rootcause and fix of this issue further
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hello @Shruti1,
The error message 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 indicates that the SQL Server server does not have enough memory to run the query that Adobe Campaign is trying to execute.
First of all I would suggest you check which table consuming maximum memory.
It can possible that some temporary table created by workflow not purged.
You can check for the keep in interim result flag in workflows property should be not checked.
There are a few other things you can try to resolve this issue:
If you are facing this error frequently, it is important to identify the root cause of the problem. You can use the SQL Server Performance Monitor to track the memory usage of the SQL Server server and identify any queries that are using a large amount of memory.
Here are some additional tips for troubleshooting this issue:
In the specific case you can try to Restart the Adobe Campaign server. But is not solve the problem for long term.
Hope it will help you.
Kr,
Parvesh
Hi @Shruti1 ,
Could you Please check the Target Schema used in your Workflow is occupying how much space in your Database memory and if it occupies more DB Space, it would be better to upscale your DB Size or Optimize the Data in this Schema so that this error dont occur again and also Please try optimizing the queries used in the workflow by giving the where conditions whatever only required and try debugging the Workflow.
Regards,
Pravallika.
Hello @Shruti1,
The error message 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 indicates that the SQL Server server does not have enough memory to run the query that Adobe Campaign is trying to execute.
First of all I would suggest you check which table consuming maximum memory.
It can possible that some temporary table created by workflow not purged.
You can check for the keep in interim result flag in workflows property should be not checked.
There are a few other things you can try to resolve this issue:
If you are facing this error frequently, it is important to identify the root cause of the problem. You can use the SQL Server Performance Monitor to track the memory usage of the SQL Server server and identify any queries that are using a large amount of memory.
Here are some additional tips for troubleshooting this issue:
In the specific case you can try to Restart the Adobe Campaign server. But is not solve the problem for long term.
Hope it will help you.
Kr,
Parvesh
Views
Likes
Replies