Workflows are not running & tasks are moving to 'Future' state

Hello Experts,

One of our Customised Application was working fine when it was pointed to a Old HPUX box, latter a new clone was created on RHEL supported version. Our CS & Webtop are on 67SP1.

Now after the Webtop is pointed to the new CS, none of the WFs are running and all the Tasks are moving to 'Future' state automatically.

Have taken the below steps:

1. Restarted Application Server along with Cache clean

2. Restarted Docbase, JMS along with verification of Agent Exec status, which is running

3. The New CS is having other repositories, where they are not facing any issues with JMS or WFs

4. No error message on Application Server logs( i.e. Tomcat), JMS Logs or Content Server logs.

5. Even running the WFs with Superuser account doesn't help

Carried out a DFC trace and found the below exception only for the below DQL related to Workflow with a BAD ID. Have highlighted in RED

Please let me know, what should be the next action steps to fix it.

[email protected]baseApi ==> [email protected]

2013-12-20 10:30:13.526 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [RPC_ENTER] ....RPC: applyForCollection("EXEC",null,[email protected][readOnly=false, autoFill=true, fetchTimestamp=0, values=[QUERY=select p.r_act_name, p.r_act_def_id, a.a_status  from dm_process p, dm_activity a where p.r_object_id='4b01a7aa8002133b' and any p.r_act_type=4 and a.r_object_id=p.r_act_def_id and a.exec_subtype=3 enable (row_based), FOR_UPDATE=F, BATCH_HINT=50, BOF_DQL=T, FLUSH_BATCH=-1]],50,true,true)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [RPC_EXIT]  ....RPC: applyForCollection ==> TypedDataIterator{collectionId=1, open=true, maybeMore=false}

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected] ==> [email protected]c

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]ery ==> [email protected]c

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     ..com.documentum.fc.client.impl.collection.TypedDataCollection.newInstance(com.documentum.fc.client[email protected]82cd4c,[email protected]7)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     ...com.documentum.fc.client.impl.collection.TypedDataCollection.getTypedData(com.documentum.fc.client[email protected]82cd4c)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      ...com.documentum.fc.client.impl.collection.TypedDataCollection.getTypedData ==> [email protected][type=QR, readOnly=false, autoFill=false, fetchTimestamp=0, values=[r_act_name=, r_act_def_id=, a_status=]]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]<init>()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]<init> ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]<init>([email protected][type=QR, readOnly=false, autoFill=false, fetchTimestamp=0, values=[r_act_name=, r_act_def_id=, a_status=]],[email protected]7)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]([email protected][type=QR, readOnly=false, autoFill=false, fetchTimestamp=0, values=[r_act_name=, r_act_def_id=, a_status=]])

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected] ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]on([email protected]7)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected].getDynamicHandle()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]ynamicHandle()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]1.<init>()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]1.<init> ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]71894>              [Timer-23] [ENTER]     ..[email protected]ed3c51.<init>([email protected])

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]tSessionManager()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]tSessionManager ==> [email protected]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]tDocbaseName()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]etDocbaseSpec()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]etDocbaseSpec ==> DocbaseSpec{[email protected]}

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]tDocbaseName ==> "OCDDocs"

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     ...[email protected]ed3c51.setCurrentSession([email protected])

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]etWeakHandle()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]etWeakHandle ==> [email protected]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      ...[email protected]ed3c51.setCurrentSession ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      ..[email protected]ed3c51.<init> ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]ynamicHandle ==> [email protected]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected].getDynamicHandle ==> [email protected]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]on ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]sion([email protected]7)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected].getDynamicHandle()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]2ed5.getDynamicHandle()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]ynamicHandle ==> [email protected]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected].getDynamicHandle ==> [email protected]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]sion ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]<init> ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]b83248.<init>(com.documentum.fc.client[email protected]82cd4c,[email protected]7)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]b83248.<init> ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]1359.<init>([email protected]248)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]1359.<init> ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]etLastCollection([email protected]9)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]tCollection([email protected]9)

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]tCollection ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]etLastCollection ==> <void>

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      ..com.documentum.fc.client.impl.collection.TypedDataCollection.newInstance ==> [email protected]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected] ==> [email protected]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected] ==> [email protected]

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]9.next()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     .com.documentum.fc.client.impl.collection.TypedData[email protected]()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]3248.next ==> false

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]9.next ==> false

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]bject(DfId{0000000000000000})

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected](DfId{0000000000000000})

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]<init>()

2013-12-20 10:30:13.557 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      [email protected]<init> ==> <void>

2013-12-20 10:30:13.573 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     [email protected]tManager(DfId{0000000000000000})

2013-12-20 10:30:13.573 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     ...com.documentum.fc.common.DfUtil.formatString("Bad ID given: {0}",java.lang.Object[1]@ab9a5a)

2013-12-20 10:30:13.573 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [EXIT]      ...com.documentum.fc.common.DfUtil.formatString ==> "Bad ID given: 0000000000000000"

2013-12-20 10:30:13.573 <ocdsscm|s2(18.1)|[email protected]>              [Timer-23] [ENTER]     ...com.documentum.fc.common.impl.ExceptionCompatability.mapMessageIdToErrorCode("DM_API_E_BADID")

Comments

  • edited December 20, 2013

    Please consider moving this question as-is (no need to recreate) to the proper forum for maximum visibility.  Questions written to the users' own "Discussions" space don't get the same amount of attention and can go unanswered for a long time.

    You can do so by selecting "Move" under ACTIONS along the upper-right.  Then search for: "Documentum" and select the first result that appears.  This will relocate it to the Developer Network space of the Documentum community.

    Documentum

    For further guidance on engaging with the communities for Documentum and related products, please refer to the

    IIG Communities Getting Started Guide.

  • edited December 23, 2013

    Thanks a lot Chris for this pointer!

  • PanfilovABPanfilovAB blog.documentum.pro
    edited December 23, 2013

    If you think that auto-activities are not executed you should start with tracing workflow agent and methods, dfc trace will not help.

  • edited December 26, 2013

    Hi Pan,

    These are not Auto - Activities, most of them are Manual & few are Auto Activities. Its happening for all WFs, not only for a specific WF or WF Instance.

    Have restarted Docbase, in order to have AGENT EXEC restarted, along with JMS after clearing Cache, still the WFs are not running. Further to surprise, there are no error message being reported on the Application Server or JMS or CS logs.

    Regards,

    Rakesh

  • edited April 3, 2014

    Ra_X, have you found the cause?

    Tks.

  • edited April 16, 2014

    Is there any response to this thread ? We are facing the same trouble with Activities at future state.

  • edited April 17, 2014

    Hi Stein & Abdoulaye,

    I haven't found any solutions on it yet, as its our Development Environment.

    Currently have pointed it to another Environment and its working fine there. Am still investigating on it but got diverted due to Server & OS upgrades.

    Will keep you posted, if any findings from my end.

    Regards,

    Rakesh

  • edited April 17, 2014

    Rakesh, I was having something similar and the cause was that an activity was configured to wait for 2 inputs and only had 1. In the process builder the activity inspector was not displaying the input configuration and we had to modify the activity template definition.

  • edited December 17, 2016

    I faced similar problem because trigger condition in auto activity.. It's waits for two input at the same time but actually I designed for either one configuration... After changing the trigger condition it works fine as expected.

Sign In or Register to comment.