Some live saving facts about day to day activity in documentum environment

Below are some facts which I personally think very useful. Hope you guys finds the same.

Fact -1 

You want to change the content of a document to test something very quickly. Many times for some unknown reason UCF error is one of the hurdle in your way, so in such scenario using below API you can do it very easily-


retrieve,c,dm_sysobject where object_name='test.xml'
checkout,c,l
setfile,c,l,'[TempLocation]\test.xml',xml
set,c,l,log_entry
Testing the xml content
checkin,c,l

Fact - 2

Quick way of Cleaning up dmi_queue_item table - garbage entries of full text users.

dmi_queue_item is one of the table which is responsible for performance of your system functionalities like workflows.
Many time, I noticed we have entries of full text index users which does not make sense, may be because of upgrade or failed index requests or removal of index agents.

To clean up, you can follow the below steps -
1. Shutdown your repository services.2. take back up of the table by using below command -

exp USERID=<schema_user>@<schema_name> FILE=<schema_user>_dmi_queue_item_s.DMP LOG=<schema_user>_dmi_queue_item_s.LOG full=n TABLES=dmi_queue_item_s consistent=y compress=y statistics=none BUFFER=2000000 RECORDLENGTH=64000

3. Execute below queries

SQL:

CREATE TABLE dmi_queue_item_s_backup AS (SELECT * FROM dmi_queue_item_s where name !='dm_fulltext_index_user');

truncate TABLE dmi_queue_item_s;

insert into dmi_queue_item_s select * from dmi_queue_item_s_bkp;

drop table dmi_queue_item_s_backup;

PURGE recyclebin;

You can manage user events according to your need.

4. Restart your repository services.

FACT - 3

For version mismatch error during workflow activities -
I found setting up below parameters resolved most of the issues

retrieve,c,dm_docbase_config 

dump,c,l

append,c,l,r_module_name

WF_SKIP_PARALLEL_TASK_EXECUTION

append,c,l,r_module_mode

1

save,c,l

retrieve,c,dm_docbase_config 

dump,c,l

To be continued ...