Monitoring Splunk

Checkpoint value is changing from rising column to some different column

MittalKamal
Explorer

Hi,

Initially I was using rising column as datetime but there was some data loss.. i.e. not every data was dumping to Splunk from SQL. So I changed rising column to Id(int) and its working fine on one of my TST environment.

But when I am doing the same for Prod, after every run my checkpoint value change to datetime instead of Id although in rising column its showing Id. And due to that no data is coming to Splunk.

Please help.

Labels (1)
0 Karma

dave_null
Path Finder

I assume you are using the Splunk DB Connect app, and it is able to execute SQL queries to your database. Are you able to make a new data input which has id(int) as the rising column, instead of modifying the old one?

0 Karma
Get Updates on the Splunk Community!

Synthetic Monitoring: Not your Grandma’s Polyester! Tech Talk: DevOps Edition

Register today and join TekStream on Tuesday, February 28 at 11am PT/2pm ET for a demonstration of Splunk ...

Instrumenting Java Websocket Messaging

Instrumenting Java Websocket MessagingThis article is a code-based discussion of passing OpenTelemetry trace ...

Announcing General Availability of Splunk Incident Intelligence!

Digital transformation is real! Across industries, companies big and small are going through rapid digital ...