Hi all,
After finally getting a automatic DB Lookup working it fails after loading in a couple of value.
I've setup the DB Connect application and configured the lookup with an advanced query and then setup and automatical lookup.
When running a search I receive this generic error.
"Script for lookup table 'lookup_media_title' returned error code 1. Results may be incorrect"
While the DB connect error log shows: No operations allowed after statement closed. Exception
The database is MySQL
013-01-08 19:51:04.845 dbx6816:ERROR:DatabaseLookupExecutor - Unexpected error while performing SplunkLookup DatabaseLookupExecutor: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.GeneratedConstructorAccessor17.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:465)
at com.mysql.jdbc.PreparedStatement.clearParameters(PreparedStatement.java:1161)
at com.splunk.dbx.sql.util.NamedPreparedStatement.clearParameters(NamedPreparedStatement.java:185)
at com.splunk.dbx.lookup.DatabaseLookupExecutor.performAdvancedLookup(DatabaseLookupExecutor.java:157)
at com.splunk.dbx.lookup.DatabaseLookupExecutor.performLookup(DatabaseLookupExecutor.java:38)
at com.splunk.runtime.SplunkLookup.invoke(SplunkLookup.java:26)
at com.splunk.bridge.session.BridgeSession.call(BridgeSession.java:92)
at com.splunk.bridge.session.BridgeSession.call(BridgeSession.java:30)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Any help would be appreciated!
... View more