topic Re: DB Connect SQL Explorer Not Working in All Apps and Add-ons

DB Connect SQL Explorer Not Working

alonsocaio — Mon, 29 Mar 2021 12:12:33 GMT

Hi,

I am trying to run some SQL queries using SQL Explorer on DB Connect app, but It looks like the queries are not finishing. Every query I execute keeps on 20% of completion and does not load any result.

Also, all of my inputs that are configured on DB Connect app are working as expected, the issue is happening only when I try configuring new inputs or when I use the SQL Explorer tab.

I have already tried to run the queries using different users and browsers, and I have already restarted Splunk service, but the issue is still occurring.

Does anyone has ever faced some issue like this one before on Db Connect? Any tips on what can be the cause of this error?

Thanks in advance.

Re: DB Connect SQL Explorer Not Working

alonsocaio — Mon, 29 Mar 2021 14:51:50 GMT

I was able to solve this issue by setting the dbxquery stanza under local/commands.conf

This stanza is commented under default/commands.conf, I had to add this to local so I could revert dbxquery to version 3.2.0

[dbxquery]
run_in_preview = false
filename = java.path
chunked = true
command.arg.1 = -Dlogback.configurationFile=../config/command_logback.xml
command.arg.2 = -DDBX_COMMAND_LOG_LEVEL=INFO
command.arg.3 = -cp
command.arg.4 = ../jars/dbxquery.jar
command.arg.5 = com.splunk.dbx.command.DbxQueryCommand

The solution was found on the following question: Splunk DB connect DBX Query error - Splunk Community