Hi,
Currently I created odbc items to check some sql results and triggers. Almost all of them works well and brings data. But here comes the tricky part :
-I started with 2 items first and it was all good ,then another 3 query items came and 2 of them worked well, but last one brings data only for some minutes correctly, then without any alert or error directly disable itself
IF you dont check it manually , you would have no idea about the problem.
I tried to create other items, recreating item, duplicating others and itself and compare the result with different intervals etc...
Always same sql query item ( named as schedule ) disable itself (from template and naturally from the host's item) after some checking and the result is only something like : NoData btw .. ( I know only 1 line it can bring so sp results are created like that )
Btw this enviromented is only temporary , we ll continue to work with version 5+ , but that project will take a while and this is something extremely important for company.
Any idea is appreciated?
Zabbix version 4.2.6 - postgresql
Currently I created odbc items to check some sql results and triggers. Almost all of them works well and brings data. But here comes the tricky part :
-I started with 2 items first and it was all good ,then another 3 query items came and 2 of them worked well, but last one brings data only for some minutes correctly, then without any alert or error directly disable itself
IF you dont check it manually , you would have no idea about the problem.
I tried to create other items, recreating item, duplicating others and itself and compare the result with different intervals etc...
Always same sql query item ( named as schedule ) disable itself (from template and naturally from the host's item) after some checking and the result is only something like : NoData btw .. ( I know only 1 line it can bring so sp results are created like that )
Btw this enviromented is only temporary , we ll continue to work with version 5+ , but that project will take a while and this is something extremely important for company.
Any idea is appreciated?
Zabbix version 4.2.6 - postgresql
Attached Files