AnsweredAssumed Answered

Team security denormalisation's active table is set to None automatically

Question asked by Venkatesh Babu on Jan 25, 2019

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 

Outcomes