FortiNAC
NOTE: FortiNAC is now named FortiNAC-F. For post-9.4 articles, see FortiNAC-F. FortiNAC is a zero-trust network access solution that provides users with enhanced visibility into the Internet of Things (IoT) devices on their enterprise networks.
ebujedo
Staff
Staff
Article Id 206710
Description

This article describes workarounds for two errors:

 

1) 'Failure: Failed to retrieve Activities' when opening the Scheduler.

2) 'Failure: Failed to retrieve table properties'.

Scope Any supported version of FortiNAC.
Solution

1) 'Failure: Failed to retrieve Activities'

 

When trying to access the scheduler, the following error may appear:

 

Sx11_0-1676551671858.png

 

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.

 

Sx11_1-1676551922369.png

 

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.

Contributors