Since our upgrade from 8.8 sp4 to 9.0 sp2 on 8/1/2011, I've been getting more and more database exceptions. (Right now about 75% of all scans fail, maybe more.) Errors in the app log as follows:
Event Type: Error
Event Source: LANDesk Inventory Server
Event Category: None
Event ID: 4100
Time: 11:34:23 AM
Database exception: SCA20E.SCN, LDInv.dll
Item cannot be found in the collection corresponding to the requested name or ordinal. Update Table:TCP Column:ADDRESS PK:, Thread ID: 5512.
(I also have a discussion in the Database section about this installation hammering Oracle - http://community.landesk.com/support/message/67323#67323 - which may be related.)
I've dug through here, deleted unmodeled data/ran coredbutil, reregistered ldinv.dll, to no avail. Can anyone shed some light on this? Or give me a good place to look for the cause of the problem? Every error is followed by a "successfully connected to the database" message. No other errors in there related to this that I can see...
System is Windows Server 2003 32-bit, Oracle 11gR2 database. Small setup - ~1000 devices, a dozen analysts.