Sugar: "Resource Management Error: Error Query Limit of 1000 Reached"

  • Updated

Issue

Riva Cloud or Riva On-Premise reports: "Resource Management Error: Error Query limit of 1000 reached".

Discussion

New features in Sugar 6 include SOAP resource management.

Possible Solutions

The solutions are the same for Riva Cloud and Riva On-Premise, because they are implemented in Sugar.

Disable resource management

Edit the file config_override.php

$sugar_config['resource_management'] NULL;

Increase the 1,000 query limit to 2,500

Edit the file config_override.php

$sugar_config['resource_management']['default_limit'] 2500;

 

Add module to "Special Query Limit"

You can add modules to the "special query limit" section.

Edit the file config_override.php

$sugar_config['resource_management']['special_query_modules'] 
    array (
      
=> 'Reports',
      
=> 'Export',
      
=> 'Import',
      
=> 'Administration',
      
=> 'Sync',

      => 'Accounts', // To increase the query limit of 1,000 reached for Accounts module to "special_query_limit" (50,000)
      => 'Contacts', // To increase the query limit of 1,000 reached for Contacts module to "special_query_limit" (50,000)
      => 'Leads', // To increase the query limit of 1,000 reached for Leads module to "special_query_limit" (50,000)
      => 'Meetings', // To increase the query limit of 1,000 reached for Meetings module to "special_query_limit" (50,000)
      => 'Calls', // To increase the query limit of 1,000 reached for Calls module to "special_query_limit" (50,000)
      10 => 'Tasks', // To increase the query limit of 1,000 reached for Calls module to "special_query_limit" (50,000)
    );

 

Override the entire "Resource Management" section

You can add modules to the "special query limit" section.

Edit file config_override.php

$sugar_config['resource_management'] 
  array (
    
'special_query_limit' => 50000,
    
'special_query_modules' => 
    array (
      
=> 'Reports',
      
=> 'Export',
      
=> 'Import',
      
=> 'Administration',
      
=> 'Sync',

      => 'Accounts', // To increase the query limit of 1,000 reached for Accounts module to "special_query_limit" (50,000)
      => 'Contacts', // To increase the query limit of 1,000 reached for Contacts module to "special_query_limit" (50,000)
      => 'Leads', // To increase the query limit of 1,000 reached for Leads module to "special_query_limit" (50,000)
      => 'Meetings', // To increase the query limit of 1,000 reached for Meetings module to "special_query_limit" (50,000)
      => 'Calls', // To increase the query limit of 1,000 reached for Calls module to "special_query_limit" (50,000)
      10 => 'Tasks', // To increase the query limit of 1,000 reached for Calls module to "special_query_limit" (50,000)
    ),
    
'default_limit' => 1000,
  )
;

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.