- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
incomplete data returned by DB Connect dbxquery when query oracle 11g

sxu_splunk

Splunk Employee
04-21-2020
07:09 PM
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.
