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