Error in communicating with DCA Server ?

Answered Question
Jul 31st, 2007
User Badges:

Having problems with common services get error

?Error in communicating with DCA Server.

DCA Server may be down. Please start the DCA Server and then refresh the page.?


Results from server self test are

?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)??


A number of processes failed to start ? any ideas on where to start troubleshooting this?


Correct Answer by Joe Clarke about 9 years 11 months ago

Okay, with dmgtd shutdown, delete the cmf.log file (del /f cmf.log). Then, run:


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


Then restart dmgtd, and the database should start up.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
yjdabear Tue, 07/31/2007 - 06:33
User Badges:
  • Gold, 750 points or more

On the surface, it looks like a Common Services database password issue, which can be reset with: $NMSROOT/bin/dbpasswd.pl dsn=cmf encryption=yes npwd=new-password-here, but better open a TAC case for a thorough diagnosis.

Martin Ermel Tue, 07/31/2007 - 06:35
User Badges:
  • Blue, 1500 points or more

DCA is dependent on other processes, if they wont start, DCA cannot start as well.

this could be of changeing the startup parameters of the CiscoWorks services

or a change of the servers' hostname.


read the whole thread here and check if anything applies to your situation:

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Network%20Infrastructure&topic=Network%20Management&CommCmd=MB%3Fcmd%3Ddisplay_location%26location%3D.1dddfd05

poppj Tue, 07/31/2007 - 10:06
User Badges:

The hostname has not changed; I did change the DBpassword, it is a standalone server.

security Certficate ok

The Windows server did crash - hang - thinking i may have corrupted database(s). Can common services be re-installed - or do I need a complete LMS re-install?

Joe Clarke Tue, 07/31/2007 - 10:09
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

The database may not be corrupt. Shutdown dmgtd, then look under NMSROOT/databases/cmf. What files are there?

poppj Tue, 07/31/2007 - 10:51
User Badges:

2 files in that directory

cmf.db

cmf.log


and one sub directory

\orig -

cmf.dborig

odbc.tmpl

odbc.tmplorig

poppj Tue, 07/31/2007 - 10:56
User Badges:

the file cmf.log has a timestamp near when the windows server hung / crashed

Correct Answer
Joe Clarke Tue, 07/31/2007 - 10:57
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Okay, with dmgtd shutdown, delete the cmf.log file (del /f cmf.log). Then, run:


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


Then restart dmgtd, and the database should start up.

poppj Tue, 07/31/2007 - 11:23
User Badges:

thank you very much - the dbsrv9 program seems to have fixed that problem, after a re-start both cmf and dca appear to be running. I will let the server run awhile and check them tomorrow morning.

Actions

This Discussion