Splunk DB Connect: Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255

[baigura]

Hello,

I have an odd problem with db_connect :

My connection is ok

I can see the database and the tables but when i try to query (basic select) i have an error

Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255

My query is simple | dbxquery query="SELECT * FROM sys.sys_config" connection="da" even select 1 from dual doesn't work

Database : MySQL 5.7
User : root privileges
Splunk 6.6.0
DB connect 3.1.1
Java 8

[geonspapa]

In my case, JVM options was empty in the settings.
I click reset and save. it work.
OR write follow.

-Ddw.server.applicationConnectors[0].port=9998

[VijaySrrie]

May I know where to write the below line

-Ddw.server.applicationConnectors[0].port=9998

[baigura · Accepted solution]

I have downgraded DB connect (from 3.1.1 to 2.4.1) and now it works