Documentum Housekeeping Jobs

Hello readers,

Sometimes when we develop applications with Documentum the repostory/docbase gets corrupted and unusable. To fix this Documentum has a couple of special jobs.

Please read this very well written whitepaper "Seven Jobs Every Documentum DeveloperShould Know and Use" from M. Scott Roth.

Kind regards, Marcus

Restarting tomcat application server

Hello readers,

While developing with Taskspace I find myself often restarting tomcat on Windows.
A quick method to do this is a BAT file to also clear the cache folders.
Below you will find the script.

@echo OFF
:stop
@echo stopping service
sc stop tomcat6
ping 127.0.0.1 -n 20 -w 1000 > nul
sc query tomcat6
find /I "STATE"
find "STOPPED"
if errorlevel 0 goto start
goto stop
:start
@echo removing work
rmdir /S /Q "C:\Program Files\Apache Software Foundation\Tomcat 6.0\work"
@echo removing temp
rmdir /S /Q "C:\Program Files\Apache Software Foundation\Tomcat 6.0\temp"
@echo making new temp dir
mkdir "C:\Program Files\Apache Software Foundation\Tomcat 6.0\temp"
@echo removing presets
rmdir /S /Q "C:\Program Files\Apache Software Foundation\Tomcat 6.0\documentum\presets"
@echo removing cache
rmdir /S /Q "C:\Program Files\Apache Software Foundation\Tomcat 6.0\documentum\cache"
ping 127.0.0.1 -n 3 -w 1000 > nul
@echo starting service
sc start tomcat6

Kind regards, Marcus

Fix process form relations

Hello readers,

It could occur that the form relation with the process is gone and you cannot select it in the process anymore. This can be done by selecting "remove form" in the Activity Inspector of Process Builder. A quick way to fix this:

create dm_relation object set relation_name = 'dm_process_form', set parent_id = (select r_object_id from dm_process where object_name = '{process object name}'), set child_id = (select r_object_id from dm_xfm_form where object_name = '{task object name}'), set permanent_link = 1;

If you have multiple versions of a process or form please use the r_object_id's instead of the sub-queries.

Kind regards, Marcus

Documentum User Inbox Query

Hello readers,

A really simple yet effective DQL query is the following:

EXECUTE get_inbox WITH name='{user}';

It gives you information about the task but also the workflow and the included packages.

Kind regards, Marcus

Fetch all Form Adaptor DQL queries by DQL (Forms Builder)

Hello readers,

This query is very nice to quickly look into all the DQL queries used in Form Adaptors made in Forms Builder.

select r_object_id, object_name as adaptor, title as description, param_value as dql
from dmc_xfm_adaptor_config where impl_class like '%DataSourceAdaptorService';

Kind regards, Marcus

Disabling e-mail notifications

Hello readers,

The Documentum Content Server will send e-mail notifications for certain events by default. To turn off all e-mail notifications you just have to add or adjust one setting in the "$DOCUMENTUM\dba\config\documentum\server.ini" file.

mail_notification = F

Restart the repository for the change to take effect.

Kind regards, Marcus