Dashboards & Visualizations

Dashboard panels not loading upon page refresh

ojasklowski
Explorer

I'm using a SQL query to populate panels in a dashboard. When I paste my query into the "edit search string" box, everything works. The data and plot display as expected.

When I click "done editing", everything is still good. I can click the refresh icon below the panel with no problems.

As soon as I refresh the page in the browser, though, I get "no results found" in the panel. The error message says:
'command="dbquery", A database error occured: You have an error in your SQL syntax...near " at line 1.

Weirder still, this only affects ~half of my panels, and there is no different in the query structure. Thoughts? Thanks in advance!

Tags (1)
0 Karma
1 Solution

ojasklowski
Explorer

@jkat54, thanks for the tip, that was a helpful wiki!

Ultimately, the comments in my sql code were causing the problem. When I paste it into splunk from my text editor, the formatting is preserved, so comments don't cause any problems. When I refresh the page, line breaks disappear, so the code no longer runs.

View solution in original post

ojasklowski
Explorer

@jkat54, thanks for the tip, that was a helpful wiki!

Ultimately, the comments in my sql code were causing the problem. When I paste it into splunk from my text editor, the formatting is preserved, so comments don't cause any problems. When I refresh the page, line breaks disappear, so the code no longer runs.

jkat54
SplunkTrust
SplunkTrust

Ah, so you've solved the problem?

0 Karma

ojasklowski
Explorer

Yes! Should I self-answer the question?

0 Karma

jkat54
SplunkTrust
SplunkTrust

Yep, i'll convert your comment to answer, you mark as answer.

0 Karma

ojasklowski
Explorer

thanks jkat54!

0 Karma

jkat54
SplunkTrust
SplunkTrust

YVW @ojasklowski ... see ya around!

0 Karma

jkat54
SplunkTrust
SplunkTrust

How many panels do you have? Curious if your hitting a limit of simultaneous searches for your user's role.

https://wiki.splunk.com/Community:TroubleshootingSearchQuotas

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...