All Apps and Add-ons

Splunk DB Connect Step 4 Warning

Mcap08
New Member

Hello,

 

Current SQL Query:

SELECT *
FROM "vxex"."dbaex"."Example_Log_View"
WHERE [Event Time] > ?
ORDER BY [Event Time] ASC

I am having some issues with log duplication on one of my inputs... The SQL Query I have executes, but It gives me a warning on Step 4 within my Rising Input Option:

Mcap08_0-1692972229609.png

 

I am not too versed in Splunk DB Connect.. I believe it may be the space in the Event Time Column name.. But put [] around it to mitigate that.. As it still runs to step 5.

 

Mcap08_1-1692972875601.png

 

What I do see is the Checkpoint Value of 01/01/1970... And here are some Examples of the Event Time that comes through from the SQL Query:

2023-04-20 10:02:30.87

2023-04-20 10:03:23.783

 

Any thoughts on how to troubleshoot this issue to resolve step 4 to run properly?

 

 

 

 

Labels (1)
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

ATTENTION: We’re Moving! (AGAIN!)

The Splunk Community Slack is undergoing a system migration to keep our workspace secure and ...

Deep Dive: Optimizing Telemetry Pipelines in Splunk Observability Cloud

In this session, we will peel back the layers of Splunk Observability Cloud’s cost-optimization features. ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...