Query Limit issues

[monkey]

Yesterday we were having an issue with one user that was getting a query limit error when they were trying to convert a lead. The error they were getting was:

Error: Query limit of 5000 reached for Leads module.

I did some searching around and found that you can up the limit for queries in the config.php file. I raised the limit to be 10,000 instead of 5,000. Things seemed to be working just fine until this morning when the same user complained that they were now getting the same error but with the value of 10,000 instead of 5,000.

I'm wondering how you can get an additional 5,000 items in a query overnight (no new leads have been added since yesterday and I doubt that we have 10,000 leads in our system). So what query is causing this error, why does this keep coming up and is the only way around this to keep bumping up the query limit?

[Angel]

I've seen this before. Best bet is to turn off the resource management option that causes the message in the first place. Otherwise, you'll find yourself in a constant cycle of trying to figure out what the appropriate limit should be set to as it will change depending on the actions more frequently performed by people.

To turn it off, add this to your config_override.php:

$sugar_config['resource_management'] = NULL;

[monkey]

Thanks. That has solved our issue.

[rus]

Thanks. That has solved our issue.

Hi, unfortunately I also get this problem too,
just curious, what is the Resource Management that you are talking about ?

Thanks,
rus

[Angel]

It is a setting within Sugar. It is found in config.php and can be overridden via config_override.php.

I am not entirely sure I understand what purpose it serves. I don't recall having seen any documentation on the topic or hearing anything about it. Best I can tell you is that it appears to be some mechanism for controlling the number of queries Sugar can use. I am guessing that's done to limit its memory footprint.

[rus]

It is a setting within Sugar. It is found in config.php and can be overridden via config_override.php.

I am not entirely sure I understand what purpose it serves. I don't recall having seen any documentation on the topic or hearing anything about it. Best I can tell you is that it appears to be some mechanism for controlling the number of queries Sugar can use. I am guessing that's done to limit its memory footprint.

thanks for your explanation Angel ..
I really appreciate it

[rus]

I've seen this before. Best bet is to turn off the resource management option that causes the message in the first place. Otherwise, you'll find yourself in a constant cycle of trying to figure out what the appropriate limit should be set to as it will change depending on the actions more frequently performed by people.

To turn it off, add this to your config_override.php:

$sugar_config['resource_management'] = NULL;

hi angel,

by turn the resource management off, I only get this message after converting the leads :

Leads: Convert Lead

---------------

it supposed to be :

Leads: Convert Lead

# Created a new contact - [New Contact Name]
# Created a new account - [New Account Name]

Back To Leads
-------------

any idea what happen ?

[rus]

hi angel,

by turn the resource management off, I only get this message after converting the leads :

Leads: Convert Lead

---------------

it supposed to be :

Leads: Convert Lead

# Created a new contact - [New Contact Name]
# Created a new account - [New Account Name]

Back To Leads
-------------

any idea what happen ?

and somehow the new contact that have been created is not linked to the leads.
btw, I used the lead that already converted before.

[Angel]

I don't know why that would affect the lead conversion process, but does removing the line from config_override.php make the problem go away?

[rus]

I don't know why that would affect the lead conversion process, but does removing the line from config_override.php make the problem go away?

i still have the problem by removing the line from the config_override.php.

btw when i'm having the 'Query Limit' error message, the Account and the Contact is created,
At first I thought the 'Query Limit' error that i have was related when sugarcrm try build some link between Account/Contact and Leads. but don't know for sure ..