Manual Interpretation Documentum r_object_id

1. Execute the below DQL query  to get ( data_ticket ,file_format, file_path, docbase_id )

select data_ticket, dos_extension, r_docbase_id, file_system_path from dmr_content c, dm_format f, dm_filestore fs, dm_location l, dm_docbase_config dc where any c.parent_id = '09XXXXXXXXXXXXXX' and f.r_object_id = c.format and fs.r_object_id = c.storage_id and l.object_name = fs.root

data_ticket          dos_extension     r_docbase_id     file_system_path
 -2147483646      ppt                      55555                 /NFS/data/EMC_LIFE/content_storage_01

2. Data ticket convertion formula

1)      Data ticket +  2’s complement of 32  ►► -2147483646 + 4294967296 = 2147483650

2)      Convert result of step 1 as HEX    ►► converting 2147483650 to hex = 80000002

3)      Split each 2 digit as the HEX value (step 2 answer) ►► 80\00\00\02

4)      Convert the      r_docbase_id (99999) to hex  ►►000186F9  ( add zero before , the digit count should be 8 )

3. Assemble the values:

Step 1 ,file_system_path + step 2 ,4 value + step 2, 3 value +Step1 dos_extension

/NFS/data/EMC_LIFE/content_storage_01/000186F9/80/00/00/02.ppt  

Content server API

1. Get file path API (storage location)

API>getpath,c,09XXXXXXXXXXXXXX
...
/NFS/data/EMC_LIFE/content_storage_01/000186F9/000184b9/80/00/00/02.ppt
API>

2. Get file API ( get the content file in your local  drive)

API>getfile,c, 09XXXXXXXXXXXXXX
...
/NFS/documentum/local/process9122184072070732161.tmp/208/060184b980000100.ppt
API>