CiscoWorks and Databases urgent

Answered Question
Sep 28th, 2007
User Badges:

Hi,

I'm having an issue with our CiscoWorks LMS2.6. Since the disk was getting full, and we didn't notive, I'm having an issue to get it back working.

When I go into the SelfTest, I see the following fail on database.pl:

FAIL Self Test Fail to query cmf.DbVersion, Error: Database server not found (DBD: login failed)

Self Test Fail to query cmf.SYSTABLE, Error: Database server not found (DBD: login failed)



ANy idea how I can solve it?

Jorge

Correct Answer by Martin Ermel about 9 years 7 months ago

let crmdmgtd be shutdown and delete the cmf.log file. Then run the following command in a dos box:

NMSROOT\objects\db\win32\dbsrv9 -f NMSROOT\databases\cmf\cmf.db


restart crmdmgtd. the processes should come up now. you can check it after around 5 to 10 min with 'pdshow'.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4.3 (4 ratings)
Loading.
Martin Ermel Fri, 09/28/2007 - 01:49
User Badges:
  • Blue, 1500 points or more

please provide the output of pdshow; which platform are you using and what have you yet done to get it back working.

jorge.s Fri, 09/28/2007 - 03:00
User Badges:

Hi,

I see the following error in the "jrm.log".


FATAL ERROR : Can not connect to database cmf

at com.cisco.nm.cmf.dbservice.DBConnection.doConnect(DBConnection.java:243)

at com.cisco.nm.cmf.dbservice.DBConnection.(DBConnection.java:50)

at com.cisco.nm.cmf.jrm.Server.main(Server.java:135)

Fri Sep 28 12:42:55 CEST 2007 Exception occured, exiting

FATAL ERROR : Can not connect to database cmf

at com.cisco.nm.cmf.dbservice.DBConnection.doConnect(DBConnection.java:243)

at com.cisco.nm.cmf.dbservice.DBConnection.(DBConnection.java:50)

at com.cisco.nm.cmf.jrm.Server.main(Server.java:135)



seems I really have a problem with the databases, but how to get them starting for later restore?

Jorge

Martin Ermel Fri, 09/28/2007 - 03:10
User Badges:
  • Blue, 1500 points or more

please provide the output of pdshow; which platform are you using and what have you yet done to get it back working.

jorge.s Fri, 09/28/2007 - 03:17
User Badges:

I've already attached the pdshow output.

What I did already was to get some free space, deleting non needed files not related to CW, I also rebooted the server, and was checking which services may be not starting.

I also have done, after stopping the daemon the "perl reinitdb.pl -restore" but didn't helped.

Martin Ermel Fri, 09/28/2007 - 03:41
User Badges:
  • Blue, 1500 points or more

that's an interessting feature, my last post got sended twice with a delay of 1h20ms and without my help...


your main problem seems to be related to the CMF database. The reinitdb command is only for the ANI db.

Stop crmdmgtd and go to NMSROOT\databases\cmf. What files do you can see there?

jorge.s Fri, 09/28/2007 - 04:06
User Badges:

cmf.db and cmf.log

and a folder called orig, with following files:

odbc.tmplorig

cmf.dborig

odbc.tmpl

Correct Answer
Martin Ermel Fri, 09/28/2007 - 04:14
User Badges:
  • Blue, 1500 points or more

let crmdmgtd be shutdown and delete the cmf.log file. Then run the following command in a dos box:

NMSROOT\objects\db\win32\dbsrv9 -f NMSROOT\databases\cmf\cmf.db


restart crmdmgtd. the processes should come up now. you can check it after around 5 to 10 min with 'pdshow'.

jorge.s Fri, 09/28/2007 - 04:21
User Badges:

is there no way to fresh reinitialize this database then? I'm now waiting for it to start.

Any clue why JRM is also stopped?

Jorge

Martin Ermel Fri, 09/28/2007 - 04:41
User Badges:
  • Blue, 1500 points or more

there are dependencies between the various processes. e.g JRM is dependend on CmfDbMonitor, RmeGatekeeper, EDS and EssMonitor. If one of these processes won't come up JRM will neither - and CmfDbMonitor depends on CmfDbEngine which could not start due to an unclean shutdown of the CMF db.


You cannot reinitialize the CMF db alone because it is the base db - You would messup everything.

For to restore the original (empty) db's look at this thread:

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Network%20Infrastructure&topic=Network%20Management&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.1ddc6075/0#selected_message


Some say you should restore CMF db as the last one - I cannot see a sense behind this when you are going to restore ALL db's - but why not ...

Joe Clarke Fri, 09/28/2007 - 05:46
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Anyone who says to reinitialize CMF last is just plain wrong. If you are reinitializing CMF and any other database, CMF must be reinitialized first.

Martin Ermel Fri, 09/28/2007 - 06:22
User Badges:
  • Blue, 1500 points or more

Interesting news!

But why ? The DBs get restored with copies of the original ones - this is a file copy like in the begining with CWSI. - OK, things get fortunately evolved :-) , so are there any dependencies or information drawn out from the db BEFORE they are whiped out (like filesystem paths etc) ?



Martin Ermel Mon, 10/01/2007 - 02:06
User Badges:
  • Blue, 1500 points or more

Hello Joe,

is it possible to shed some light on this with a few words or to give just a hint why (or where) there are dependencies?.

But it is correct, if one reinit CMF db it is necessary to reinit ALL other DBs as well because you cannot get them in sync any more? Or am I wrong with this statement?

Joe Clarke Mon, 10/01/2007 - 08:00
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

If you reinit CMF, you should also reinit all other databases.

Joe Clarke Mon, 10/01/2007 - 07:59
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

RME, for example, actually writes data to the CMF database during its reinitialization. Without this, basic RME jobs would not be properly scheduled.

Martin Ermel Thu, 10/04/2007 - 00:33
User Badges:
  • Blue, 1500 points or more

thanks, now it is really clear to see.

I supposed that the LMS processes are not always that easy somone thinks they are ;-)


Actions

This Discussion