Nagios Support Forum

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.

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?

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.

Did you see any other issues?

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?

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