All Apps and Add-ons

Splunk DB Connect: What config file and what syntax is needed to set shortnames to false?

jgaudett
New Member

I'm receiving an error as follows:

java.lang.IllegalStateException: Column name conflicted, please set shortnames option to false and retry

I receive this error when I execute the SQL on the 1st screen when trying to create a new input.

I can't seem to find documentation that explains which config file to put this and the syntax.

0 Karma

jgaudett
New Member

Thanks for the quick response - I'm not using dbxquery - this is in the New Input screen where I've entered the SQL code in the SQL Editor - Are you saying I need to enter the SQL with the dbxquery command syntax in the SQL Editor portion of the DBConnect input screen?

I was thinking I would be able to enter the shortnames = t/f somewhere in one of the config files (db_connections.conf or dbx_settings.conf)?

0 Karma

jkat54
SplunkTrust
SplunkTrust

I know you set shortnames=true to override the default of false when using the dbxquery command like below:

| dbxquery shortnames=true query=...

If you just remove shortnames=true then it should default to false

| dbxquery query=...
0 Karma

jgaudett
New Member

Thanks for the quick response - I'm not using dbxquery - this is in the New Input screen where I've entered the SQL code in the SQL Editor - Are you saying I need to enter the SQL with the dbxquery command syntax in the SQL Editor portion of the DBConnect input screen?

I was thinking I would be able to enter the shortnames = t/f somewhere in one of the config files (db_connections.conf or dbx_settings.conf)?

Sorry, put the comment in the wrong place above...

0 Karma
Get Updates on the Splunk Community!

Developer Spotlight with William Searle

The Splunk Guy: A Developer’s Path from Web to Cloud William is a Splunk Professional Services Consultant with ...

Major Splunk Upgrade – Prepare your Environment for Splunk 10 Now!

Attention App Developers: Test Your Apps with the Splunk 10.0 Beta and Ensure Compatibility Before the ...

Stay Connected: Your Guide to June Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...