<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic DB connect unable to query in All Apps and Add-ons</title>
    <link>https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-connect-unable-to-query/m-p/542365#M65037</link>
    <description>&lt;P&gt;inputs setup correctly as I can access to other tables but I get the following error for&amp;nbsp;index=_internal sourcetype="dbx*" error&lt;/P&gt;&lt;P&gt;I can not launch queries directly in splunk but rights are fine . Other tables seem to be able to read from splunk by using the inputs file, not the gui but I think they do not have null fields. Trying to read tables from a MSSql database from Splunk in Centos with a RO account.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN class="t"&gt;2021-03-04&lt;/SPAN&gt; &lt;SPAN class="t"&gt;14:32:50.559&lt;/SPAN&gt;&lt;SPAN&gt; +&lt;/SPAN&gt;&lt;SPAN class="t"&gt;0000&lt;/SPAN&gt;&lt;SPAN&gt; [&lt;/SPAN&gt;&lt;SPAN class="t"&gt;QuartzScheduler_Worker-7&lt;/SPAN&gt;&lt;SPAN&gt;] &lt;/SPAN&gt;&lt;SPAN class="t a"&gt;&lt;SPAN class="t"&gt;ERROR&lt;/SPAN&gt;&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.easybatch.core.job.BatchJob&lt;/SPAN&gt; &lt;SPAN class="t"&gt;-&lt;/SPAN&gt; &lt;SPAN class="t"&gt;Unable&lt;/SPAN&gt; &lt;SPAN class="t"&gt;to&lt;/SPAN&gt; &lt;SPAN class="t"&gt;open&lt;/SPAN&gt; &lt;SPAN class="t"&gt;record&lt;/SPAN&gt; &lt;SPAN class="t"&gt;reader&lt;/SPAN&gt; &lt;SPAN class="t"&gt;java.lang.IllegalArgumentException:&lt;/SPAN&gt; &lt;SPAN class="t"&gt;argument&lt;/SPAN&gt;&lt;SPAN&gt; "&lt;/SPAN&gt;&lt;SPAN class="t"&gt;content&lt;/SPAN&gt;&lt;SPAN&gt;" &lt;/SPAN&gt;&lt;SPAN class="t"&gt;is&lt;/SPAN&gt; &lt;SPAN class="t"&gt;null&lt;/SPAN&gt; &lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.fasterxml.jackson.databind.ObjectMapper._assertNotNull&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;ObjectMapper.java:4735&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.fasterxml.jackson.databind.ObjectMapper.readValue&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;ObjectMapper.java:3433&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.task.DbInputCheckpointRepository.parseOutput&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputCheckpointRepository.java:200&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.task.DbInputCheckpointRepository.loadImpl&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputCheckpointRepository.java:269&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.task.DbInputCheckpointRepository.load&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputCheckpointRepository.java:148&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.task.DbInputTask.loadCheckpoint&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputTask.java:142&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.recordreader.DbInputRecordReader.executeQuery&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputRecordReader.java:79&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.recordreader.DbInputRecordReader.open&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputRecordReader.java:52&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.easybatch.core.job.BatchJob.openReader&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;BatchJob.java:140&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.easybatch.core.job.BatchJob.call&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;BatchJob.java:97&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.easybatch.extensions.quartz.Job.execute&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;Job.java:59&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.quartz.core.JobRunShell.run&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;JobRunShell.java:202&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.quartz.simpl.SimpleThreadPool$WorkerThread.run&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;SimpleThreadPool.java:573)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class="t"&gt;can anybody help ? No Java expertise in house.&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Thu, 04 Mar 2021 14:49:49 GMT</pubDate>
    <dc:creator>Man100</dc:creator>
    <dc:date>2021-03-04T14:49:49Z</dc:date>
    <item>
      <title>DB connect unable to query</title>
      <link>https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-connect-unable-to-query/m-p/542365#M65037</link>
      <description>&lt;P&gt;inputs setup correctly as I can access to other tables but I get the following error for&amp;nbsp;index=_internal sourcetype="dbx*" error&lt;/P&gt;&lt;P&gt;I can not launch queries directly in splunk but rights are fine . Other tables seem to be able to read from splunk by using the inputs file, not the gui but I think they do not have null fields. Trying to read tables from a MSSql database from Splunk in Centos with a RO account.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN class="t"&gt;2021-03-04&lt;/SPAN&gt; &lt;SPAN class="t"&gt;14:32:50.559&lt;/SPAN&gt;&lt;SPAN&gt; +&lt;/SPAN&gt;&lt;SPAN class="t"&gt;0000&lt;/SPAN&gt;&lt;SPAN&gt; [&lt;/SPAN&gt;&lt;SPAN class="t"&gt;QuartzScheduler_Worker-7&lt;/SPAN&gt;&lt;SPAN&gt;] &lt;/SPAN&gt;&lt;SPAN class="t a"&gt;&lt;SPAN class="t"&gt;ERROR&lt;/SPAN&gt;&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.easybatch.core.job.BatchJob&lt;/SPAN&gt; &lt;SPAN class="t"&gt;-&lt;/SPAN&gt; &lt;SPAN class="t"&gt;Unable&lt;/SPAN&gt; &lt;SPAN class="t"&gt;to&lt;/SPAN&gt; &lt;SPAN class="t"&gt;open&lt;/SPAN&gt; &lt;SPAN class="t"&gt;record&lt;/SPAN&gt; &lt;SPAN class="t"&gt;reader&lt;/SPAN&gt; &lt;SPAN class="t"&gt;java.lang.IllegalArgumentException:&lt;/SPAN&gt; &lt;SPAN class="t"&gt;argument&lt;/SPAN&gt;&lt;SPAN&gt; "&lt;/SPAN&gt;&lt;SPAN class="t"&gt;content&lt;/SPAN&gt;&lt;SPAN&gt;" &lt;/SPAN&gt;&lt;SPAN class="t"&gt;is&lt;/SPAN&gt; &lt;SPAN class="t"&gt;null&lt;/SPAN&gt; &lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.fasterxml.jackson.databind.ObjectMapper._assertNotNull&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;ObjectMapper.java:4735&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.fasterxml.jackson.databind.ObjectMapper.readValue&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;ObjectMapper.java:3433&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.task.DbInputCheckpointRepository.parseOutput&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputCheckpointRepository.java:200&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.task.DbInputCheckpointRepository.loadImpl&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputCheckpointRepository.java:269&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.task.DbInputCheckpointRepository.load&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputCheckpointRepository.java:148&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.task.DbInputTask.loadCheckpoint&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputTask.java:142&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.recordreader.DbInputRecordReader.executeQuery&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputRecordReader.java:79&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;com.splunk.dbx.server.dbinput.recordreader.DbInputRecordReader.open&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;DbInputRecordReader.java:52&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.easybatch.core.job.BatchJob.openReader&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;BatchJob.java:140&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.easybatch.core.job.BatchJob.call&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;BatchJob.java:97&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.easybatch.extensions.quartz.Job.execute&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;Job.java:59&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.quartz.core.JobRunShell.run&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;JobRunShell.java:202&lt;/SPAN&gt;&lt;SPAN&gt;) &lt;/SPAN&gt;&lt;SPAN class="t"&gt;at&lt;/SPAN&gt; &lt;SPAN class="t"&gt;org.quartz.simpl.SimpleThreadPool$WorkerThread.run&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN class="t"&gt;SimpleThreadPool.java:573)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class="t"&gt;can anybody help ? No Java expertise in house.&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 04 Mar 2021 14:49:49 GMT</pubDate>
      <guid>https://community.splunk.com/t5/All-Apps-and-Add-ons/DB-connect-unable-to-query/m-p/542365#M65037</guid>
      <dc:creator>Man100</dc:creator>
      <dc:date>2021-03-04T14:49:49Z</dc:date>
    </item>
  </channel>
</rss>

