Not able to update database values using the Database Update Tool!!!
Confluence User - 14 Jul, 2022
I have designed a process with a simple rules decision and a Database update tool. The Rules decision will run a simple rule to compare the values of two variables and set the priority values as High or Low respectively. Following this the DB Update tool will set the current value of the Priority Workflow Variable to the DB Column.
After the process is executed though the workflow variables are getting the correct values (verified in monitoring section) the DB Update tool is not setting the value in the database.
Process Diagram:
My Query:
c_priority is the column which needs to be modified and c_TMSRefID is the unique id column to refer to the correct row
process;database;tools