Why can't I find the object associated with the ACL that I want to delete?

Why can't I find the object associated with the ACL that I want to delete?

http://solutions.emc.com/emcsolutionview.asp?id=esg3684

 

WorkSpace will not allow you to delete an ACL if there are objects related to it. This is to maintain data integrity in the database.

When you cannot find the object associated with the ACL you want to delete, first try the following DQL queries to find the related objects:

1. To find ACLs related to dm_sysobject:

select r_object_id as obj_id, object_name from
dm_sysobject (all)
where acl_name ='<name of your ACL>' and
acl_domain = '<name of the user who created the ACL>'

2. To find ACLs as the default ACL of a user:

select user_name from dm_user where acl_name='<the ACL you want to delete>'

3. To find ACLs associated with a type:

select r_object_id, r_type_name from dmi_type_info where acl_domain='<ACL owner>' and acl_name='<name of you ACL>'

When these queries do not return any related objects and you still cannot delete the ACL, use tracing:

1. In the Message Tester or IAPI, execute the command: apply,c,NULL,SQL_TRACE,LEVEL,I,1

2. Then, try to delete the ACL that is causing problem.

Turn off tracing by executing:

apply,c,NULL,SQL_TRACE,LEVEL,I,0

3. Examine the session log for the trace output, located in $DOCUMENTUM/dba/log/<docbase_id>/<username>

Excerpt of the session log:

Tue Jan 19 17:57:38 1999 796000 [DM_ACL_E_DESTROY_IN_USE]error: "Failed to destroy the ACL 'Documentum Users' in domain 'dbabep' because it is in use."
Tue Jan 19 18:01:32 1999 609000 [DM_SESSION_I_SESSION_QUIT]info: "Session 01000dcb80010ccf quit."

4. Run the following query from Oracle SQL:

select r_object_id from dm_sysobject_s where acl_domain ='dbabep' and acl_name ='Documentum Users' union select r_object_id from dm_user_s where acl_domain = 'dbabep' and acl_name ='Documentum Users' union select r_object_id from dmi_type_info_s where acl_domain ='dbabep' and acl_name ='Documentum Users'

It will return the r_object_id value = 09000dcb800362c4.

5. Run the following query from IDQL:

select object_name
from dm_sysobject
where r_object_id='09000dcb800362c4'

If the above query returned nothing, then this object cannot be accessed by any Documentum WorkSpace method, only via SQL in the underlying Oracle database. The following entries must be deleted at the RDBMS level: dm_sysobject_s and dm_sysobject_r tables; there are no entries in the dmi_object table.