Hi All,
I'm facing the following issue in write to DB node. Please find the screenshot below.
Extra info - I'm using stored procedure calls before the write to DB node but they don't have anything to do with the table I'm trying to update.
Discussion posts and replies are publicly visible
I have never seen this in Appian, but I have in JAVA apps and since Appian is a J2EE based app... maybe this might help....Is it possible that your stored proc has not competed or errored and is keeping the buffer open - hence using the thread that the insert is trying to use. Try removing your stored proc and see if you get the same issue.
Yes as mentioned by Christine please remove the stored proc call and see if see the issue persists.You might need to close the if any connection open either by restarting the process first if the issue didn't solve restart the servers
UPDATE: I added a timer event to give MYSQL time to remove the lock and close the transactions from stored procedure calls and the write to database node worked. This looks like a workaround but I'll go with this for the time being as this is a scheduled job and not an end-user action, timer would be ok
it's the only solution I could think of.
Removing the SP calls worked but I need those to be in the process model as it converts data from Stored proc results to CSV files.
Thank you for the help ! ChristineH & RajHasti