1) 'Failure: Failed to retrieve Activities'
When trying to access the scheduler, the following error may appear:
Workaround:
Run the following in the FortiNAC CLI:
# schedule -all
Some entries may appear without information after executing the following command:
ID name previousScheduledTime scheduledTime pause hidden __ ________________________________ ____________________________ ____________________________ _____ ______ 1 System Backup Sun Jan 31 20:40:42 CET 2021 Mon Feb 15 01:10:12 CET 2021 false false 2 Database Archive and Purge Sun Jan 31 20:31:48 CET 2021 Mon Feb 15 01:01:12 CET 2021 false false 3 Certificate Expiration Monitor Mon Feb 01 05:30:00 CET 2021 Wed Feb 10 05:30:00 CET 2021 false false 4 Database BackUp Sun Jan 31 19:31:18 CET 2021 Wed Feb 10 00:01:12 CET 2021 false false 5 Auto-Definition Synchronizer Sat Jan 30 20:31:00 CET 2021 Sat Feb 13 20:31:00 CET 2021 false false 6 Synchronize Users with Directory Sun Jan 31 21:31:00 CET 2021 Tue Feb 09 21:31:00 CET 2021 false false 7 Operating System Update Status Sun Jan 31 08:31:00 CET 2021 Sun Feb 14 08:31:00 CET 2021 false false 12 windows report Mon Feb 01 10:58:00 CET 2021 Tue Feb 09 10:58:00 CET 2021 false false 13 Rescan nac-test-agent Tue Feb 09 10:45:00 CET 2021 Tue Feb 09 11:45:00 CET 2021 false false 15 Scan failed report Mon Feb 01 06:54:00 CET 2021 Wed Feb 10 06:54:00 CET 2021 false false 16 N/A Mon Feb 01 06:12:00 CET 2021 Wed Feb 10 06:12:00 CET 2021 false false 17 Guest Report Tue Jan 26 06:54:00 CET 2021 Tue Feb 16 06:54:00 CET 2021 false false 18 Template Policy Report Mon Feb 01 03:17:00 CET 2021 Wed Feb 10 03:17:00 CET 2021 false false 19 scan failed Mon Feb 01 06:53:00 CET 2021 Wed Feb 10 06:53:00 CET 2021 false false 20 N/A Mon Feb 01 07:35:00 CET 2021 Wed Feb 10 07:35:00 CET 2021 false false 21 N/A Mon Feb 01 03:13:00 CET 2021 Wed Feb 10 03:13:00 CET 2021 false false 22 N/A Mon Feb 01 10:13:00 CET 2021 Tue Feb 09 11:13:00 CET 2021 false false 23 N/A Mon Feb 01 03:17:00 CET 2021 Wed Feb 10 03:17:00 CET 2021 false false 24 N/A Mon Feb 01 03:18:00 CET 2021 Wed Feb 10 03:18:00 CET 2021 false false 25 N/A Mon Feb 01 03:18:00 CET 2021 Wed Feb 10 03:18:00 CET 2021 false false 26 N/A Mon Feb 01 04:08:00 CET 2021 Wed Feb 10 04:08:00 CET 2021 false false 27 N/A Mon Feb 01 04:08:00 CET 2021 Wed Feb 10 04:08:00 CET 2021 false false 28 N/A Mon Feb 01 04:08:00 CET 2021 Wed Feb 10 04:08:00 CET 2021 false false 29 N/A Mon Feb 01 04:08:00 CET 2021 Wed Feb 10 04:08:00 CET 2021 false false 30 backup Sun Jan 31 12:42:00 CET 2021 Tue Feb 09 12:42:00 CET 2021 false false 31 system backup1 Wed Feb 10 07:03:00 CET 2021 false false
To fix this, log in to the FortiNAC CLI with root privileges and run the following to shut down management processes, then and perform the described actions to remove NULL entries in the scheduler:
# shutdownNAC sleep 15 mysql bsc -e "delete from SCHEDULER where name is NULL" sleep 5 startupNAC
2) 'Failure: Failed to retrieve table properties'
Users may see this error error when trying to access multiple sections in the FortiNAC GUI such as Inventory or Policies.
Tail the output.master file in the FortiNAC CLI to see related events such as the following:
yams INFO :: 2023-XX-XX XX:XX:23:604 :: #21210 :: UserBean: Invalid user key XXXXXXXXXXXXXXXXXXX
yams INFO :: 2023-XX-XX XX:XX:23:831 :: #75047 :: UserBean: Invalid user key XXXXXXXXXXXXXXXXXXX
The 'Invalid user key' errors are exceptions coming from requests that the UI attempts by using the current logged in user to get specific attribute data.
Workaround:
Manually create a new admin user or standard user and access FortiNAC with the new account.
|