All Apps and Add-ons
Highlighted

Splunk DB Connect 2: How to resolve error "Script for lookup table 'db_connect_dblookup' returned error code 1"?

Explorer

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 
0 Karma
Highlighted

Re: Splunk DB Connect 2: How to resolve error "Script for lookup table 'db_connect_dblookup' returned error code 1"?

Explorer
0 Karma