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

Question

Question

Workflow Not Applying Token Values

asked on February 4, 2016 Show version history

I have a workflow that does a database query and validates the value of a status in that database before it moves onto the next step. Today we noticed that all of the instances as of about a week ago are in an active state. I added a track token activity to the workflow and submitted a new form so we could see what values the workflow is retrieving. All of the values are blank. If I go into the workflow itself and test the query, it comes back successful. Does anyone have any ideas on how to troubleshoot why the workflow instance is not retrieving the values from the database?

One interesting thing to note is that the same workflow also inserts data into the same database without an issue, using the same data source.

1 0

Replies

replied on February 4, 2016

Use ODBC tracing  or SQL Profiler to see the query that is being sent to SQL Server.

0 0
replied on February 4, 2016

Figured out. Someone altered the workflow and set the wrong ID to look at.

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

Sign in to reply to this post.