Page 1 of 2
All dashboards disappeared, that dashboard is not valid...
Posted: Thu Jun 02, 2016 6:56 am
by rjjimenez
Hi
We were adding dashlet in dashboads and we have received the following error:
Bad Dashboard
Unfortunately for you, that dashboard is not valid... Too bad. Dashboard ID: fnrkq5k7
Now when we look dashboards, all they are gone.
Attached the screenshot of the error, http nagios logs and also the result of the dashboard in database.
NagiosXI Entreprise 5.2.3
Best regards
Re: All dashboards disappeared, that dashboard is not valid.
Posted: Thu Jun 02, 2016 12:40 pm
by lmiltchev
What dashlet were you adding to your dashboards? What is the user that you were logged in as while trying to view the dashboard - nagiosadmin, other user (admin, regular user, read-only user)? Do ALL users have issues with accessing the dashboard?
Re: All dashboards disappeared, that dashboard is not valid.
Posted: Fri Jun 03, 2016 3:57 am
by rjjimenez
Hi
We were logged with the nagiosadmin user and we were adding service graphics.
Only disappeared the nagiosadmin user dashboars, the others users dashboards work correctly.
Best Regards
Re: All dashboards disappeared, that dashboard is not valid.
Posted: Fri Jun 03, 2016 1:35 pm
by ssax
First, take an XI backup:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
You may have so much data in there that you're hitting the max byte limit of the DB field type, change the field type so that it will support at least 4GB by running this command:
Code: Select all
echo "alter table xi_usermeta modify keyvalue LONGTEXT;" | mysql -uroot -pnagiosxi nagiosxi
Now you should not experience the issue going forward.
You may need to delete what dashboards you currently have setup:
Code: Select all
echo "delete from xi_usermeta where keyname = 'dashboards';" | mysql -uroot -pnagiosxi nagiosxi
Let us know the results.
Re: All dashboards disappeared, that dashboard is not valid.
Posted: Mon Jun 06, 2016 9:43 am
by vAJ
Just had this happen to my Network Engineering director... I'm trying the fix now as well, will report back success or fail.
He's tearing up over our IM session right now. ;(
Re: All dashboards disappeared, that dashboard is not valid.
Posted: Mon Jun 06, 2016 9:52 am
by vAJ
Do they really lose all of that dashboard data?
I'm going to have some very unhappy people today...
Re: All dashboards disappeared, that dashboard is not valid.
Posted: Mon Jun 06, 2016 11:14 am
by ssax
The problem is that the data is serialized, let me see if I can come up with a workaround to losing the data.
Re: All dashboards disappeared, that dashboard is not valid.
Posted: Mon Jun 06, 2016 2:59 pm
by ssax
Do you still have the broken dashboards, if so, please run this command and PM me the data:
Code: Select all
echo "select * from xi_usermeta where keyname = 'dashboards';" | mysql -uroot -pnagiosxi nagiosxi
Thank you
Re: All dashboards disappeared, that dashboard is not valid.
Posted: Thu Jun 16, 2016 9:44 am
by ssax
Did that data that you PM'd contain the broken data? I'm unable to figure out what is wrong with it, the data unserializes properly and it doesn't look like it hit the byte limit. Have you deleted and tried to recreate to see if they show up?
Re: All dashboards disappeared, that dashboard is not valid.
Posted: Wed Jul 27, 2016 9:22 am
by vAJ
Man, I dropped the ball on this.
Are you suggesting that if we delete a given dashboard (which currently shows nothing) and recreate with the same name we potentially will get the dashboard contents back?