How to disable incremental synchronization for an external directory through the database
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
The content on this page relates to direct database modifications which are not supported. Consequently, Atlassian Support cannot guarantee providing any support for it. Please be aware that this material is provided for your information only and using it is done so at your own risk. See our page on configuring user directories for reference on how to configure this through the UI.
Purpose
You might want to disable incremental synchronization in Confluence for an external directory. Sometimes having the Crowd SSO authenticator enabled or not having an internal administrator in place can complicate things, so this can be done through the database.
Solution
- Shutdown Confluence and backup your database before making any of these changes.
Run the following to find the name of the external directory for which you want to disable incremental syncs:
SELECT directory_name FROM cwd_directory WHERE directory_type != 'INTERNAL'Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Run the following to disable the incremental synchronization:
update cwd_directory_attribute set attribute_value = 'false' where attribute_name = 'crowd.sync.incremental.enabled' and directory_id = (select id from cwd_directory where directory_name = 'YOUR_DIRECTORY_NAME');Restart Confluence
- Trigger another synchronization through Confluence Admin -> General configuration -> User directories -> Your directory -> Synchronize