Data collected through ODBC is not stored

[Deox]

Hi All,

I'm trying to collect some data through ODBC driver from MS SQL Server.
Tests collect the data, however it is not visible through Latest Data and Database item history table is empty for that item

Infrastructure:
Zabbix server 6.2.3, Debian 11, driver '[ODBC Driver 18 for SQL Server]' installed through package msodbcsql18.


Problem behavior:
No issues with connecting through odbc

1. Item: db.odbc.get[get_version,,DRIVER=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.3.so.2.1;SERVER=xx.xx.xx.xx;PORT=1433;UID=xxxxx xxx;PWD=xxxxxxxxxx;TrustServerCertificate=YES]

'Test - Get value and test' buttons provide correct JSON response, Update interval is 5 minutes and 'Execute now' button sends request with no issues

However, latest data is empty, as well as history SQL table for that item. Other items collected with no issues. No changes in a day

2. The same behavior with another key (select instead of get) Item: db.odbc.select[get_version,,DRIVER=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.3.so.2.1;SERVER=xx.xx.xx.xx;PORT=1433;UID=xxxxx xxxx;PWD=xxxxxxxxxxx;TrustServerCertificate=YES]

Test provides correct data using String instead of JSON, however it is not saved as well

3. First attempts were using MSSQL by ODBC zabbix template with the same issue. DSN, User and Password were provided through macros, Items were tested with JSON provided, however data is not stored and Dependent/Calculated items were empty.


Any ideas to troubleshoot?

[Hamardaban]

First of all, upgrade to the current version (6.2.9 or 6.4.13) - this error may have already been fixed?
Then look at whether there are records related to these hosts or items in the Zabbix server (or proxy) log?
And check the startup settings "StartODBCPollers" in the server (or proxy) config.

[Deox]

Hi Team,

Any new ideas?

Thanks

[Hamardaban]

First of all, upgrade to the current version (6.2.9 or 6.4.13) - this error may have already been fixed?
Then look at whether there are records related to these hosts or items in the Zabbix server (or proxy) log?
And check the startup settings "StartODBCPollers" in the server (or proxy) config.

[Deox]

First of all, upgrade to the current version (6.2.9 or 6.4.13) - this error may have already been fixed?
Then look at whether there are records related to these hosts or items in the Zabbix server (or proxy) log?
And check the startup settings "StartODBCPollers" in the server (or proxy) config.

Hi Hamardaban, yes, the StartODBCPollers was set to 0 in the config file, which is not the default value. Thank you!