Ghost object
Options
Comments
-
If you have object ID of the folder, run this DQL query to get all objects linked to it:
select r_object_id,object_name from dm_sysobject where any i_folder_id='<object id>'
Once you have the object id of the ghost object, try this DQL to delete the object:
delete dm_sysobject object where r_object_id='<object id>'
0 -
Hello,
Thanks for your sugestion. I found it by another way because the object has been linked to events. The problem happened when they try to rename the user profile. The object belonging to this older user was not reassigned to the new one. anyway there are the queries I used to fix it:
0) select * from dmi_registry_s where user_name like '%Assis%'1) select i_chronicle_id from dm_sysobject where r_object_id='09007f91800da958'2) select * from dmi_registry where r_object_id='I_CHRONICLE_ID'3) execsql,c,update dmi_registry_s set user_name ='NOUVEL USAGER' where user_name ='ANCIEN USAGER' and registered_id =''CHRONICLE ID DU DOCUMENT'Great thanksR.0
Categories
- All Categories
- 108 Developer Announcements
- 49 Articles
- 100 General Questions
- 122 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management