Does anyone have the same problem?
dbxquery works, but dblookup doesn't work!
ERROR LOG:
10-31-2016 13:39:41.452 ERROR ScriptRunner - stderr from 'D:\Splunk\bin\PYTHON.EXE D:\Splunk\etc\apps\splunk_app_db_connect\bin\dbxlookup.py dblookup': Traceback (most recent call last):
10-31-2016 13:39:41.452 ERROR ScriptRunner - stderr from 'D:\Splunk\bin\PYTHON.EXE D:\Splunk\etc\apps\splunk_app_db_connect\bin\dbxlookup.py dblookup': File "D:\Splunk\etc\apps\splunk_app_db_connect\bin\dbxlookup.py", line 114, in
10-31-2016 13:39:41.452 ERROR ScriptRunner - stderr from 'D:\Splunk\bin\PYTHON.EXE D:\Splunk\etc\apps\splunk_app_db_connect\bin\dbxlookup.py dblookup': raise ex
10-31-2016 13:39:41.452 ERROR ScriptRunner - stderr from 'D:\Splunk\bin\PYTHON.EXE D:\Splunk\etc\apps\splunk_app_db_connect\bin\dbxlookup.py dblookup': avro.ipc.AvroRemoteException: java.lang.IllegalArgumentException: ui_query_table is a mandatory configuration to build single table lookup.
10-31-2016 13:39:41.974 ERROR LookupOperator - Script for lookup table 'db_connect_dblookup' returned error code 1. Results may be incorrect.
QUERY:
|dbxquery shortnames=t query="SELECT USER_ID,NAME FROM where NAME IS NOT NULL" connection="oralceConnection" wrap=t |fields - _raw _time |lookup db_connect_dblookup USER_ID AS USER_ID
... View more