Question

Deleted User in Forms has Pending Task

Forms Version 9

Updated February 11, 2016

asked on February 9, 2016 • Show version history

A user was deleted but had a pending task in Forms. I tried recreating the user but was told that it’s not showing the Pending task because the user is essentially a new user with a new UID. How do we go about approving the task if the user isn’t in the system anymore? Is there a SQL table modification route that can be used? This is for Forms 9.2.1.1069.

0 0

Replies

replied on February 9, 2016

You can reassign the pending task w/ sql.

1. Find the userid of the deleted person

Located in the cf_user_snapshot table. The id you are looking for is column "user_id"

2. Find the userid of the person you wish to assign it to

Located in the cf_user_snapshot table. The id you are looking for is column "user_id"

3. Find the current task assigned to the old user

One row is located in cf_bp_worker_instnc_to_resume, column "owner_snapshot_id"

Another row is located in cf_bp_instance_approvers, column "user_snapshot_id"

"Owner_snapshot_id" and "user_snapshot_id" will have the same value along with a matching "resume_id". An entry is made per task per user.

4. Update the current task to the new user

Change the user_id to the new user in both spots mentioned in step 3.

The task will now show up in the inbox of the new user instead of the old user and future history will display the approval as such.

*Note, directly modifying the underlying SQL is a last resort option as it is an supported area of Laserfiche, you are relying on myself (a regular user), who did this once before, so please proceed with caution.

0 0

replied on February 10, 2016

Thank you for this workaround. When I go to cf_bp_worker_instnc_to_resume I don't see the column "owner_snapshot_id" The columns that are there are resume_id, worker_instance_id, step_id, step_name, form_id, resume_count, status and last_submission_id. Also in cf_user_snapshot the user_id says Null so I would most likely just have to go with the id column right?

0 0

replied on February 11, 2016

Ah my apologies I was looking at the LF10 tables instead of LF9.2.

New instructions:

1) In [cf_bp_instance_approvers] all rows correspond to a current task waiting on a user. The value in the "user_snapshot_id" will correspond to user the task is waiting on.

2) In [cf_user_snapshot] find the user ID's you wish to identify. Another table which contains an index of users by "user_id" is the [cf_users] table, is this value null here as well?

This is where you reported null values in the "user_id" column. In my instance, this column was populated for all rows, along with the "id", however they were not the same and "user_id" is what corresponded to the "user_snapshot_id" or "cf_users" in the pending task row.

We use AD accounts on RIO and none of these are forms participant accounts. I'm not sure if that plays into it at all or not.

I'd write down the values in the [cf_bp_instance_approvers] table and then attempt to reassign the tasks to myself. Once successful, reassign to whomever you desire based on the "user_id" value.

0 0

You are not allowed to follow up in this post.

Question

Question

Deleted User in Forms has Pending Task

Replies

Sign in to reply to this post.