All Apps and Add-ons

DBConnect 2 rising column mode - missing records

reggie_123
Explorer

I am using DBCOnnect 2 on a HeavyForwarder, in local resource pool mode, with a rising column input - the rising column is an integer and I also tried using a timestamp column as a rising column.
When comparing the results in the DB and the results in Splunk, records are missing in splunk, as if splunk hasn't indexed or read them at all.
The DB is SQL server. The values are missing both for timestamp rising column and for integer rising column.
Neither the integer column nor the timestamp column have null values or get updated.

What could be the cause of the problem?
In the log, see ConfPathMapper: /opt/splunk/etc/apps/splunk_app_db_connect/local: Refused forced reload of inputs.conf: outstanding write
But not sure this is related

mikemizener
Explorer

Is the rising column an integer that is auto generated by the table such as ROWID, etc?

0 Karma
Get Updates on the Splunk Community!

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...