Device Fault Manager

Unanswered Question
Oct 9th, 2007

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?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
jreekers Tue, 10/23/2007 - 18:33

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