Why I am getting this error when using JDBC input plugin of Logstash

[Jenni]

I know that in your case you are not calling a stored procedure, but I think this solution could apply to your problem as well as the plugin apparently only creates the "SELECT TOP (1) … " query in debug mode?

Logstash cannot call SQL Stored Procedure

@Ashish_Viradia I found this to be a bug, if you run logstash in debug mode the jdbc plugin will do a SELECT TOP(1) on the stored procedure which is invalid. However, if logstash is not in debug mode then it works fine. Not the best solution but at least a work around. E