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

Question

Question

Workflow Warning/Error locations

Workflow
Updated October 22, 2018
asked on October 18, 2018

We have large conversion workflows that run.  At the end of a workflow we get a warning but the Processing activity message screen (or any of the history) never seems to load.  It just sits near the end of any of the workflows.

 

Is there a spot in the Workflow tables in SQL where I can look to figure out what the error message is?

I have checked the error log in the Workflow Admin Console and cannot seem to correlate anything there to the workflow I want to look at.

 

Thanks,

Chris

1 0

Answer

SELECTED ANSWER
replied on October 19, 2018

If the instance is complete (with warnings or terminated with an error), you can look in the search_error_log table using the query below (you can get the instance ID from the search results in the Designer:

select * from search_error_log
where search_id in 
(select search_id 
	from search_instance_log 
	where instance_id = 'INSTANCE ID GOES HERE')

If the workflow is still running, then the same query works, but against the search_error and search_instance tables instead.

If the workflow terminated with errors, the errors would also be available in the activity errors.log in the WF Admin Console. Depending on when they occurred, the log may have rolled over, so you may have to check a couple of the older logs. The date range each log covers is in their name.

0 0

Replies

replied on October 18, 2018

Did this instance complete with warnings or terminate with an error? (it's unlikely it will finish loading since it's trying to list 1.5 million activities)

0 0
replied on October 19, 2018

Yes, it completed.  I know its a lot and don't really expect all of it I'd just like to see what the warning message was.  Figure that might be in a table somewhere.  I took a chance and kicked off the workflow again and the error happened pretty quick and was able to see it.

0 0
SELECTED ANSWER
replied on October 19, 2018

If the instance is complete (with warnings or terminated with an error), you can look in the search_error_log table using the query below (you can get the instance ID from the search results in the Designer:

select * from search_error_log
where search_id in 
(select search_id 
	from search_instance_log 
	where instance_id = 'INSTANCE ID GOES HERE')

If the workflow is still running, then the same query works, but against the search_error and search_instance tables instead.

If the workflow terminated with errors, the errors would also be available in the activity errors.log in the WF Admin Console. Depending on when they occurred, the log may have rolled over, so you may have to check a couple of the older logs. The date range each log covers is in their name.

0 0
replied on October 22, 2018

Great, thanks Miruna

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

Sign in to reply to this post.

Details
Related Posts
Loading ...