I encountered a similar error while running the below query:
Select count(Field) from Table
The error was:
External search command 'dbxquery' returned error code 1. Script output = " ERROR "Exception at ""/opt/splunk/etc/apps/splunk_app_db_connect/bin/dbxquery.py"", line 123 : com.microsoft.sqlserver.jdbc.SQLServerException: No column name was specified for column 1 of 't'.
I changed the query to:
Select count(Field) as count_Field from Table
This resolved the issue. Thought I'd share this.
... View more