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
ShaliniD said:yet it is taking some time to process but the update is not done.
What are you trying to say?? Correct me if i'm wrong Process completing without errors(Store procedure Node execution, is it happening?) ,But Values are not getting updated??
Yes, the node is executing but values are not updated. Yet when we are creating a separate PM and just executing the Stored Procedure everything is happening properly the way it should execute
Execute Store procedure requires External sync . Why is there Write records After Execute Store procedure? Are you trying to save back updated values and writing them using Write records(Output from store procedure is Anytype ,No cating errors?)?? is there a particular reason behind it? Can't you directly use Sync records??