2016-08-22 10:15:06 DEBUG ServiceResponder:309 - action=process_request request=dblookup
2016-08-22 10:15:06 DEBUG ServiceResponder:324 - action=request_param index=0 type='class java.lang.String' value=dbxlookup
2016-08-22 10:15:06 DEBUG ServiceResponder:324 - action=request_param index=1 type='interface java.util.List' value=[[COLUMN, OTHERCOLUMN], [26715538], [26722705]]
2016-08-22 10:15:06 DEBUG ServiceResponder:324 - action=request_param index=2 type='interface java.util.Map' value={ui_query_table=TABLE, ui_query_schema=SCHEMA, serviceClass=com.splunk.dbx2.OracleJDBC, lookupSQL=SELECT * FROM "SCHEMA"."TABLE" WHERE COLUMN='26715538', ui_query_catalog=NULL, input_fields=COLUMN, output_fields=OTHERCOLUMN, ui_query_mode=advanced, useConnectionPool=1, jdbcUrlFormat=jdbc:oracle:thin:@//databaseserver:1521/databaseserver, connection=oracle_service, enable_query_wrapping=True, jdbcDriverClass=oracle.jdbc.OracleDriver, username=SPLUNKUSER, policy=reload}
2016-08-22 10:15:06 DEBUG ServiceResponder:324 - action=request_param index=3 type='class java.lang.String' value=splunk-system-user
2016-08-22 10:15:06 DEBUG DBX2LookupJDBC:299 - LOOKUP SQL template: SELECT "COLUMN", "OTHERCOLUMN" FROM (SELECT * FROM "SCHEMA"."TABLE" WHERE COLUMN='26715538') dbxlookup WHERE "COLUMN" IN (<QUESTIONS>)
2016-08-22 10:15:06 INFO  DBX2Proxy:342 - action=perform_lookup lookup=dbxlookup user=splunk-system-user
2016-08-22 10:15:06 DEBUG DBX2LookupJDBC:76 - action=perform_lookup_with_fields lookup_sql='SELECT "COLUMN", "OTHERCOLUMN" FROM (SELECT * FROM "SCHEMA"."TABLE" WHERE COLUMN='26715538') dbxlookup WHERE "COLUMN" IN (<QUESTIONS>)' infields=[COLUMN] outfields=[OTHERCOLUMN]
2016-08-22 10:15:06 DEBUG ConnectorFactory:137 - action=get_database_connection connection=oracle_service jdbcDriverClass=oracle.jdbc.OracleDriver jdbcUrlFormat=jdbc:oracle:thin:@//databaseserver:1521/databaseserver username=SPLUNKUSER testQuery=null useConnectionPool=true jdbcUseSSL=false jdbcUrlSSLFormat=null
2016-08-22 10:15:06 DEBUG ConnectorFactory:164 - action=database_connection_established connection=oracle_service jdbc_url=jdbc:oracle:thin:@//databaseserver:1521/databaseserver user=SPLUNKUSER is_pooled=true number_of_connection_pools=5
2016-08-22 10:15:06 DEBUG DBX2LookupJDBC:108 - action=about_to_perform_lookup_sql sql='SELECT "COLUMN", "OTHERCOLUMN" FROM (SELECT * FROM "SCHEMA"."TABLE" '
2016-08-22 10:15:06 ERROR DBX2Proxy:46 - Exception encountered for entity-name = dbxlookup and type = lookup
java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
	at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
	at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
	at com.splunk.dbx2.DBX2LookupJDBC.checkArgumentType(DBX2LookupJDBC.java:109)
	at com.splunk.dbx2.DBX2LookupJDBC.lookup(DBX2LookupJDBC.java:80)
	at com.splunk.dbx2.DBX2Proxy.dblookup(DBX2Proxy.java:343)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	at com.splunk.dbx2.ServiceResponder.respond(ServiceResponder.java:334)
	at org.apache.avro.ipc.Responder.respond(Responder.java:151)
	at org.apache.avro.ipc.Responder.respond(Responder.java:99)
	at org.apache.avro.ipc.ResponderServlet.doPost(ResponderServlet.java:48)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.server.Server.handle(Server.java:497)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
	at java.lang.Thread.run(Thread.java:745)
2016-08-22 10:15:06 ERROR ServiceResponder:352 - action=service_responder_responding_error error={}
java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
	at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
	at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
	at com.splunk.dbx2.DBX2LookupJDBC.checkArgumentType(DBX2LookupJDBC.java:109)
	at com.splunk.dbx2.DBX2LookupJDBC.lookup(DBX2LookupJDBC.java:80)
	at com.splunk.dbx2.DBX2Proxy.dblookup(DBX2Proxy.java:343)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	at com.splunk.dbx2.ServiceResponder.respond(ServiceResponder.java:334)
	at org.apache.avro.ipc.Responder.respond(Responder.java:151)
	at org.apache.avro.ipc.Responder.respond(Responder.java:99)
	at org.apache.avro.ipc.ResponderServlet.doPost(ResponderServlet.java:48)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:800)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.server.Server.handle(Server.java:497)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:620)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:540)
	at java.lang.Thread.run(Thread.java:745)