topic Re: Error after CMS hostname change in Server Management - Systems Insight Manager

Error after CMS hostname change

Fredrik Jacobsson_2 — Mon, 25 Jul 2005 09:16:49 GMT

Hi,

i has been changing name om my CMS and has some problem after that.

I have read the 'Changing the HP Systems Insight Manager 4.2 system name' whitepaper about this. But has still some problems.

No Scheduled Task is running after the name change. As owner it says the old hostname.

Exampel below:
Task name: Bi Weekly Data Collection Target: Data Collection List
Tool: Data Collection Schedule: Every 2 weeks on Saturday at 11:00 PM CET
Owner: SIM\mxadmin

The correct Owner should be MON01 instead of SIM.

Have done the 'Update hpmxuser set persistedname='oldhostname\mxadmin' where persistedname='newhostname\mxadmin'

Anyone who has some suggestion ?

// Fredrik

Re: Error after CMS hostname change

Aravindh Rajaram — Mon, 25 Jul 2005 17:07:16 GMT

Here is the sequence of updations required in the back end...(all this info is present in the Whitepaper that HP has published for users who would like to change the hostname)

* Open the globalsettings.props file located in /config folder and make a note of the value associated with the key named CMSDeviceKey.
* Open SQL Query Analyzer and execute the following SQL Queries against the HPSIM database:
o Update devices set name=â â where devicekey=
o Update hpmxuser set PersistedName=â \administratorâ where PersistedName=â \administratorâ
o Update hpmxuser set PersistedName=â \mxadminâ where PersistedName=â \mxadminâ
o Update hpmxuser set PersistedName=â \handymanâ where PersistedName=â \handymanâ
o Execute the following Query repeatedly, if required, for all the other local users where is the username for each local user created in HPSIM
Update hpmxuser set PersistedName=â \â where PersistedName=â \â
Note: The above query need not be executed for domain users
o Update tasks set createdbyuser=replace(createdbyuser,â â ,â â )
o Update tasks set modifiedbyuser=replace(modifiedbyuser,â â ,â â )
o Update tasks set ownedbyuser=replace(ownedbyuser,â â ,â â )

Re: Error after CMS hostname change

Fredrik Jacobsson_2 — Tue, 26 Jul 2005 03:40:38 GMT

All of this steps has been done.

But why hasnÂ´t the owner for the scheduled tasks been changed ?