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:
- Increase the amount of memory allocated to the SQL Server server. You can do this by opening the SQL Server Configuration Manager and editing the properties of the SQL Server service.
- Optimize the query that Adobe Campaign is trying to execute. This may involve breaking the query into smaller queries, or using indexes to improve the performance of the query.
- Reduce the number of concurrent users that are accessing the SQL Server server. This may involve scheduling batch jobs to run at off-peak times, or using a load balancer to distribute the load across multiple SQL Server servers.
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:
- Check the SQL Server error logs for more information about the error.
- Make sure that the SQL Server server has the latest updates installed.
- If you are using a virtual machine for the SQL Server server, make sure that the virtual machine has been allocated enough memory.
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