Dashboards cannot be deleted.

This support forum board is for questions relating to Nagios Fusion.
Locked
TBT
Posts: 609
Joined: Wed May 18, 2011 1:26 pm

Dashboards cannot be deleted.

Post by TBT »

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.
dash.PNG
You do not have the required permissions to view the files attached to this post.
Nagios XI 5.7.5 (9 Servers)
Nagios Fusion 4.1.9
npolovenko
Support Tech
Posts: 3457
Joined: Mon May 15, 2017 5:00 pm

Re: Dashboards cannot be deleted.

Post by npolovenko »

Hello, @TBT. How long ago did this start happening?

You may run the following query to check the dashboards ID numbers:
echo 'select * from dashboards;' |mysql -t -u fusion -pfusion fusion
And then once you know the dashboard's ID use the following query to remove it:
echo "delete from dashboards WHERE dashboard_id='2';" |mysql -t -u fusion -pfusion fusion
*Replace 2 with the actual number

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.
TBT
Posts: 609
Joined: Wed May 18, 2011 1:26 pm

Re: Dashboards cannot be deleted.

Post by TBT »

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.
Nagios XI 5.7.5 (9 Servers)
Nagios Fusion 4.1.9
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Dashboards cannot be deleted.

Post by ssax »

Did you see any other issues?
TBT
Posts: 609
Joined: Wed May 18, 2011 1:26 pm

Re: Dashboards cannot be deleted.

Post by TBT »

ssax wrote:Did you see any other issues?
Was able to clean-up the unmanageable Dashboards.

Can you further explain why synced Dashboards get duplicated (link) on the side menu with a new id, rather update the original?
homedash.PNG
You do not have the required permissions to view the files attached to this post.
Nagios XI 5.7.5 (9 Servers)
Nagios Fusion 4.1.9
npolovenko
Support Tech
Posts: 3457
Joined: Mon May 15, 2017 5:00 pm

Re: Dashboards cannot be deleted.

Post by npolovenko »

@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.
Locked