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

[jgaudett]

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.

[jgaudett]

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

[jkat54]

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

[jgaudett]

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