CDA folder deletion error: Error (110001): The folder 'xxx' is already used by 1 objects and cannot be changed

book

Article ID: 198309

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

It is impossible to delete a folder in CDA/ARA:

Error (110001): The folder 'xxx' is already used by 1 objects and cannot be changed

Details: {id=357493.0, name=xxx}



Action: Delete folder xxx

How can I find the object preventing folder deletion

Cause

Run the following statement to see if there is any object nested inside that folder:

select sum(cnt) as objectCount from (
select count(EntityId) as cnt from Folder_Entity where FolderId=357943 UNION ALL
select count(Id) as cnt from Application where FolderId=357943 UNION ALL
select count(Id) as cnt from Component where FolderId=357943 UNION ALL
select count(Id) as cnt from DeplProfile where FolderId=357943 UNION ALL
select count(Id) as cnt from DeploymentTarget where FolderId=357943 UNION ALL
select count(Id) as cnt from Environment where FolderId=357943 UNION ALL
select count(Id) as cnt from LoginObject where FolderId=357943 UNION ALL
select count(Id) as cnt from Package where FolderId=357943 UNION ALL
select count(Id) as cnt from Resv where FolderId=357943 UNION ALL
select count(Id) as cnt from Workflow where FolderId=357943 UNION ALL
select count(Id) as cnt from ArtifactSrc where FolderId=357943 UNION ALL
select count(Id) as cnt from ArtifactInstance where FolderId=357943 UNION ALL
select count(Id) as cnt from Queue where FolderId=357943) tbl

In case the count > 0, there is at least 1 object existed in that folder. Run individual queries from each table above to find that object.

Example: select * from Workflow where FolderId=357943

In this case, there is a workflow nested in that folder (FolderID 357493) - Note: the null applicationID indicates that this is a general workflow

It is unable to delete this workflow from CDA side, there's an error: Folder cannot be null. 

Cause: this general workflow only exists in CDA's Database, there is no AE object linking to it. Also its parent folder on AE's side does not exist.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

First of all, empty the Recycle Bin and try again to delete the Folder, it should be successful this time.

In case the Recycle Bin is empty, the following procedure explains how to delete this object:

1. Go to Process Assembly Perspective > UC4.GENERAL (where general workflow should be stored)

2. Check if the workflow's parent folder (i.e PLAYGROUND - from CDA's properties) exists. If not, create this folder inside UC4.GENERAL

3. Create an AE general workflow object with following naming convention: RM.<PARENTFOLDERNAME>.<CDAOBJECTNAME>

For example in this case: RM.PLAYGROUND.TEST_DEPLOYMENT

4. The newly created AE object will link itself to the CDA workflow

5. Go to Release Automation Perspective > the workflow TEST_DEPLOYMENT > now this object can be normally deleted.

6. In the end, you can go to Administration Perspective > Users > delete the folder from Release Automation > Folder Authorizations