All Apps and Add-ons

Why does DB Connect App fail after first successful db input execution?

blacksun
New Member

I've created db input for new table MS SQL server. Query is quite simple:
query=SELECT * FROM "XXX"."dbo"."YYY$ZZZ" WHERE [Entry No_] > ? ORDER BY [Entry No_] ASC
Test execution work fine, job was successfully created
Data from first execution are indexed in splunk, but all next scheduled jobs fall with error:

2018-03-14 12:46:11.599 +0300 [QuartzScheduler_Worker-25] WARN c.s.dbx.connector.connector.impl.JdbcConnectorImpl - failed to execute query with paramtype, fallback to execute query without paramtype
java.sql.SQLException: Value 2017-11-09 09:06:35.56 cannot be converted to BIGINT.

Value is date and time column, and in first execution it was converted to _time with no errors.

Any suggestions?

PS I have another few jobs and they works fine all the time.
PSS DB connect ver 3.1.2

Labels (1)
0 Karma

daromar
New Member

did you ever find out the cause? I am currently facing the same issue with db connect 3.12.1

0 Karma
Get Updates on the Splunk Community!

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...

IM Landing Page Filter - Now Available

We’ve added the capability for you to filter across the summary details on the main Infrastructure Monitoring ...

Dynamic Links from Alerts to IM Navigators - New in Observability Cloud

Splunk continues to improve the troubleshooting experience in Observability Cloud with this latest enhancement ...