AWA v11.2 FOLDER existing but not visible

Document ID : KB000115364
Last Modified Date : 19/09/2018
Show Technical Document Details
Issue:
After deleting a folder object, the 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.

 
Environment:
- UC4 Version 11.2.0+build.2347
- Oracle DB 12c
Cause:
The oh_deleteflag got set to 2 when it is supposed to be 0 or 1.
Resolution:
1. Set the deleted flag for the "problem folder" back to 0 direct in the db: something like
"update oh set deleted=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 folder once more through the gui
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.