Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Database.pl error in Ciscoworks LMS 3.2

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

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Database.pl error in Ciscoworks LMS 3.2

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

2 REPLIES
Cisco Employee

Re: Database.pl error in Ciscoworks LMS 3.2

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

New Member

Re: Database.pl error in Ciscoworks LMS 3.2

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

1183
Views
0
Helpful
2
Replies
CreatePlease login to create content