Error When Attempting to Unlock or Delete from Enterprise Analyzer Queue
Problem:
When using Enterprise Analyzer Administration to either Unlock or Delete items from the Queue Processor, there is an error message. The error message may say: Element with key does not exist in the collection.
Resolution:
Certain objects in EA can fail in the Queue Processor. These objects can not be removed using EA Administration. Therefore, the removal step must be performed on the actual database.
The table in the database is the "Queue" table and the following query can be used to delete the entry:
delete from Queue where objID = 'xxxx';
where xxxx is the object ID referenced in the error message. The specific object needs to resolved so once the entry is deleted from the Queue table, it would help to invalidate that file and re-verify.
