Bug ID 498038: Config sync failed with foreign key index (aaa_active_directory_server_FK) error after deleting AAA AD server with tmsh.

Last Modified: Apr 10, 2019

Bug Tracker

Affected Product:  See more info
BIG-IP APM(all modules)

Known Affected Versions:
11.5.0, 11.5.1, 11.5.1 HF1, 11.5.1 HF10, 11.5.1 HF11, 11.5.1 HF2, 11.5.1 HF3, 11.5.1 HF4, 11.5.1 HF5, 11.5.1 HF6, 11.5.1 HF7, 11.5.1 HF8, 11.5.1 HF9, 11.5.2, 11.5.2 HF1, 11.5.3, 11.5.3 HF1, 11.5.3 HF2, 11.5.4, 11.5.4 HF1, 11.5.4 HF2, 11.5.4 HF3, 11.5.4 HF4, 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.6.0, 11.6.0 HF1, 11.6.0 HF2, 11.6.0 HF3, 11.6.0 HF4, 11.6.0 HF5, 11.6.0 HF6, 11.6.0 HF7, 11.6.0 HF8, 11.6.1, 11.6.1 HF1, 11.6.1 HF2, 11.6.2, 11.6.2 HF1, 11.6.3, 11.6.3.1, 11.6.3.2, 11.6.3.3, 11.6.3.4, 11.6.4

Fixed In:
12.0.0

Opened: Dec 22, 2014
Severity: 3-Major
Related AskF5 Article:
K16630

Symptoms

Config sync failed with foreign key index (aaa_active_directory_server_FK) error after deleting AAA AD server with tmsh.

Impact

Sync failure.

Conditions

- Create AAA AD server with pool. - Delete AAA AD server created. - Run a config sync with 'Full Sync' enabled.

Workaround

You can use either of these workarounds: -- Use the GUI to delete AAA AD server. -- Use guishell command to delete the dangling aaa_active_directory_domain_controller object. To do so, follow this procedure: 1. guishell -c "delete from aaa_active_directory_domain_controller where aaa_active_directory_server_name='/Common/aaa-test-object'". 2. Perform the procedure from SOL13030: Forcing the mcpd process to reload the BIG-IP configuration, available here: https://support.f5.com/kb/en-us/solutions/public/13000/000/sol13030.html.

Fix Information

Config sync with Full Sync enabled now succeeds after AAA AD server with pool is deleted.

Behavior Change