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
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...