Cannot Connect to JRM

[diek]

When accessing HUM Report Managment I get the error Cannot Connect to JRM. Was working till I did a Microsoft Backup of the Server 2003 system it is installed on.

[Joe Clarke]

If you don't have LMS 3.1, then you won't have dbsrv10. The following command run from a DOS shell works for LMS 3.0:

NMSROOT\objects\db\win32\dbsrv9 -f NMSROOT\databases\cmf.db

However, based on this output, the very worst has happened. The cmf database is corrupt. The cmf database holds the DCR, so unless you have a known good LMS backup, you will need to reinitialize all of your LMS databases.

If you have a known good backup, restore it using the NMSROOT\bin\restorebackup.pl command. If not, you will need to run the following commands:

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=cmf dmprefix=CMF

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=rmeng dmprefix=RME

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=ani dmprefix=ANI

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=dfmInv dmprefix=INV

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

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=dfmFh dmprefix=FH

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=ipm dmprefix=Ipm

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=upm dmprefix=UPM

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=opsxml dmprefix=Opsxml

Then remove NMSROOT\objects\smarts\local\repos\icf\DFM*.rps.

If you end up reinitializing your databases, you will lose all of your data, but LMS should be functional once again.

[diek]

I did a restore with a backup I had from a week before this started happening and everything is ok now.

Thanks,

Ken