RESOLVED: Dashboard load shows Datatables warning

[gregbeyer]

I've created a dashboard with several BBMap dashlets in it, showing different hostgroups. It loaded OK for a while, but has now started throwing Datatable warning messages, such as this shown.

datatable_warning.png

. Then the dashlets say no data.

Since I created this dashboard from a Nagios provided dashlet, I've no idea how to fix it. Why would the column count be wrong? Nor do I understand why XI directs me to some external site for guidance on fixing a Nagios dashlet problem.

Reloading the dashboard repeatedly might get one or more of the dashlets to load normally with data. If I deploy this dashboard to others, I don't need it throwing errors (IOW it's not reliable) and confusing people.

Anyone else seen this, knows how to fix it?

[lgute]

Hi @gregbeyer, thanks for reaching out.

This is a known issue. I increased the priority, based on your report. I can not give you a timeframe for a fix, but if you want to check the changelog yourself without checking in with us, the tracking number for this bug is GL:XI#1052.

[gregbeyer]

Hello @lgute. Changelog doesn't show anything until after a release. AFAIK there is no forward-looking development roadmap for Nagios shared with the public (pitty). In a previous post I was informed that there is no way for external-to-nagios customers to see the details of an issue even if they have a number. What am I supposed to do with the bug number?

[lgute]

Hi @gregbeyer,

When the issue has been resolved, the issue numbers are listed in the Changelog. Just trying to provide a way for you to check for a resolution yourself. You are welcome to contact Customer Support, if you want more information.

[jsimon]

Hi Greg,

I wanted to follow up with my findings on this one, as I was digging into it to fix the bug. What I found is that this DataTables error occurs when the chart we generate for BBMap has no data. Generally this should never happen, as without any other hosts being monitored you would always at least be monitoring localhost, however if that breaks for some reason, this column count error displays. I'm correcting the issue that causes this message to display when this occurs, as I agree we should not be linking you outside of XI for a solution, however I wanted to let you know about this ASAP because my fix for this won't entirely fix your issue.

If you're consistently seeing "No data to display" in your BBMap, I believe the actual issue is that the data being pulled for that dashlet isn't correct. My first thought is to try running the repair_databases script:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

.

The issue number you were provided to track this issue in our changelog will still be valid as far as the fix to the DataTables warning, but I wanted to let you know my findings ASAP.

[gregbeyer]

Thanks. No, I'm not seeing the error consistently. It is intermittent and 1, 2, 3, 4 or more reloads of the dashboard will finally get all BBMaps to load. I'll try running repair_databases.

[gregbeyer]

Have marked this resolved. After running repair_databases.sh, I'm not seeing any more of these errors. Thanks for that recommendation @jsimon.

For future reference, is there any danger / problem with just running repair_databases any time I have Nagios behaving with inexplicable wigginess? Even if I don't know that it is a database problem? It seems that the database does have troubles kind of often, and if that's an easy try-first fix, I'm all for it.

Thanks for the help.

[cnorell]

gregbeyer,

There is no danger in running repair_databases.sh. It's a solid quick and easy step in troubleshooting issues in XI.

Best Regards,

Cory Norell