Error after CMS hostname change

[Fredrik Jacobsson_2]

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

[Aravindh Rajaram]

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,â â ,â â )

[Fredrik Jacobsson_2]

All of this steps has been done.

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