AWA: FOLDER invisible keeps from creation / removal of FOLDERS

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Symptom 1:

User is unable to create a new Folder object with the same name as the deleted object.
The error message generated is

Error: U04006519 An object named 'xxx' already exists

Symptom 2:

User is unable to delete a Folder Object as it contains invisible SubFolder/s that are not displayed in AWI.

When cloning the folder, a sub-folder appears in the cloned Version, which can be deleted and then the clone as well.

The original folder still appears to be empty, the name that appeared in the clone can't be searched either (no search results return after deleting the cloned sub-folder).

Environment

- One Automation 11.2 and Superior
- Database Oracle DB

Cause

Symptom 1:

The oh_deleteflag was set to 2 (versioned)  when it is supposed to be 0 (not deleted) or 1(deleted).

Symptom 2:

The oh_deleteflag of the subfolders was set to 1  when it was supposed to be 0.

Resolution

The resolution for both  Symptoms is the same, the oh_deleteflag column for the affected Folder Objects should be updated to 0 (Not Deleted) so they are visible again in AWI and can then be deleted properly.

1. Set the oh_deleteflag for the "Problematic folder/s" back to 0 in the database with a SQL Statement like the following  (being 999999999 the oh_idnr of the impacted folder/s):

"update oh set oh_deleteflag=0 where oh_idnr=999999999"

2. Create a new temporary folder somewhere and access it, so the folder tree is rebuilt, and the restored folder is visible once again.

3. Then try to delete the problematic Folder again through the AWI

Additional Information

SELECT OH_Client AS CLIENT, OH_OType AS Object_Type, OH_Name AS PATH, OH_DeleteFlag AS DELETED, OH_Idnr FROM OH
WHERE OH_OType = 'FOLD' AND OH_Name LIKE '%PROJECTS%'
ORDER BY OH_Name;

Using this statement, and replacing PROJECTS with the folder name, you can get the OH_Idnr.

 Then, you can use another statement like the following to delete a list of different folders ( 5356155,5357626,5357628 and 5356176)on a particular CLIENT (4399):

update oh
set OH_DELETEFLAG = 0
where oh_idnr in ('5356155','5357626','5357628','5356176')
and OH_CLIENT = '4399';