All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
I'm having some problems with the common log. I'm logging to MariaDB using ODBC, but occasionally a record will have a field with a null value.
I'm using a custom string variable called 'Site' which is set per device, and is included in the SQL query to export to the database. Sometimes, quite randomly, it will be null.
I'm running MariaDB v10.3 and HM v11.97 on the same server, which is Server 2016, using the 32-bit MySQL ODBC connector.
Does anyone have any clues as to what might cause this?
Sorry, I do not understand how you could setup "Site" variable.
If you set folder-level variable, it will be named like %fvar_site%.
If you set global variable, it will be named like %udv_site%.
if you use test comment, then you should use variable like %CommentLine1%
Yes it was specified for all folders, but it was randomly missing sometimes but not most of the time.
However I've just been talking to our developer and he thinks that it might be a problem with the database itself, so please ignore this and I'll see if we can sort it out at our end.