Hello,
We recently installed Feature Toggle from the forge in our environments and having issue with Feature Toggle Management application.
The issue is that after saving a Feature Toggle with any team specified in 'Teams' field of the form, the Advanced SQL query GetFeatureToggleConfigurationWithTags fails execution with timeout exception. After this it becomes impossible to see the list of toggles on the Feature Toggle Management dashboards FT List. So, it becomes impossible to use the application. After about 10 minutes or more, page opens as expected, so mentioned query is succesfullyexecuting.
The GetFeatureToggleConfigurationWithTags query location is FeatureToggle_Mng module, FeatureToggleManagement screen, GetFeatureToggleListForAllEnvironments data action.
Please see the attached file with detailed error message.
After investigation of the reason of the issue we figured out that there are 91056 records in LifetimeTeamUser entity table which is result of duplicates. The LifetimeTeamUser entity is joined seven times in GetFeatureToggleConfigurationWithTags query and all this together causes the timeouts.
In the LifetimeTeamUser entity table there are 13 unique LIFETIMETEAMID values, 33 unique USERID values and 6 unique ENVIRONMENTKEY values.
You can execute following query to check for the duplicates:
select userid,LIFETIMETEAMID, count(ENVIRONMENTKEY) ENVIRONMENTKEY from [OUTSYSTEMS].dbo.[OSUSR_S65_LIFETIMETEAMUSER]group by userid,LIFETIMETEAMIDorder by 1;
The reason of the duplicated records should be issue with Timer_LifetimeTeams_Sync timer logic.
Additionally, in GetFeatureToggleConfigurationWithTags query LifetimeTeamUser entity records are filtered with UserId and EnvironmentKey attributes which do not have related indexes and in case of huge amount of record impacts the performance.
Hope this information will help to resolve the issue and release new fixed version of the Feature Toggle Management forge application.
Best Regards
Mikheil Osipov
Hello Mikheil,
thank you for bringing this issue to our attention.
When you execute the following query on the entity LifeTimeTeamUser, how many results do you get?
SELECT LifetimeTeamId, UserId, EnvironmentKey, HasChangePermissions, COUNT(*) AS DuplicateCountFROM {LifetimeTeamUser}GROUP BY LifetimeTeamId, UserId, EnvironmentKey, HasChangePermissionsHAVING COUNT(*) > 1;
I ran the query you shared to list duplicates and indeed i get them due to not including the environment on the query. if i do, i get no duplicates on my side.
Looking forward to hear from you.
Cheers!
Hello Bruno,
Thank you for your response.
There are several thousands of duplicate records is the result of the query you asked to execute, and that number is growing after each execution of the FeatureToggleTeams_Sync timer.
On the screenshot below you can see the actual duplicated data for LifetimeTeamId, UserId, EnvironmentKey, HasChangePermissions columns.
Thank you.
Hey Mikheil Osipov,I am assuming you are using the last version of the Feature Toggle, are you?This last feature is missing a check, which indeed is causing duplicates in that entity.
Also noticed a bug on the teams and tags while managing the feature toggle.
Can you please confirm that you are using the last version and you have the site property EnableLifetimeServiceAccount set to true under the FeatureToggleManagement_CS module?
Thank you for the update.
I confirm that the site property EnableLifetimeServiceAccount is set to true under the FeatureToggleManagement_CS module.
Also, I confirm that we are using latest version, which is 1.0.8.
Waiting for next updates from you.
Hey Mikheil,
thank for waiting. I just released a fix for the points you have mentioned as well a set of timers to backup the feature toggle team assignments and remove the duplicates.
Please take a look.
Looking forward for your feedback.
Thank you for the update and sorry for late response, only today we were able to deploy the change and test it.
The result is same. The issue is still there.
After each run of FeatureToggleTeams_Sync timer the number of records in LifetimeTeamUser is increasing.
We have tested version 1.0.11 and the issue is resolved in
Thank you very much.
Best Regards,
Hello @Bruno Machado ,Thenk you for your help on this feed.I have the same problem, even if we have version 1.0.1 installed since April 9th 2026. The Advanced SQL query GetFeatureToggleConfigurationWithTags fails execution with timeout exception when some user enter to the Homepage. Only some Users has this problem, not all of them. The problem started just started las week. Before that nobody had this problem in our project.Do you know why the fixed version is not working forus?Thank you and Best Regards.
Solved, I found the timers that the FT developer provided in order to remove duplicated data and fis the problem. Thanks