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

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

Unable to Set the PresetContext for PresetService

Hello readers,

If you are developing in Documentum Taskspace you may encounter the following error message while you login.

Unable to Set the PresetContext for PresetService. PresetService will not be available.

UPDATE:
First try to clean the caches and empty the "C:\Documentum\Presets\" folder both on the application server. Sometimes the configuration is cached wrong.

ELSE:
This will most likely be the problem that the wrong ACL is set for your configuration objects. You can find the objects in "/System/Applications/YourApplication/Presets/".

All the configuration objects in this folder (and subfolders) need to have the "dmc_wdk_presets_acl" ACL. The owner needs to be "dmc_wdk_presets_owner". 

Make sure that all sub-folders and all underlying objects have the correct ACL!

Now Taskspace will have full access to the objects and the problem should be solved.

Kind regards, Marcus

Taskspace users not available

Hello readers,

As you may all know Taskspace is the workflow client from EMC.
Taskspace is working with an user inbox where the tasks for the user will appear.
If you ever wonder why another user gets an inbox task, please keep in mind that users can set them-selfs to not available and delegate there tasks to someone else.

Here are some screenshots where you can see this feature.

So be careful when you start analyzing your process templates.
To quickly see what users are not available, this DQL query can come in handy.

select r_object_id, user_state, user_name, user_os_name, user_address, user_source, user_login_name, workflow_disabled, user_delegation, last_login_utc_time from dm_user where user_state = 0 and workflow_disabled = true;