Print Page - Failed to load template object

Title: Failed to load template object
Post by: xenth on May 15, 2008, 10:24:36 AM

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 :(

Title: Re: Failed to load template object
Post by: Victor Kirhenshtein on May 16, 2008, 01:24:54 PM

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

Title: Re: Failed to load template object
Post by: xenth on May 16, 2008, 03:04:53 PM

It says it contains no data?

Code Select

Empty set (0.00 sec)

Title: Re: Failed to load template object
Post by: Victor Kirhenshtein on May 16, 2008, 04:29:50 PM

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:

Code Select


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

NetXMS Support Forum

English Support => General Support => Topic started by: xenth on May 15, 2008, 10:24:36 AM