We have a process model that inserts records into a table and then we call a stored procedure that will execute and perform an update action on the newly inserted records while running it the process model is executing successfully and records are getting inserted but it seems the execute stored procedure node is not executing. also, the node is not giving any errors, yet it is taking some time to process but the update is not done. Can anyone help on what might be the probable reason? Is it going out of scope?
Screenshot of the PM where the node has been added:
Discussion posts and replies are publicly visible
You can check the log files to see if there was some error. If not, you should inset the data from the process and then run the SP on the database directly to understand if it is the SP or the Process Model that is causing this issue.
With this, you should have some clarity on what you need to debug.
After Running Sp it's connected back to Write records. It's either Overriding or Sync related