-
Type:
Problem report
-
Resolution: Unresolved
-
Priority:
Trivial
-
Affects Version/s: None
-
Component/s: Agent2 plugin (G), Templates (T)
-
None
Bug type: Typo in SQL query causing incorrect behavior on case-sensitive MSSQL databases.
Details:
In some MSSQL environments (case-sensitive collation), the Cache hit ratio item becomes unavailable due to incorrect casing in the string literal used in the query.
Fix required (line 61) perfcounter.get.sql:
WHERE counter_name = 'Cache Hit Ratio base'
-->
WHERE counter_name = 'Cache Hit Ratio Base'
- related to
-
ZBX-22458 Cannot fetch 'Cache hit ratio' item (MSSQL By ODBC Template)
-
- Closed
-