Logstash with mssql Stored Procedure

[thanhtai9606]

Describe the bug There are somethings wrong when I use stored procedure mssql

To Reproduce sql-server-logstash-document-1 | [2023-01-03T08:01:00,750][ERROR][logstash.inputs.jdbc ][main][92ba130 de51c28709562a16c1f300a243945a4fc7fd292cfdfe01535822c4118] Java::ComMicrosoftSqlserverJdbc::SQLServerExcept ion: Incorrect syntax near the keyword 'EXEC'.: SELECT TOP (1) count(*) AS [COUNT] FROM (EXEC ElasticSearch DocumentsWithPaging @skip = :offset, @take = :size, @sql_last_value = 0) AS [T1] sql-server-logstash-document-1 | [2023-01-03T08:01:00,760][WARN ][logstash.inputs.jdbc ][main][92ba130 de51c28709562a16c1f300a243945a4fc7fd292cfdfe01535822c4118] Exception when executing JDBC query {:exception=

"Java::ComMicrosoftSqlserverJdbc::SQLServerException: Incorrect syntax near the keyword 'EXEC'."}

Plugins jdbc mssql

Need create helm chart for Logstash-output-opensearch I think we need a helmchart for this project for deploy into kubernetes easy??

[dlvenable]

@thanhtai9606 , I believe we need more information on your setup and the issue here. It appears that you are having a problem with the jdbc plugin, but this project is the opensearch-output plugin.

[thanhtai9606]

Thank I have to use Elastic Search engine instead of open distro, it working fine!!