DB Connect MySQL can't parse timestamp

wcastillocruz · ‎12-11-2020

I am using DB connect 3.4.0 to get data from SQL Server. I have 2 working inputs with rising id column and timestamp (DATETIME) to index data. Server and table structure is same for all inputs.
But for 2 inputs, I get this message in db_connect_server.log :

Capture.PNG

Thank for your help.

wcastillocruz · ‎12-11-2020

The timestamp column is also DATETIME. Please do you have any idea what can be wrong?

DB Connect MySQL can't parse timestamp

indexer

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

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

Your Feedback. Our Roadmap. Visit the PX Feedback Booth at .conf26

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

Painting a Clearer Picture: Creating Cross-Domain Visibility with AI Canvas

Join the Conversation

DB Connect MySQL can't parse timestamp

indexer

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

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

Your Feedback. Our Roadmap. Visit the PX Feedback Booth at .conf26

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

Painting a Clearer Picture: Creating Cross-Domain Visibility with AI Canvas