NetXMS Support Forum

I keep seeing this error in my log file:

Quote
Failed to load template object with id 412 from database

How do I find out which object this is? I can't find it manually 

You can find this only in database. Run the following SQL query:


SELECT name FROM object_properties WHERE object_id=412


and you will get objects's name.

Best regards,
Victor

It says it contains no data?

Empty set (0.00 sec)

So, it means database inconsistency - object id exist, but it has no properties set. Such inconsistencies supposed to be cleaned up by nxdbmgr, but unfortunately I just check it and it has a bug and doesn't check templates. I'll fix that. Currently, you can just do the following queries:


DELETE FROM templates WHERE id=412
DELETE FROM dct_node_map WHERE template_id=412
DELETE FROM items WHERE node_id=412


to clean up. Or leave it as is - it doesn't affect anything except annoying message in log on startup.

Best regards,
Victor