Dealing with workflow methods. Part I

In next blogpost I’m going to describe some pitfalls related to workflow engine in Documentum, for now you can enjoy nice diagram demonstrating how Content Server processes automatic workflow tasks:

Some facts:

  • Master agent idle time is defined in dm_server_config.wf_sleep_interval
  • Amount of Worker agents is defined in dm_server_config.wf_agent_worker_threads
  • Worker agent idle time is a hardcoded value of 10 seconds
  • Content Server waits 1 second after spawning each Worker agent
  • To start tracing workflow agent issue
    apply,c,,SET_OPTIONS,OPTION,S,trace_workflow_agent,VALUE,B,T

    API command

  • To stop tracing workflow agent issue
    apply,c,,SET_OPTIONS,OPTION,S,trace_workflow_agent,VALUE,B,F

    API command

  • To stop workflow agent issue
    apply,c,,SHUTDOWN_WORKFLOW_AGENT,TIMEOUT,I,<timeout>

    API command

  • To start workflow agent issue
    apply,c,,START_WORKFLOW_AGENT

    API command

  • DQL below displays the amount of auto-activities not yet placed in workflow agent queue:
    SELECT count(r_object_id) AS work_queue_size 
    FROM dmi_workitem
    WHERE r_runtime_state IN (0, 1)
     AND r_auto_method_id > '0000000000000000'
     AND a_wq_name is NULLSTRING
  • DQL below displays the amount of auto-activities placed in workflow agent queue:
    SELECT count(r_object_id) AS work_queue_size 
    FROM dmi_workitem
    WHERE r_runtime_state IN (0, 1)
     AND r_auto_method_id > '0000000000000000'
     AND a_wq_name ='<id of dm_server_config>'

4 thoughts on “Dealing with workflow methods. Part I

  1. Pingback: Dealing with workflow methods. Part II | Documentum in a (nuts)HELL
  2. Pingback: When documentum had started dying | Documentum in a (nuts)HELL
  3. Pingback: JMS high availability feature | Documentum in a (nuts)HELL
  4. Pingback: Why CURSOR_SHARING=FORCE sucks. Part II | Documentum in a (nuts)HELL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s