All Apps and Add-ons

incomplete data returned by DB Connect dbxquery when query oracle 11g

sxu_splunk
Splunk Employee
Splunk Employee

my splunk version is 8.0.1 in Windows, I am using DB connect and dbxquery to get data from oracle 11g database , driver is ojdbc6.

I just search with a very simple query "| dbxquery connection="orcl_local" query="select * from dept", the table is a new created testing table with 3 column and only 14 records. I could get some records from query but with data missing in last record for last column (blank).

After I insert more records into the table, sometimes I got missing 1~2 records , sometimes I got data missing in other column as well.

0 Karma
Get Updates on the Splunk Community!

Announcing the Expansion of the Splunk Academic Alliance Program

The Splunk Community is more than just an online forum — it’s a network of passionate users, administrators, ...

Learn Splunk Insider Insights, Do More With Gen AI, & Find 20+ New Use Cases You Can ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Buttercup Games: Further Dashboarding Techniques (Part 7)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...