Troubleshooting Tip: Unable to find 'admin' in table 'system.admin'

FortiGate# exec switch-controller get-conn-status

S424EITF21xxxxxx v7.2.2 (419) Authorized/Up E 11.10.10.8 Mon Feb 20 19:47:08 2023

FortiGate# exec switch-controller get-sync-status all SWITCH (NAME) STATUS CONFIG MAC-SYNC HTTP-UPGRADE S424EITF21xxxxxx Up Error - - "error_reason":"unable to find 'admin' in table 'system.admin'"

The error occurs when the administrator deletes the admin account from the FortiSwitch. For example:

Login to FortiSwitch -> Create a new admin account and delete the original admin account.

FortiSwitch# config system admin
    edit "admin"
        set accprofile "super_admin"
        set password xxxxx
    next
    edit "superadmin"
        set accprofile "super_admin"
        set password yyyyy
    next
end

FortiSwitch#(admin) # delete admin

FortiSwitch#(admin) # end

Solution:

On the FortiGate, disable login password override:

FortiGate# config switch-controller switch-profile
    edit "default"
        set login-passwd-override disable
end