Troubleshooting Tip: How to correct the 'Failed to retrieve Activities' error in System -> Scheduler

[blarochelle]

Description	This article describes how to correct the 'Failed to retrieve Activities' error in System -> Scheduler.
Scope	FortiNAC-C / FortiNAC-F All Versions.
Solution	The following error can be disabled in System -> Scheduler due to an error in the database: FortiNAC-C Solution: Log into the CLI as the root user. Run the command: scheduler -all Note the output. Look for an entry with N/A or some other malformed name in the entry. Note the ID number associated. Example output: schedule -all ID name previousScheduledTime scheduledTime pause hidden __ ________________________________ ____________________________ ____________________________ _____ ______ 1 System Backup Mon Mar 18 01:10:09 EDT 2024 Mon Mar 25 01:10:24 EDT 2024 false false 2 Database Archive and Purge Mon Mar 18 01:01:44 EDT 2024 Mon Mar 25 01:01:05 EDT 2024 false false 3 Certificate Expiration Monitor Thu Mar 21 10:00:00 EDT 2024 Fri Mar 22 10:00:00 EDT 2024 false false 4 Database BackUp Thu Mar 21 00:01:08 EDT 2024 Fri Mar 22 00:01:05 EDT 2024 false false 5 Auto-Definition Synchronizer Thu Mar 21 15:23:48 EDT 2024 Thu Mar 28 15:23:48 EDT 2024 false false 7 Operating System Update Status Sun Mar 17 13:01:00 EDT 2024 Sun Mar 24 13:01:00 EDT 2024 false false 10 Guest Report Thu Mar 21 15:19:00 EDT 2024 Thu Mar 21 16:19:00 EDT 2024 false false 11 grab-log-snapshot Thu Mar 21 12:27:03 EDT 2024 Fri Mar 22 12:27:03 EDT 2024 false false 12 Synchronize Users with Directory Thu Mar 21 09:54:53 EDT 2024 Fri Mar 22 09:54:53 EDT 2024 false false 14 CustomReport Thu Mar 21 13:10:00 EDT 2024 Fri Mar 22 13:10:00 EDT 2024 false false 19 test Thu Mar 21 16:02:00 EDT 2024 true false 20 testscript Thu Mar 21 14:40:21 EDT 2024 Thu Mar 21 15:40:21 EDT 2024 false false 21 N/A Thu Mar 21 15:32:04 EDT 2024 false false 26 emailGroupReportScheduledTask Thu Mar 21 16:54:00 EDT 2024 false false Note the following entry: 21 N/A Thu Mar 21 15:32:04 EDT 2024 false false ID associated is '21'. To remove the entry, run the command: schedule -delete -id <ID number> Example: schedule -delete -id 21 Refresh the System -> Scheduler view. FortiNAC-F Solution: Log into the CLI as the admin user. Run the command: execute enter-shell Run the command: scheduler -all Note the output. Look for an entry with N/A or some other malformed name in the entry. Note the ID number associated. Example output: schedule -all ID name previousScheduledTime scheduledTime pause hidden __ ________________________________ ____________________________ ____________________________ _____ ______ 1 System Backup Mon Mar 18 01:10:09 EDT 2024 Mon Mar 25 01:10:24 EDT 2024 false false 2 Database Archive and Purge Mon Mar 18 01:01:44 EDT 2024 Mon Mar 25 01:01:05 EDT 2024 false false 3 Certificate Expiration Monitor Thu Mar 21 10:00:00 EDT 2024 Fri Mar 22 10:00:00 EDT 2024 false false 4 Database BackUp Thu Mar 21 00:01:08 EDT 2024 Fri Mar 22 00:01:05 EDT 2024 false false 5 Auto-Definition Synchronizer Thu Mar 21 15:23:48 EDT 2024 Thu Mar 28 15:23:48 EDT 2024 false false 7 Operating System Update Status Sun Mar 17 13:01:00 EDT 2024 Sun Mar 24 13:01:00 EDT 2024 false false 10 Guest Report Thu Mar 21 15:19:00 EDT 2024 Thu Mar 21 16:19:00 EDT 2024 false false 11 grab-log-snapshot Thu Mar 21 12:27:03 EDT 2024 Fri Mar 22 12:27:03 EDT 2024 false false 12 Synchronize Users with Directory Thu Mar 21 09:54:53 EDT 2024 Fri Mar 22 09:54:53 EDT 2024 false false 14 CustomReport Thu Mar 21 13:10:00 EDT 2024 Fri Mar 22 13:10:00 EDT 2024 false false 19 test Thu Mar 21 16:02:00 EDT 2024 true false 20 testscript Thu Mar 21 14:40:21 EDT 2024 Thu Mar 21 15:40:21 EDT 2024 false false 21 N/A Thu Mar 21 15:32:04 EDT 2024 false false 26 emailGroupReportScheduledTask Thu Mar 21 16:54:00 EDT 2024 false false Note the following entry: 21 N/A Thu Mar 21 15:32:04 EDT 2024 false false ID associated is '21'. To remove the entry, run the command: schedule -delete -id <ID number> Example: schedule -delete -id 21 Refresh the System -> Scheduler view.