Hi, I have installed DB connect 2 on my splunk server to retrieve data from a remote database.
After setup the identity and connection, it shows that it is a "Valid connection".
But in the query tab, it shows "No catalog found".
I switch to Advanced Query Mode, and the query is "SELECT * FROM myTable", the following error message is shown:
External search command 'dbxquery' returned error code 1. First 1000 (of 1061) bytes of script output: " ERROR "Exception at ""C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\bin\dbxquery.py"", line 82 : {""messages"":[{""type"":""WARN"",""text"":""Traceback (most recent call last):\r\n File \""C:\Program Files\Splunk/bin/rest_handler.py\"", line 78, in <module>\r\n print splunk.rest.dispatch(**params)\r\n File \""C:\Program Files\Splunk\Python-2.7\Lib\site-packages\splunk\rest\init.py\"", line 215, in dispatch\r\n responseObject.write(json.dumps(feed.asJsonStruct(), separators=(',', ':')))\r\n File \""C:\Program Files\Splunk\Python-2.7\Lib\json\init.py\"", line 250, in dumps\r\n sort_keys=sort_keys, **kw).encode(obj)\r\n File \""C:\Program Files\Splunk\Python-2.7\Lib\json\encoder.py\"", line 230, in encode\r\n chunks = self.iterencode(o, _one_shot=True)\r\n File \""C:\Program Files\Splunk\Python-2.7\Lib\json\encoder.py\"", line 293, in iterencode\r\n return _iterencode(o, 0)\r\nUnicodeDecodeError: 'utf8' codec can't decode"
If anyone has the same problem? Any help is appreciated.
... View more