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

[kenkenou]

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 

[kenkenou · Accepted solution]

After changing the permission then it works!
refer to https://answers.splunk.com/answers/305217/how-to-set-up-a-splunk-db-connect-2-lookup-that-is.html