topic Re: DBConnect 3.0 - Invalid Query!??! (StoredProc support? Parse error?) in All Apps and Add-ons

DBConnect 3.0 - Invalid Query!??! (StoredProc support? Parse error?)

michaelba — Tue, 21 Feb 2017 21:22:06 GMT

Splunk/DBConnect,

DBConnect 3.0 is unable to run our storedprocedure that is saved in the MS-SQLServer instance. Using SQL Management Studio, we've confirmed this storedprocedure returns 25 records.

What are we overlooking?
Why is DBConnect unable to retrieive the results?
How can we disable 'selectMethod=cursor' for the connection object, I suspect this may be issue?

Re: DBConnect 3.0 - Invalid Query!??! (StoredProc support? Parse error?)

martin_mueller — Tue, 21 Feb 2017 21:45:19 GMT

dbxquery supports stored procedures, inputs don't.

http://docs.splunk.com/Documentation/DBX/3.0.0/DeployDBX/Commands#procedure

Re: DBConnect 3.0 - Invalid Query!??! (StoredProc support? Parse error?)

michaelba — Tue, 21 Feb 2017 21:50:03 GMT

No we can't use dbxquery because were trying to forward our data to Splunk Cloud.

What's the work around? The data needs to be forwarded from on-premise to splunk-cloud. We've been using inputs in DBConnect to do this, how do we get the same result given some of our data is coming from stored-procedures.