Database.pl error in Ciscoworks LMS 3.2

Answered Question
Nov 26th, 2009
User Badges:

Dear Friends,


I am getting the following error only for database.pl when i run selftest under Common-->Services-->Admin:


database.pl

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)


Please find enclosed the output of pdshow.


Can you please advise the recommended action for this?


Thanks a lot

Gautam

Attachment: 
Correct Answer by Joe Clarke about 7 years 7 months ago

The DFM EPM database is down.  This could be indicative of a corrupt database, or simply a damaged transcation log.  Shutdown Daemon Manager, then delete NMSROOT/databases/dfmEpm/dfmEpm.log if it exists.  Then run:


NMSROOT/objects/db/win32/dbsrv10 -f NMSROOT/databases/dfmEpm/dfmEpm.db


Then restart Daemon Manager.  If the EPMDbEngine process is still down, then you will need to reinitialize your EPM database, or restore LMS from a known good backup.  To reinitialize the database, run:


NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
Joe Clarke Thu, 11/26/2009 - 11:47
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

The DFM EPM database is down.  This could be indicative of a corrupt database, or simply a damaged transcation log.  Shutdown Daemon Manager, then delete NMSROOT/databases/dfmEpm/dfmEpm.log if it exists.  Then run:


NMSROOT/objects/db/win32/dbsrv10 -f NMSROOT/databases/dfmEpm/dfmEpm.db


Then restart Daemon Manager.  If the EPMDbEngine process is still down, then you will need to reinitialize your EPM database, or restore LMS from a known good backup.  To reinitialize the database, run:


NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM

gautamzone Thu, 11/26/2009 - 13:14
User Badges:

Thanks a lot jclarke.

The second step (using dbrestore.pl) resolved the issue.


This is what i get now:


database.pl

PASS     Self Test succeeded for upm ipm dfmInv ani dfmFh dfmEpm cmf rmeng 



Thanks a lot again for your valuable help


Thanks a lot

gautam

Actions

This Discussion