splunk query failed.

kundengkundeng Member Posts: 14 Contributor II
edited January 2023 in Help
The following simple query failed: 

| dbxquery query="SELECT * FROM ClosetInventory.dbo.AV_RoomReport " connection="Inventory_PROD" 

  • Exception: java.lang.RuntimeException
  • Message: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[2,6] Message: The processing instruction target matching "[xX][mM][lL]" is not allowed.
  • Stack trace:
  • com.splunk.ResultsReaderXml.advanceStreamToNextSet(ResultsReaderXml.java:370)
  • com.splunk.ResultsReader.finishInitialization(ResultsReader.java:160)
  • com.splunk.ResultsReaderXml.(ResultsReaderXml.java:84)
  • com.splunk.ResultsReaderXml.(ResultsReaderXml.java:59)
  • com.rapidminer.extension.splunk.operator.splunk.CloseableResultsReaderXml.(CloseableResultsReaderXml.java:24)
  • com.rapidminer.extension.splunk.operator.splunk.SplunkExampleSource.createExampleSet(SplunkExampleSource.java:295)
  • com.rapidminer.operator.io.AbstractExampleSource.read(AbstractExampleSource.java:53)
  • com.rapidminer.operator.io.AbstractExampleSource.read(AbstractExampleSource.java:32)
  • com.rapidminer.operator.io.AbstractReader.doWork(AbstractReader.java:272)
  • com.rapidminer.operator.Operator.execute(Operator.java:1023)
  • com.rapidminer.operator.execution.SimpleUnitExecutor.execute(SimpleUnitExecutor.java:77)
  • com.rapidminer.operator.ExecutionUnit$2.run(ExecutionUnit.java:805)
  • com.rapidminer.operator.ExecutionUnit$2.run(ExecutionUnit.java:800)
  • java.security.AccessController.doPrivileged(Native Method)
  • com.rapidminer.operator.ExecutionUnit.execute(ExecutionUnit.java:800)
  • com.rapidminer.operator.OperatorChain.doWork(OperatorChain.java:423)
  • com.rapidminer.operator.Operator.execute(Operator.java:1023)
  • com.rapidminer.Process.executeRoot(Process.java:1477)
  • com.rapidminer.Process.lambda$executeRootInPool$5(Process.java:1453)
  • com.rapidminer.studio.concurrency.internal.AbstractConcurrencyContext$AdaptedCallable.exec(AbstractConcurrencyContext.java:362)
  • java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
  • java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
  • java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
  • java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:175)
  • Cause
  • Exception: javax.xml.stream.XMLStreamException
  • Message: ParseError at [row,col]:[2,6] Message: The processing instruction target matching "[xX][mM][lL]" is not allowed.
  • Stack trace:
  • com.sun.org.apache.xerces.internal.impl.XMLStreamReaderImpl.next(XMLStreamReaderImpl.java:604)
  • com.sun.xml.internal.stream.XMLEventReaderImpl.nextEvent(XMLEventReaderImpl.java:83)
  • com.splunk.ResultsReaderXml.readToStartOfElementWithName(ResultsReaderXml.java:164)
  • com.splunk.ResultsReaderXml.readIntoNextResultsElement(ResultsReaderXml.java:137)
  • com.splunk.ResultsReaderXml.advanceStreamToNextSet(ResultsReaderXml.java:368)
  • com.splunk.ResultsReader.finishInitialization(ResultsReader.java:160)
  • com.splunk.ResultsReaderXml.(ResultsReaderXml.java:84)
  • com.splunk.ResultsReaderXml.(ResultsReaderXml.java:59)
  • com.rapidminer.extension.splunk.operator.splunk.CloseableResultsReaderXml.(CloseableResultsReaderXml.java:24)
  • com.rapidminer.extension.splunk.operator.splunk.SplunkExampleSource.createExampleSet(SplunkExampleSource.java:295)
  • com.rapidminer.operator.io.AbstractExampleSource.read(AbstractExampleSource.java:53)
  • com.rapidminer.operator.io.AbstractExampleSource.read(AbstractExampleSource.java:32)
  • com.rapidminer.operator.io.AbstractReader.doWork(AbstractReader.java:272)
  • com.rapidminer.operator.Operator.execute(Operator.java:1023)
  • com.rapidminer.operator.execution.SimpleUnitExecutor.execute(SimpleUnitExecutor.java:77)
  • com.rapidminer.operator.ExecutionUnit$2.run(ExecutionUnit.java:805)
  • com.rapidminer.operator.ExecutionUnit$2.run(ExecutionUnit.java:800)
  • java.security.AccessController.doPrivileged(Native Method)
  • com.rapidminer.operator.ExecutionUnit.execute(ExecutionUnit.java:800)
  • com.rapidminer.operator.OperatorChain.doWork(OperatorChain.java:423)
  • com.rapidminer.operator.Operator.execute(Operator.java:1023)
  • com.rapidminer.Process.executeRoot(Process.java:1477)
  • com.rapidminer.Process.lambda$executeRootInPool$5(Process.java:1453)
  • com.rapidminer.studio.concurrency.internal.AbstractConcurrencyContext$AdaptedCallable.exec(AbstractConcurrencyContext.java:362)
  • java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
  • java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
  • java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
  • java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:175) 
Tagged:

Answers

  • kundengkundeng Member Posts: 14 Contributor II
    I'm a splunk expert, this module is badly implemented.  earliest time should support splunk native time specifier etc.  
Sign In or Register to comment.