Here is the dbx.log information in debug mode ... The query is a simple select * from table.
2014-12-30 20:28:23.158 main:DEBUG:BridgeSession - Initialized BridgeSession for Socket Socket[addr=/127.0.0.1,port=35836,localport=17865]
2014-12-30 20:28:23.159 :DEBUG:BridgeSession - Starting BridgeSession...
2014-12-30 20:28:23.159 :DEBUG:LRUCache - Cache hit for key com.splunk.dbx.command.DatabaseQueryCommand (no need to handleResult producer)
2014-12-30 20:28:23.160 dbx9474:DEBUG:ExecutionContext - Initializing execution context with app.ctx=dbx and execId=dbx9474
2014-12-30 20:28:23.160 dbx9474:INFO:BridgeSession - Executing Bridge command: BridgeExecutionInfo{className=com.splunk.dbx.command.DatabaseQueryCommand}
2014-12-30 20:28:23.161 dbx9474:DEBUG:BridgeSession - Bridge commands arguments: [EXECUTE, scdb, limit=1000, "select * from aps_v_storage_array;"]
2014-12-30 20:28:23.162 dbx9474:INFO:DatabaseQueryCommand - action=executing SQL query="select * from aps_v_storage_array;" on database=scdb
2014-12-30 20:28:23.162 dbx9474:DEBUG:DatabaseQueryCommand - infoPath not in command headers... reading it from job sid=null directly...
2014-12-30 20:28:23.162 dbx9474:WARN:DatabaseQueryCommand - SearchResultsInfo file null doesn't exist
2014-12-30 20:28:23.163 dbx9474:DEBUG:DatabaseQueryCommand - srInfo: null
2014-12-30 20:28:23.163 dbx9474:DEBUG:Database - Fetching connection from factory...
2014-12-30 20:28:23.163 dbx9474:DEBUG:PooledConnectionFactory - Fetching connection from pool...
2014-12-30 20:28:23.163 dbx9474:DEBUG:PooledConnectionFactory - Activating database connection oracle.jdbc.driver.T4CConnection@221c6a1f for database=scdb
2014-12-30 20:28:23.164 dbx9474:DEBUG:PooledConnectionFactory - Validating database connection for database=scdb
2014-12-30 20:28:23.164 dbx9474:DEBUG:Database - Validating database connection...
2014-12-30 20:28:23.165 dbx9474:DEBUG:Database - Executing test query: SELECT 1 FROM DUAL
2014-12-30 20:28:23.167 dbx9474:DEBUG:Database - Database validation successful
2014-12-30 20:28:23.182 dbx9474:ERROR:DatabaseQueryCommand - SQL exception occurred: ORA-00911: invalid character
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
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.executeInternal(OracleStatement.java:1916)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at com.splunk.dbx.sql.Database.execute(Database.java:238)
at com.splunk.dbx.command.DatabaseQueryCommand.executeCommand(DatabaseQueryCommand.java:83)
at com.splunk.runtime.SplunkCommand.invoke(SplunkCommand.java:237)
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:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
2014-12-30 20:28:23.184 dbx9474:ERROR:DatabaseQueryCommand - Error while executing command: A database error occurred: ORA-00911: invalid character
... View more