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.