×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

Device Fault Manager

Unanswered Question
Oct 9th, 2007
User Badges:

I'm getting the following error when I run the Self-Test under Common Services:


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

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


Some other error that I'm getting is that no Alerts and Activities are being registered and the Notification Services will display "Database Error"


Does anybody have seen this error?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
jreekers Tue, 10/23/2007 - 18:33
User Badges:
  • Cisco Employee,

It appears your DFM database is corrupt and you should probably reinitialize it. Run this set of commands in order to refresh the DFM databases:


WINDOWS:

Open a DOS command prompt and execute case sensitively:

net stop crmdmgtd


cd CSCOpx\bin


perl dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM


perl dbRestoreOrig.pl dsn=dfmInv dmprefix=INV


perl dbRestoreOrig.pl dsn=dfmFh dmprefix=FH


net start crmdmgtd


<>


SOLARIS:


/etc/init.d/dmgtd stop



cd /opt/CSCOpx/bin


./dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM


./dbRestoreOrig.pl dsn=dfmInv dmprefix=INV


./dbRestoreOrig.pl dsn=dfmFh dmprefix=FH


/etc/init.d/dmgtd start


<>


Now it's possible if you're using an older version of DFM the above steps don't work to reinit the db...so if it doesn't, please let me know the version of DFM as well as the OS (windows/solaris?) you're running on.


Please let me know how it goes.


-Joe

Actions

This Discussion