Manually delete objects from the Recycle Bin

Products

• CA Process Automation Base

Issue/Introduction

When an object is deleted from the Library, it's moved to the Recycle Bin before actually delete it. It's important to review the Recycle Bin often and not leave old objects there since it's possible that after several months (or years) there may be issues while trying to delete those old objects:

This article explains how to manually delete objects from the Recycle Bin directly from the database.

Environment

Process Automation 4.3 and above

Resolution

NOTE: This article suggest to run queries directly on the database, so before doing this, it's recommended to take a full backup, as a way to have a safe point to come back if something happens.

Here is shown that 1 object was moved to the Recycle Bin:

By running the following query, this object is shown:

select * from C2ODocument
where IsDeleted = 1
and
DocumentType = 'Flowchart'

NOTE: "DocumentType" can be changed to 'Folder', 'Dataset', 'Flowchart', etc.

Now, in order to delete an item from the Recycle Bin, you can run this query:

delete from C2ODocument
where IsDeleted = 1
and
DocumentType = 'Flowchart'

NOTE: This query will delete ALL processes in the Recycle Bin.

After the query was executed, the item on the Recycle Bin was removed: