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!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...