# Facing issue in Stored Procedure Call in Logstash

**URL:** <https://discuss.elastic.co/t/facing-issue-in-stored-procedure-call-in-logstash/113406>\
**Category:** Logstash\
**Created:** [December 28, 2017, 7:01am UTC](https://discuss.elastic.co/t/facing-issue-in-stored-procedure-call-in-logstash/113406 "2017-12-28T07:01:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sahul\_Hameed\_B](https://avatars.discourse-cdn.com/v4/letter/s/dfb087/32.png) [@Sahul\_Hameed\_B](https://discuss.elastic.co/u/Sahul_Hameed_B)\
**Post date:** [December 28, 2017, 7:01am UTC](https://discuss.elastic.co/t/facing-issue-in-stored-procedure-call-in-logstash/113406/1 "2017-12-28T07:01:07Z")

</div>

I am Facing Error in Stored Procedure Call in Logstash JDBC Plugin..

This is my JDBC Input Plugin

> input {  
> jdbc {  
> jdbc\_driver\_library =\> "D:\Elastic\elasticsearch-6.0.0\lib\sqljdbc42.jar"  
> jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
> jdbc\_connection\_string =\> "jdbc:sqlserver://192.168.0.168;databaseName=Fobesoft\_05Dec2017;"  
> jdbc\_user =\> "sa"  
> jdbc\_password =\> "RCK$1234"  
> statement\_filepath =\> "D:\query.txt"

}  
}

output {

stdout { codec =\> rubydebug }  
}

this is StoredProcedure File

> EXEC FOBE\_REPORTPAGE\_YEAR '562','2017'  
> CREATE PROC Fobe\_reportpage\_year (@RESTID INT,  
> @YEAR INT)  
> AS  
> BEGIN  
> DECLARE @PERIOD AS INT; ..............................

> \logstash-6.0.1\bin\>[2017-12-28T12:18:00,416][ERROR][logstash.inputs.jdbc] Java::ComMicrosoftSqlserverJdbc::SQLServerException: Incorrect syntax near the keyword 'CREATE'.: SELECT TOP (1) count(\*) AS [COUNT] FROM ( FOBE\_REPORTPAGE\_YEAR '562','2017'

can anyone pls help me...where i did my mistake..

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [December 31, 2017, 1:25pm UTC](https://discuss.elastic.co/t/facing-issue-in-stored-procedure-call-in-logstash/113406/2 "2017-12-31T13:25:36Z")

</div>

I'm confused. It looks like you're _creating_ a stored procedure. Why would you want to do that with Logstash?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 28, 2018, 1:25pm UTC](https://discuss.elastic.co/t/facing-issue-in-stored-procedure-call-in-logstash/113406/3 "2018-01-28T13:25:43Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.