All Apps and Add-ons

Why is Splunk DB Connect 2 causing errors on our database?

chrisduimstra
Path Finder

I have a rising column query running every 15 minutes with the query:

SELECT * FROM "name"

The app appears to be working normally and Splunk is indexing the data from the database. However, our dba's have reported the following set of errors are occurring on the database server at the same 15 minute interval when the app's query is ran.

ProductsupPublisher Incorrect syntax near the keyword 'SET'.                    host        domain\name 7/12/16 12:42 PM
ProductsupPublisher sp_cursoropen/sp_cursorprepare: The statement parameter can only be a batch or a stored procedure with a single select, without FOR BROWSE, COMPUTE BY, or variable assignments.    host        domain\name 7/12/16 12:42 PM
ProductsupPublisher The cursor was not declared.                                    host        domain\name 7/12/16 12:42 PM

And this query

exec sp_cursorfetch 180150003,2,1,100

declare @p3 int
set @p3=-1
declare @p4 int
set @p4=-1
exec sp_cursorfetch 180150003,256,@p3 output,@p4 output
select @p3, @p4

I found this line in \etc\apps\splunk_app_db_connect\local\db_connections.conf and was wondering if the useCursors=true is of concern?

[connection_name]
jdbc:jtds:sqlserver://<host>:<port>/<database>;useCursors=true;domain=<domain_name>;useNTLMv2=true

Beyond this I have found nothing else to indicate the cause of this problem.

0 Karma
1 Solution

chrisduimstra
Path Finder

The cause was unknown, but the issue was solved by switching from jTDS driver to the microsoft driver.

View solution in original post

0 Karma

chrisduimstra
Path Finder

The cause was unknown, but the issue was solved by switching from jTDS driver to the microsoft driver.

0 Karma

amanediel
Explorer

how do you do that?

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...