Clarity PPM

Expand all | Collapse all

Manual action does not work for some resources

Jump to Best Answer
  • 1.  Manual action does not work for some resources

    Posted 11-09-2015 09:39 AM

    Hello,

     

    we have got a custom attribute based on Query lookup and we use this lookup in process in a Manual Action. For some custom resources it's OK but for some custom resources it's not working and the process goes to error.

    The error in UI of Clarity is:

    BPM-0519: Internal Process Engine Error. Contact your site administrator (Object wirh name 'thisIdea' refers to object 'idea' bound to the instance '5004000' is not found).

     

    and in bg-ca.log is following:

    Read of object: process instance ID: 50040007 returned: 0 rows

     

    Clarity version is: 14.2.0.237

     

    Please have someone met this problem?

     

    Any ideas how to solve this?

     

    Thank you in advance.

     

    Regards,

    Martin



  • 2.  Re: Manual action does not work for some resources

    Posted 11-17-2015 03:25 PM

    Martin,

     

    are you able to share the process or expand on what its purpose is?

    Which object is it primarily based on?

     

    #helpinghands



  • 3.  Re: Manual action does not work for some resources

    Posted 11-19-2015 03:14 AM

    Hello,

     

    primary object of the process is Idea object.

     

    I'll provide here xog export of the process as well as the lookup query.

     

    Regards,

    Martin Snizek



  • 4.  Re: Manual action does not work for some resources

    Posted 11-19-2015 05:40 AM

    Hello,

     

    here is the lookup query:

    select

    @SELECT:id:resource_id@,

    @SELECT:user_id:user_id@,

    @SELECT:full_name:full_name@

    from srm_resources

    where user_id in

    ( select user_id

    from cmn_sec_user_groups ugr

    left join cmn_sec_groups gr on gr.id=ugr.group_id

    where gr.group_code='c_approvers')

    and @FILTER@

     

    I'll also attach the process XOG export after I'll find out how to do it in this new community.

     

    Best Regards,

    Martin



  • 5.  Re: Manual action does not work for some resources

    Posted 11-19-2015 05:46 AM
      |   view attached

    Hello,

     

    here is the process XOG export.

     

    The purpose of the process is that after submitting idea for approval, this process starts and send notification/manual action to users in custom attribute based on the lookup above.

     

    Best Regards,

    Martin

    Attachment(s)

    zip
    process_write.xml.zip   6K 1 version


  • 6.  Re: Manual action does not work for some resources

    Posted 11-18-2015 01:50 AM

    Hi Martin,

     

    The error is very generic, will it be possible to attach the bg logs please.

     

    Regards

    Suman Pramanik



  • 7.  Re: Manual action does not work for some resources

    Posted 11-19-2015 03:13 AM

    Hello Suman,

     

    there is not any message in bg logs

     

    Regards,

    Martin Snizek



  • 8.  Re: Manual action does not work for some resources

    Posted 11-19-2015 03:49 AM

    Is it possible that your query (in the lookup) does not return results for the data related to these "custom resources" and that is causing a problem in the process?

     

    (just GUESSing obviously)



  • 9.  Re: Manual action does not work for some resources

    Posted 11-19-2015 05:42 AM

    Hello David, thank you for your guess. I checked the query and the result which is returned and it seems to be OK. The query returns only members of one group and it really returns all of them and nothing more. You can see the query of the lookup above in this thread. Best Regards, Martin



  • 10.  Re: Manual action does not work for some resources
    Best Answer

    Posted 11-19-2015 10:30 AM

    Hello,

     

    I found where the problem was. Because of the process approves the idea after "approving" the action item by user, there is a need of the user to have right Idea - Approve All. After adding this right to the group which members are provided by the lookup the process works.

     

    Thank you all for help and ideas.

     

    Best Regards,

    Martin Snizek