MSSQL: Failed to fetch info data (or no data for 30m) - Zabbix
On the Zabbix server/proxy, run:
Zabbix ODBC items have a hard timeout. If your query takes longer than the setting, Zabbix aborts and fails to fetch. zabbix mssql failed to fetch info data -or no data for 30m-
Run a persistent test:
The error is almost always a logical or configuration gap , not a crash. The three pillars to verify, in order: MSSQL: Failed to fetch info data (or no
zabbix_get -s <zabbix_proxy_or_agent_ip> -k "db.odbc.select[MSSQL_PROD,SELECT 1 AS test]"
( /var/log/zabbix/zabbix_server.log ):
A: You can set the item’s status to “Not supported” to hide it, but that’s dangerous. Instead, fix the cause.
[MSSQL_PROD] Driver = ODBC Driver 17 for SQL Server Server = 192.168.1.100,1433 Database = master in order: zabbix_get -s <