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

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 (
      0 => 'Reports',
      1 => 'Export',
      2 => 'Import',
      3 => 'Administration',
      4 => 'Sync',

      5 => '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 (
      0 => 'Reports',
      1 => 'Export',
      2 => 'Import',
      3 => 'Administration',
      4 => 'Sync',

      5 => '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,
  )

;