How to delete an Orphan?

[Rikard Stjernman]

I accidentally added my management server twice. HPSIM discovered itself via the automatic discovery process, but I also aded the system manually (by pointing out the ipaddress).

The problem is now that HPSIM is reporting the same management server twice (as mgt01 and as Orphan-2). See attached screen shot.

When I try to delete the Orphan-2, I get the error message:

"The HP System Insight Manager Server cannot be deleted. It is required for the reporting of system events"


How do I delete this Orphan-2 from the database?!

[Mikael Rönnbäck]

Now I am not sure if this will work so its just an idea and you should probably check it with HP as well, but the situation reads similar to the system just having another name than what you want even if this time its by accident.

There's a whitepaper from HP called "Changing the HP Systems Insight Manager 5.0 system
name and password"

In there you can find the sql querys you need to run to alter the name of the CMS directly in the SQL database. (I would guess you'd have to delete the mgt01 entry first)

I've used that whitepaper myself to change the name of the CMS in the database and its a very simple step by step procedure. Do run a backup first though.

[Rikard Stjernman]

Thanks for your reply Mikael.

I actually gave up and reinstalled the database. I am in the implementation phase and had not started to add additional system to HPSIM, so it was not that much work.

But, I will definately have your answer in mind if I need tochange the CMS name in the future.

Thanks again.

Rikard

[Neven_3]

I had a similar problem.
It was solved with installation/upgrade
to hp sim 5.1.
After installation i tried to delete ORPHAN_1
object, and got a message that it can not be deleted because it is still in use by system,
and in extension it said that it can be deleted from CMD using this syntax:
mxnode â r orphan â x force (where orphan is name f object You trie to delete- orphan_xx).
I log in to my HP SIM server and execute this command and orphan_1 was deleted from my system. After that I restarted SQL and everything works fine now for me.