All Apps and Add-ons

DB connect 3.5.1 missing data from Oracle database

Path Finder

Hi Friends,

I have query input in DB connect app, which runs collect data from oracle database.

Database generates 800 records per second .

I'm using "Rising mode" with SEQUENSE_NO as Rising column. SEQUENSE_NO is unique and ascending column.

My query look like below:


WHERE SEQUENSE_NO > ? AND tnx_stamp > sysdate - 10/1440


My Input setting:

Max row to Retrieve: 0 (Unlimited )

Fetch Size: 1000 Or 100000

Execution Frequency: 120s

This input work fine, no Error Or waring message in _internal log.

Next, I compared number of record between Oracle and Splunk in a time range. Its difference.

In Oracle 140,425 records, Splunk less records than Oracle with 135,008 events (I have tried with many different range of time, it same result.😞



Next, I search count timechart span=1s. --> Data loss occurs periodically


Next step. I checked internal dbx_job_metrict log.  The time of data loss coincides with the job start_time.

I dont know why it happened.



Would appreciate any help figuring out how to resolve this. Thanks!


Labels (1)
0 Karma

Path Finder

@splunkcan you help me?

0 Karma
Get Updates on the Splunk Community!

Index This | Why do they call it hyper text?

November 2023 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

State of Splunk Careers 2023: Career Resilience and the Continued Value of Splunk

For the past three years, Splunk has partnered with Enterprise Strategy Group to conduct a survey that gauges ...

The Great Resilience Quest: 9th Leaderboard Update

The ninth leaderboard update (11.9-11.22) for The Great Resilience Quest is out >> Kudos to all the ...