I have an IWP system in FM11. User fills out a form and hits a submit button. This triggers a script to set a couple of fields in the IWP database and a main database which is behind the scenes. The field values build a 1:1 relationship between the main db and the IWP db and then another script does a series of Set Field steps to copy from IWP to main database.
We're getting an error when the "move data" script runs where the IWP user account has got the record locked and we can't grab the data. Eventually the lock clears and we can move the data via script, but it is a pain.
I've tried a few things (commit record, refresh) to get the record lock to release but haven't been able to get it to work consistently.
Anyone have any suggestions?