HI,
We have a virtual document with object_name as A018-T-217-2011-12-RC-15-206-CE.On getting its r_version_label,revision_nr,r_object_id through DQL query we get the following result :-
r_version_label revision_nr r_object_id
================================ ======
0.1 0 0900020080b3c219
CURRENT 1 0900020080b5594f
1.0
When we try to delete the document with r_object_id 0900020080b5594f through API we get the error stating that "Cannot destroy sysobject named: 'A018-T-217-2011-12-RC-15-206-CE' since it is referenced by another compound document or an assembly object."
To check where is it being referenced we ran the query on dmr_containment with the component_id of the document and the query gave no results as shown below :-
select * from dmr_containment where component_id='0900020080b5594f';
r_object_id parent_id component_id version_label order_no use_node_ver_label
follow_assembly copy_child
================ ================ ================ ================================ ======== ================== =============== ==========
(0 rows affected)
Can u pl suggest why is this query not returning any result.
Pl suggest how to delete the object.
