Hi Joe,

Thanks alot for your reply! Here I attached the output of the syntax. Btw, I guess this is a hostname related problem?

Yes, you need to follow the hostname change procedure at http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_common_services_software/3.0/user/guide/diagnos.html#wp1078582 . Once you perform those steps, you need to modify the registry to change the hostname from zciscolms to zlms1 (under HKLM\SOFTWARE\Cisco).

Hi,

Can i know where to find the dbpassword or reset it for this command:

dbisqlc -c "uid=cmfDBA;pwd=dbpassword;eng=cmfEng;dbf=NMSROOT\databases\cmf\cmf.db" -q update PIDM_app_device_map SET app_hostname=`NewhostName' where app_hostname= `OldhostName'

because I think nobody know the password right now..

Maybe you could try c2kY2k for dbpassword or use dbpasswd.pl (located in NMSROOT\bin).

If you do not know the password, you will need to set it using the NMSROOT\bin\perl NMSROOT\bin\dbpasswd.pl command.

Thanks a lot for your posts, jclarke and rokp. The CTMJrmServer can started right now. And one question anymore, when i accessed the LMS homepage, all the links are still refer to the old hostname [ZCISCOLMS].

eg, the hyperlinks in the LMS home page:

Common Services [ZCISCOLMS]

Campus Manager [ZCISCOLMS]

is there anyway to change this to the new hostname? i have search *.xml in NMSROOT and sub folders and change whatever with the value "ZCISCOLMS" to "ZLMS1", but it doesn't work.

Thanks,

Jo

You missed a step in the hostname change procedure. See Step 6, and make sure you completed that correctly.

Oh okay, I had already redo all the procedures, and it seems now the hyperlinks are already point to the new hostname. Anyway, the hyperlinks for the Common Services menu are now disappeared from the LMS home page, so I had to type "http://zlms1:1741/cwhp/goHome.do" manually to access the Common Services homepage.

How can it be? Need help again for this.. Thanks very much for your great help.

I'm not sure how this happened, but it can be fixed. Unfortunately, the fix is not very straight forward. You will need to contact the TAC, and they can walk you through removing all of your CMIC registrations, then adding them all back from the command line.

Unfortunately I cannot have the TAC access at this moment and this problem have to be solved immediately. Anyway, can you give me any hints on how to fixing this?

Thanks very much for your help, always.

Okay then, I will look for what is the best option for this case. Thanks very much jclarke!