Attempting to Manage Dashboards in Fusion 4.1.5, the option to delete any dashboard results in error: "There was an error deleting the specified dashboards." Additionally, there are two "Home Dashboard" due to a sync.
Please advise.
Dashboards cannot be deleted.
Dashboards cannot be deleted.
You do not have the required permissions to view the files attached to this post.
Nagios XI 5.9.1 (8 Servers)
Nagios Fusion 2024R1.0.2
Nagios Fusion 2024R1.0.2
-
- Support Tech
- Posts: 3457
- Joined: Mon May 15, 2017 5:00 pm
Re: Dashboards cannot be deleted.
Hello, @TBT. How long ago did this start happening?
You may run the following query to check the dashboards ID numbers:
If you create a new dashboard will you be able to remove it or no?
You may run the following query to check the dashboards ID numbers:
And then once you know the dashboard's ID use the following query to remove it:echo 'select * from dashboards;' |mysql -t -u fusion -pfusion fusion
*Replace 2 with the actual numberecho "delete from dashboards WHERE dashboard_id='2';" |mysql -t -u fusion -pfusion fusion
If you create a new dashboard will you be able to remove it or no?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Re: Dashboards cannot be deleted.
Just noticed today while doing some custom Dashlet development. Could have been a series of events, or present all along.
I've also noticed when syncing a dashboard it duplicates the URL on the left side menu, but with a different ID. The following dashboards cannot be deleted by any of the users (all admin) from within the GUI.
User1 can view ID 9, 10, 12
User2 can view ID 13, 14, 16
User3 can view ID 17, 18, 20
ID 37, 38, 39 cannot be viewed by any users.
+--------------+---------+----------------+------+------+--------+--------------+---------+-----------+-----------+
| dashboard_id | user_id | dashboard_name | sync | home | screen | show_in_menu | bgcolor | dashlet_x | dashlet_y |
+--------------+---------+----------------+------+------+--------+--------------+---------+-----------+-----------+
| 9 | 1 | Home Dashboard | 3 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 10 | 1 | NOC Dashboard | 5 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 12 | 1 | Test Dashboard | 8 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 13 | 2 | Home Dashboard | 3 | 0 | 0 | 1 | ffffff | 90 | 90 |
| 14 | 2 | NOC Dashboard | 5 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 16 | 2 | Test Dashboard | 8 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 17 | 3 | Home Dashboard | 3 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 18 | 3 | NOC Dashboard | 5 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 20 | 3 | Test Dashboard | 8 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 24 | 3 | Test | 0 | 0 | 0 | 1 | f3f3f3 | 50 | 50 |
| 37 | 1 | SCREEN | 7 | 0 | 1 | 0 | ffffff | 10 | 10 |
| 38 | 2 | SCREEN | 7 | 0 | 1 | 0 | ffffff | 10 | 10 |
| 39 | 3 | SCREEN | 7 | 0 | 1 | 0 | ffffff | 10 | 10 |
+--------------+---------+----------------+------+------+--------+--------------+---------+-----------+-----------+
I've gone ahead and deleted all IDs and recreated "Home Dashboard" which can now be deleted via the GUI as the UID that created the dashboard., I will test syncing and report back if issues remain.
I've also noticed when syncing a dashboard it duplicates the URL on the left side menu, but with a different ID. The following dashboards cannot be deleted by any of the users (all admin) from within the GUI.
User1 can view ID 9, 10, 12
User2 can view ID 13, 14, 16
User3 can view ID 17, 18, 20
ID 37, 38, 39 cannot be viewed by any users.
+--------------+---------+----------------+------+------+--------+--------------+---------+-----------+-----------+
| dashboard_id | user_id | dashboard_name | sync | home | screen | show_in_menu | bgcolor | dashlet_x | dashlet_y |
+--------------+---------+----------------+------+------+--------+--------------+---------+-----------+-----------+
| 9 | 1 | Home Dashboard | 3 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 10 | 1 | NOC Dashboard | 5 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 12 | 1 | Test Dashboard | 8 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 13 | 2 | Home Dashboard | 3 | 0 | 0 | 1 | ffffff | 90 | 90 |
| 14 | 2 | NOC Dashboard | 5 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 16 | 2 | Test Dashboard | 8 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 17 | 3 | Home Dashboard | 3 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 18 | 3 | NOC Dashboard | 5 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 20 | 3 | Test Dashboard | 8 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 24 | 3 | Test | 0 | 0 | 0 | 1 | f3f3f3 | 50 | 50 |
| 37 | 1 | SCREEN | 7 | 0 | 1 | 0 | ffffff | 10 | 10 |
| 38 | 2 | SCREEN | 7 | 0 | 1 | 0 | ffffff | 10 | 10 |
| 39 | 3 | SCREEN | 7 | 0 | 1 | 0 | ffffff | 10 | 10 |
+--------------+---------+----------------+------+------+--------+--------------+---------+-----------+-----------+
I've gone ahead and deleted all IDs and recreated "Home Dashboard" which can now be deleted via the GUI as the UID that created the dashboard., I will test syncing and report back if issues remain.
Nagios XI 5.9.1 (8 Servers)
Nagios Fusion 2024R1.0.2
Nagios Fusion 2024R1.0.2
Re: Dashboards cannot be deleted.
Did you see any other issues?
Re: Dashboards cannot be deleted.
Was able to clean-up the unmanageable Dashboards.ssax wrote:Did you see any other issues?
Can you further explain why synced Dashboards get duplicated (link) on the side menu with a new id, rather update the original?
You do not have the required permissions to view the files attached to this post.
Nagios XI 5.9.1 (8 Servers)
Nagios Fusion 2024R1.0.2
Nagios Fusion 2024R1.0.2
-
- Support Tech
- Posts: 3457
- Joined: Mon May 15, 2017 5:00 pm
Re: Dashboards cannot be deleted.
@TBT, I believe this was done by design. During the deployment, Fusion creates a copy of the dashboard for the new user with a different ID. In cases when the second user already made some changes to the dashboard we don't want to override them.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.