Problem creating/linking some folders

Question

Hi,

SO: Windows 2008 x32

We have an issue creating some folders: We've realized that when we try to create from DA a folder with a widely repeated name, the creation fails in the linking job.

One example of folder name is 'GENERAL'. There are several millions of folders named GENERAL in different paths, and the creation fails on dm_folders as well as on custom folder types.

We have noticed this issue in DCTM 6.7 (SP1 patch 22) when migrating from 6.5, and it is present only in 6.7.

Activating SQL traces we can see it fails executing this sql when trying to create a folder:

select all dm_folder.r_object_id from dm_folder_sp  dm_folder where

(dm_folder.r_object_id in (select r_object_id from dm_folder_r where r_folder_path='/DOC/SINIESTROS NO-VIDA/C117/30/2014-01/3085463723369/GENERAL')

and (dm_folder.object_name='GENERAL')) and (dm_folder.i_has_folder = 1 and dm_folder.i_is_deleted = 0)

Regrads,

Axel G.

saavedra · Accepted Answer

Hi Axel,

You will need to add this to dfc.properties file:

dfc.query.object_name_for_docbase[0]=<REPOSITORY_NAME>

dfc.query.should_include_object_name[0]=false

And, in order Documentum to be able to leverage the lines above, you need to apply the last patch of DCTM 6.7