topic Re: Splunk DB Connect: What config file and what syntax is needed to set shortnames to false? in All Apps and Add-ons

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

jgaudett — Wed, 07 Aug 2019 20:43:28 GMT

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.

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

jkat54 — Thu, 08 Aug 2019 00:48:38 GMT

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

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

jgaudett — Wed, 30 Sep 2020 01:40:00 GMT

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)?

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

jgaudett — Wed, 30 Sep 2020 01:40:03 GMT

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