Document contains entry in i_folder_id for a non existing folder

Pedro Ventura

Hi,

I have a Documentum 6.5 SP1 environment in which I found a document containing an invalid ID in the i_folder_id attribute. The id is invalid because the folder referenced by it does not exist. This is preventing any updates on the document.

I've tried using DFC to unlink the document from that folder and to remove the entry from the i_folder_id, I also tried to do it through DQL and even through API. Every time I tried it the update failed saying the folder referenced by that ID didn't exist. Is there any way to remove this entry from the document other than doing it directly in the database?

Regards,

Pedro Ventura

Hartmut_Clausen

I used this solution in 5.3.x so it might not work in D6.5

If there are other entries in the i_folder_id attribute you can delete the erroneous entry.

remove,c,<id>,i_folder_id[<index>]

save,c,<id>

If the erroneous entry is on index zero (that is the missing folder was the “primary” link) you have to replace it with a valid value for an existing folder. In that case you also need to update the primary cabinet “i_cabinet_id” with a matching one to the new folder.

This operations are not possible in API, they will cause an [DM_SYSOBJECT_E_CANT_FETCH_FOLDER], even if the erroneous folder is no longer referenced. In DQL it is also not possible since the attributes i_folder_id and i_cabinet_id are not updateable. Therefore the operation has to be performed in SQL directly in the database.

      update dm_sysobject_r set i_folder_id='<new folder id>' where r_object_id='{r_object_id}' and i_position=-1;

update dm_sysobject_s set i_cabinet_id='<new cabinet id>' where r_object_id='{r_object_id}';

commit;