odbc database monitor to execute procedure instead of query

XMLWordPrintable

    • Type: Problem report
    • Resolution: Fixed
    • Priority: Blocker
    • None
    • Affects Version/s: None
    • Component/s: Server (S)
    • None
    • Environment:
      Oracle LInux 7 running Zabbix 3.4.9

      Steps to reproduce:

      1. create a Database Monitor item and use a Procedure instead of a Query in the 'SQL query' field to get the desired result.
      2. use the appropriate syntax to execute the procedure in the 'SQL query' field to query a MSSQL database: exec monitoria_globalsys.dbo.usp_zbx_gsys_longqueries 0;

      Result:
      See screenshot...
      The item gets in error state with de following message:
      cannot fetch row:[SQL_ERROR]:[24000][0][[Microsoft][ODBC Driver 13 for SQL Server]Invalid cursor state]|
      Expected:
      The expected result would be the same exit as shown in the SQLSERVER Management Studio: only on line of text without line breaking characters.
      See screenshot....

            Assignee:
            Zabbix Support Team
            Reporter:
            eliandro leao simim
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: