-
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:
- create a Database Monitor item and use a Procedure instead of a Query in the 'SQL query' field to get the desired result.
- 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....