I'm having two problems with the Hyperic 4.0 community version (HQ Version 4.0.2 (build #939 - Dec 18, 2008 - Release Build))
The first problem is that the "auto-discovery" section isn't working right. Take a look at my screenshots - it lists three servers that have changed for one reason or another. Clicking either "add to inventory" or "ship checked resources" doesn't do anything - page just refreshes and the items are still there. Even if I click on the name of the server to go the "what changed details page" and click ok, it still shows up.
The second problem is the "favorites" section no longer shows anything (it used to). You can see from my attached screenshots, when I try and go add stuff to the favorites it throws an exception. Not sure why, or how to "clear" the favorites and try again, but as it stands now it's broken.
I appreciate any help anyone can throw my way - these aren't show stopping problems but they are really annoying (I have to browse through the chain of stuff to get to my favorites now, and the auto-discovery is just an annoyance).
I've not had any problems in the past importing a new platform from auto-discovery, although as you can see from the screenshots, after importing the platform still shows (minus anything to import). Maybe I just need to clean the table like you mention?