Splunk Search

DB Connect App Error Code 47

ShaneNewman
Motivator

I have setup a MSSQL database connection using the DB Connect App, this database does have a specific port. When setting up the database, I can query the table list inside of the database from the setup screen. Once the connection has been established, any attempt to get any sort of info from the database returns this error message: "External search command 'dbinfo' returned error code 47."

Any ideas what is going on or how to correct it? All of the other database connections are working fine and the bridge is running.

0 Karma
1 Solution

ShaneNewman
Motivator

Turns out that the app does not like "\" in the name of the database instance. Removing the "\" corrected the problem.

View solution in original post

0 Karma

bowendenning
Path Finder

Just wanting to add my findings here too as I've also been receiving this error.

What I found is that the Java bridge may not start immediately after a restart of Splunk. In our environment it can take anywhere up to 15-20 minutes for it to come up (possibly due to the number of DB's we're pulling data from?) and during that time trying it will return an error code of 47 in various parts of the DBX dashboard.

Long story short, if you're getting this error code and the Java bridge is now running then maybe give it 30 minutes before assuming that things are busted.

0 Karma

ShaneNewman
Motivator

Turns out that the app does not like "\" in the name of the database instance. Removing the "\" corrected the problem.

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