splunk query failed.

kundeng
kundeng New Altair Community Member
edited November 2024 in Community Q&A
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) 

Answers

  • kundeng
    kundeng New Altair Community Member
    I'm a splunk expert, this module is badly implemented.  earliest time should support splunk native time specifier etc.  

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.