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

Self Test Fail to query database.pl

Hello

I am running Ciscoworks and am getting below error when running a Selftest. Can anyone explain how I resolve these issues:

FAIL Self Test Fail to query rmeng.DbVersion, Error: Database server not found (DBD: login failed) Self Test

Fail to query rmeng.SYSTABLE, Error: Database server not found (DBD: login failed)

11 REPLIES
Cisco Employee

Re: Self Test Fail to query database.pl

This looks like the RME database server is down. Please post the output of the pdshow command.

Community Member

Re: Self Test Fail to query database.pl

Hello

Attached is the output of the pdshow.

Thanks

Saj

Cisco Employee

Re: Self Test Fail to query database.pl

You either have a corrupt database transaction log, or a corrupt database itself. First, shutdown Daemon Manager. If you have an NMSROOT/databases/rmeng/rmeng.log, delete it. Then run:

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

Then restart Daemon Manager. That should get the database server to start. If not, then you have a corrupt RME database, and you will need to reinitialize:

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

Community Member

Re: Self Test Fail to query database.pl

Hello

Deleting the RMENG.DB file with a stop\start of the deamon service did not work. On point to add is that the deamon service could not stop correctly. I am running the Ciscoworks application on a Windows 2003 Server and got the below message when stopping the deamon service:

Could not stop the ciscoworks daemon manager service on local computer. Error 1053: The service did not respond to the start or control request in a timely fashion.

Cisco Employee

Re: Self Test Fail to query database.pl

Deleting the rmeng.db file was not what I told you to do. You've now completely destroyed your RME database.

To recover, do this. Set the Daemon Manager service to Manual in the Services control panel. Reboot the server. When it comes backup, run the following command:

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

Then set the Daemon Manager service back to Automatic, and reboot again. Your daemons should all come back up.

Community Member

Re: Self Test Fail to query database.pl

Hello

I did not delete the rmeng.db file, but move it to another folder. In the event that it was required again. I will copy the file back to the original directory, and restart the server.

Is there anything else I should do?

Cisco Employee

Re: Self Test Fail to query database.pl

You need to do what I outlined in my previous post:

You either have a corrupt database transaction log, or a corrupt database itself. First, shutdown Daemon Manager. If you have an NMSROOT/databases/rmeng/rmeng.log (note: rmeng.LOG NOT rmeng.DB), delete it. Then run:

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

Then restart Daemon Manager. That should get the database server to start. If not, then you have a corrupt RME database, and you will need to reinitialize:

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

Community Member

Re: Self Test Fail to query database.pl

I have now sucessfully created a new db file. This has resolved the errors being recieved.

However I would like to know if there is anyway of ascertaining previous saved configurations from the server. The ciscoworks server has full data backup conducted succesfully two weeks ago. Without rebuilding the entire server from that particular backed up image, is there any other way of retreiving the device configurations for previous months?

Cisco Employee

Re: Self Test Fail to query database.pl

No. You will either need to restore the full LMS backup, or start repopulating your RME database manually.

Community Member

Re: Self Test Fail to query database.pl

I have also done the below commands but this has not rectified the issue.

net stop crmdmgtd

net start crmdmgtd

Community Member

Re: Self Test Fail to query database.pl

Attached is the pdsgow output

418
Views
5
Helpful
11
Replies
CreatePlease to create content