Riva CRM Integration - Documentation and Knowledge Base

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

Article ID: 93
Last updated: 19 Sep, 2023

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)
      6 => 'Contacts', // To increase the query limit of 1,000 reached for Contacts module to "special_query_limit" (50,000)
      7 => 'Leads', // To increase the query limit of 1,000 reached for Leads module to "special_query_limit" (50,000)
      8 => 'Meetings', // To increase the query limit of 1,000 reached for Meetings module to "special_query_limit" (50,000)
      9 => '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)
      6 => 'Contacts', // To increase the query limit of 1,000 reached for Contacts module to "special_query_limit" (50,000)
      7 => 'Leads', // To increase the query limit of 1,000 reached for Leads module to "special_query_limit" (50,000)
      8 => 'Meetings', // To increase the query limit of 1,000 reached for Meetings module to "special_query_limit" (50,000)
      9 => '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,
  )
;

This article was:   Helpful | Not helpful
Report an issue
Article ID: 93
Last updated: 19 Sep, 2023
Revision: 6
Views: 15565
Comments: 0
Also listed in