Hi,
I'm on Sugar 8.0.1 and have setup Teams Denormalisation as per Performance Improvement through Teams Denormalisation
After setting Team Security, status showed the Active table set to team_sets_users_2 and the count in team_sets_users_2 table was more than 2 million. The scheduler Rebuild Denormalized Team Security Data was active and executed every 15 minutes
bin/sugarcrm team-security:status
+--------------------+-------------------+
| Parameter | Value |
+--------------------+-------------------+
| Enabled | Yes |
| Active table | team_sets_users_2 |
| Up to date | No |
| Rebuild is running | Yes |
+--------------------+-------------------+
Upon checking the team security status after a day, the active table was set to None in spite of Rebuild Denormalized Team Security Data running every 15 minutes. The value in team_sets_users_2 table was empty (team_sets_users_1 was also empty by default). Not sure how the table data has been purged automatically
bin/sugarcrm team-security:status
+--------------------+-------------------+
| Parameter | Value |
+--------------------+-------------------+
| Enabled | Yes |
| Active table | None |
| Up to date | No |
| Rebuild is running | Yes |
+--------------------+-------------------+
Is this because of any Config change or does repairing teams cause this? Any help would be highly appreciated!
Thanks in Advance