There's a doc covering this issue I believe, have you reviewed it yet? http://community.landesk.com/support/docs/DOC-1201 Be sure to read these notes from the bottom of that doc:
LDMS 8.8: For LDMS 8.8 Patch 17433 replaced patch 11128. Follow the below instructions.
LDMS 8.7: For LDMS 8.7 you will need to apply patch 11128. Follow the below instructions.
1. Turn off inventory service on core server.
2. Install 17433 for LDMS 8.8, or 11128 for LDMS 8.7 on core server only.
3. Run the following sql query twice:
Delete from fileinfo where fileinfo_idn in ( select distinct a.fileinfo_idn From fileinfo a left outer join fileinfoinstance b on a.fileinfo_idn = b.fileinfo_idn left outer join productfile c on a.fileinfo_idn = c.fileinfo_idn where a.filesize = 0 and b.fileinfo_idn is null and c.fileinfo_idn is null)
4. Open command prompt and change directory to managementsuite directory and run the following command prompts:
5. Start the inventory service.
You should be able to get rid of the error by just re-registering these 2 dll's:
regsvr32 "c:\program files\LANDesk\ManagementSuite\idal.dll"
regsvr32 "c:\program files\ LANDesk\ManagementSuite\ldcache.dll"
and restarting the Inventory Server Service on the Core. If the error persist, look at the solution above, but if you don't need to mess around in the database, don't... ;-)
Re-registering the two DLLs took care of this issue. Also found that the SQL Server Admin was restarting the SQL server--need to stop/restart the LANDesk Inventory Service whenever that happens...
Sure don't want to mess with the database if not needed ...