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!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...