Target list generation timing out

šŸ’¬ General Discussion
1

SuiteCRM version 7.4.3

Am trying to add members to a target list from Accounts by selecting a batch of records from Accounts then selecting ā€œAdd to target listā€ from the dropdown options (i.e. clicking on the right-hand part of the ā€œDeleteā€ button) and then picking a target list from the pop-up form. This fails if much more than about 100 records is selected - it keeps going until the script times out (even if I bump max_execution_time up to 360 seconds in php.ini), and then fills the screen with some sort of massive PHP oblect dump - on checking the target list it will have added only the first 100 or so accounts.

In case it is relevant, have also added the following lines to config_override.php :

$sugar_config[ā€˜resource_managementā€™][ā€˜special_query_limitā€™] = 500000;
$sugar_config[ā€˜resource_managementā€™][ā€˜default_limitā€™] = 50000;
$sugar_config[ā€˜resource_managementā€™][ā€˜special_query_modulesā€™][] = ā€˜Accountsā€™;

Any ideas? I know our version of SuiteCRM is old (due to operating system constraints), so may be fixed in later versions.

2

Please post those lines inside ā€œcodeā€ tags, otherwise the brackets are removedā€¦

When you set timeout to 360, does it timeout after that period, or earlier?

If earlier, itā€™s not the timeout that is limiting things. Could be running out of memory. Did you try setting a higher memory_limit in php.ini?

3

Thanks for that - here are trhe configuration lines :


$sugar_config['resource_management']['special_query_limit'] = 500000;
$sugar_config['resource_management']['default_limit'] = 50000;
$sugar_config['resource_management']['special_query_modules'][] = 'Accounts';

The process times out when it reaches max_execution_time as specified in php.ini

Will try increasing the memory limit

4

Have increased php memory to 2048M and execution time to 10 minutes - still times out after 10 minutes.

5

You need to check your php_errors.log (or whatever your web server log is called), there should be some clues there.

6

Have finally obtained a server with recent version of Fedora, so PHP version allows upgrade. Upgrade to SuiteCRM 7.6.10 seems to have fixed the problem - the target list generation which was previously timing out after ten minutes now goes through in about twenty seconds. So presume that the PHP settings were a red herring, and there was simply a problem with the code in the previous SuiteCRM version.