How to manually update the discovery status from database using query (4378508)

Sometimes, discovery is stuck in processing state and options to cancel and delete are greyed out, seems stuck somehow. 

In this case, please try restarting the "Quest Enterprise Reporter Server" service and then see if it lets you make the changes to the affected discovery. If the issue persists, please try below steps.

a- Open ER Configuration Manager.
b- Click the discovery that is stuck to select it.
c- Click on "View Queue" located on the top of the console.
d- Click cancel.

By performing the above steps, if you still see the issue, follow below steps:

1. Make sure there are no discoveries are running and that you have recently taken a full backup of the database.
2. Stop all services
3. Run the below against the "dbReporter" database (this is the default database name, if you are using a different name, please modify the first line of the following query accordingly) from SQL Management Studio:

use dbReporter
update [tblTask] set Status = 'Finished', AssignedNodeID = null, EndDate = StartDate, SeqNo = null where [Status] not like '%%Finished%%'
update [tblJobRun] set Status = 'Finished', EndDate = StartDate, SeqNo = null where Status not like '%%Finished%%'

4. Start services

This will change the status from DB, and you can modify the discovery.