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

Question

Question

Task stuck on email notification

asked on June 18, 2018

Morning All, 

I have a task that has been stuck in progress for a couple weeks now that I just discovered.  The task that it is stuck at is just an email notification task and it only has one, default outflow.  Where it is still technically, in progress, I cannot see how I can try to re-try the email notification task to see if that will push the task through or exactly how to resolve this.  Anyone have any suggestions?  

 

Thanks


Drew

1 0

Replies

replied on March 19, 2020

Hey Matthew, I unfortunately don't remember how I was able to resolve my issue but I am sure it was not as elegant as your solution above.  Thanks for sharing.

1 0
replied on June 18, 2018

Hello
Please check the recipient's email account, sometimes if it has some inappropriate character this happens

0 0
replied on June 19, 2018

Morning Ricardo,

Thanks for the reply.  This same user has received all of the other notifications within this workflow and others so I don't believe this to be the case in this instance. 

 

Drew

0 0
replied on June 19, 2018

Hey Drew, one thing you can do is go into the Process Modeler and put the correct email address into the 'Send to' field for the email activity, and then retry the step.  If it is a variable listed, just put the direct email address in there temporarily so you can continue the process, you can always go back and figure out what went wrong with the variable later.  After changing the email address, go to the 'Processes' tab, find the process, go to the 'View Metrics' dropdown on that line, choose 'instances', and then click the instance that is hung up.  When you do that, and all the tasks show up, click the colon near the end of the line the task is on that is suspended.  You will see what I have below, but there should be an option near the top that says 'Retry Suspended Task' or 'Retry'.  Click that, and it should retry that email activity for you and continue on.

 

 

Rick

0 0
replied on June 19, 2018

Good Morning Rick, 

Thanks for the reply.  Unfortunately the task is still listed as "in-progress" and while it is that state and not suspended, I don't think there is a way for me to retry the task.

 

Drew

0 0
replied on March 19, 2020

Did you ever find a resolution for this issue?  I've having it on multiple instances.

0 0
replied on March 19, 2020

Actually, I did some investigating into the database and was able to figure out a work-around...  Thought I'd share it here in case it helps anyone else.

This query will show email tasks that are stuck in this state.

SELECT *
FROM [LFForms].[dbo].[cf_bp_worker_instances] AS wi
JOIN [LFForms].[dbo].[cf_bp_worker_instance_history] AS history ON wi.[instance_id] = history.[instance_id]
JOIN [LFForms].[dbo].[cf_bp_steps] AS step ON wi.[current_step_id] = step.[step_id] AND wi.[current_process_id] = step.[process_id]
WHERE wi.[status] = 3 AND history.[finish_date] IS NULL AND step.[step_sub_type] = 'email'

If these are the same email tasks you are struggling with, then these two update queries will force them into a suspended state.  Once in a suspended state, you can just re-try them from Monitor page in LFForms.

UPDATE [LFForms].[dbo].[cf_bp_worker_instance_history]
SET [status] = 'suspended'
FROM [LFForms].[dbo].[cf_bp_worker_instances] AS wi
JOIN [LFForms].[dbo].[cf_bp_worker_instance_history] AS history ON wi.[instance_id] = history.[instance_id]
JOIN [LFForms].[dbo].[cf_bp_steps] AS step ON wi.[current_step_id] = step.[step_id] AND wi.[current_process_id] = step.[process_id]
WHERE wi.[status] = 3 AND history.[finish_date] IS NULL AND step.[step_sub_type] = 'email';

UPDATE [LFForms].[dbo].[cf_bp_worker_instances]
SET [status] = 11
FROM [LFForms].[dbo].[cf_bp_worker_instances] AS wi
JOIN [LFForms].[dbo].[cf_bp_worker_instance_history] AS history ON wi.[instance_id] = history.[instance_id]
JOIN [LFForms].[dbo].[cf_bp_steps] AS step ON wi.[current_step_id] = step.[step_id] AND wi.[current_process_id] = step.[process_id]
WHERE wi.[status] = 3 AND history.[finish_date] IS NULL AND step.[step_sub_type] = 'email';
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.