You are viewing limited content. For full access, please sign in.

Question

Question

In Progress Instance Not Assigned to a User

Forms
Updated February 14, 2015
asked on January 22, 2015

We have an instance in progress instance in Forms that is not assigned to a user even though it is currently at a User Task step:

If you look at the 3rd item in the screenshot above, it says "In Progress", but does not have someone assigned to it. How do I fix this so it can move on?

0 0

Answer

SELECTED ANSWER
replied on February 14, 2015

An SCR was filed for the issue and it would be fixed in the upcoming Forms 9.2.1 release. A manual script was provided to update the database to clear out the problem instance.

0 0

Replies

replied on January 23, 2015

Hey Blake,

The results page currently only shows the user if they completed the task. It's likely already assigned to a user, as it normally fails if nobody is assigned the task. Try running this query, but replace <Instance Id> with the specific instance id of that process (should be the last number in the URL of that page):

select s.* from cf_bp_worker_instances as wi, cf_bp_worker_instnc_to_resume as wr, cf_bp_instance_approvers as a, cf_user_snapshot as s
where wi.bp_instance_id = <Instance Id> and wi.instance_id = wr.worker_instance_id and wr.resume_id = a.resume_id and a.user_snapshot_id = s.id

You should get the user who the task is currently assigned to.

0 0
View 1 previous reply
replied on January 23, 2015

Dustin, I performed the query you supplied and changed out the Instance ID, but the query came back with no results.

0 0
replied on January 23, 2015

Hm, can you show me a screenshot of the process and a screenshot of the results page with the task column expanded? I noticed that the top and bottom tasks were both started at the same time. It's possible another event was duplicated or run twice and is what's causing the delay (like a timer wait event).

Also, this query should give you every User Task in that process. The Instance Id is 61 from the URL "http://localhost/Forms/BP/Listing/12##61".

select wr.* from cf_bp_worker_instances as wi, cf_bp_worker_instnc_to_resume as wr
where wi.bp_instance_id = <Instance Id> and wi.instance_id = wr.worker_instance_id

Let me know if this query is still blank, in which case there shouldn't be any User Task actively assigned.

0 0
replied on January 23, 2015 • Show version history

I am only including a partial screenshot of the process as it is quite large.

I'm not exactly sure what you mean by "the task column expanded". Could you please clarify that for me?

Also, the query you asked me to run returned no results.

0 0
replied on January 23, 2015

Sorry about my previous statement, ignore the column expansion part. I think this will require a support case to look into it further. It appears that there's possibly an extra intermediate timer event blocking that process branch and no User Task has been created yet (I'm guessing the AdminRC task has a 7 day Intermediate Timer Event based on the time interval).

0 0
replied on January 26, 2015

A support case has been created for the issue. We will update this thread once the issue is resolved.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...