I am getting the following error only for database.pl when i run selftest under Common-->Services-->Admin:
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
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