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
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).
The oh_deleteflag was set to 2 (versioned) when it is supposed to be 0 (not deleted) or 1(deleted).
The oh_deleteflag of the subfolders was set to 1 when it was supposed to be 0.
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
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):
set OH_DELETEFLAG = 0
where oh_idnr in ('5356155','5357626','5357628','5356176')
and OH_CLIENT = '4399';