by eggsurplus

Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.

Cancel at any time!
Free Trial

#1131 - Table securitygroups_records 20M records 11GB!!!

Closed Bug? created by joseblas1 Verified Purchase 4 years ago

Hi Jason,

I have installed SecurityGroups feature limited version 2.7.4 and I have noticed that the table securitygroups_records has growth to 20 million records and 11GB size, this is too much!!!

What steps can I take to reduce the size of this table?

I have configured 4 security groups with languages and users within these languages for assigning tasks and records based on the language of my CRM users. I have the default configuration on, I don't know where to start slimming down this table...

Can you help? Thanks!

  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    4 years ago

    Hello Jose,

    Check out this support case for guidance on how to address this:

    https://www.sugaroutfitters.com/support/securitysuite/496

    Also delete anything in the securitygroups_records table that is related to SchedulersJobs. Make sure to backup the database before doing anything.

  2. joseblas1 member avatar

    joseblas1 Verified Purchase

    4 years ago

    Hi Jason, thanks for quick response.

    I have deleted some records from the DB, everything inside securitygroups_records for the modules SchedulerJobs and ProcessAudits and some records from AOW_processed.

    My question now is how I control so securitygroups doesn't create a record for each processaudit and schedulerJobs? I thought about creating a workflow that cleans regularly these records but it seems that processaudit is not available as record in AOW.

    Is there a configuration so securitygroups ignores these records?

    Thanks.

    Jose.

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      4 years ago

      Hi Jose,

      Sorry, I thought I replied to this, but I guess the day's events just pulled me away. Within modules/SecurityGroups/SecurityGroups.php in the getSecurityModules() function (around line 536 depending on your version) there is a $module_blacklist array. If there isn't, please upgrade to the latest SugarCRM and install the matching SecuritySuite version or if you are up to it then download the latest SecuritySuite code here and compare and migrate the code for your version. Just add the Process Audits and AOW_processed modules to that array so that they do not get added.

      SchedulersJobs records shouldn't show in securitygroups_records anymore since it is in this new module_blacklist array. If they still are then you may be on a version that doesn't have this new change anymore.

      Hope that helps!
      -Jason

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.