Error: "The selected record has been modified by another user since it was retrieved"
Reason: The reason we were getting this error in our case was because of the custom scripts. Execution of custom scripts on the Business Components was slowing down the WriteRecord process. This was resulting in the record locking issue.
One way to know if custom scripts are causing this error is to disable all custom scripts (if any) and then try to run the web service to check if you still run into the same error. If yes, following references might help.
Related References:
Troubleshooting Workflow Process Execution Problems
http://download.oracle.com/docs/cd/B40099_02/books/BPFWorkflow/BPFWorkflow_Admin20.html
Defining an Error Exception to Handle an Update Conflict
http://download.oracle.com/docs/cd/B40099_02/books/BPFWorkflow/BPFWorkflow_Design22.html#wp1223641
Comments (2)
Hi,
Are you using custom scripts in your Web services, if it is then there could be the problem
When you are initiating the BCs you need to use the current UI context. For example
You are in contact BC and you need to initiate in the following way.
bc = this.BusObject().GetBusComp(“Contact”);
instead of non ui context as below.
bo = TheApplication.GetBusObject(“Contact”);
bc = bo.GetBusComp(“Contact”);
Please let me know if this helped you.
Posted by nagarjuna | January 28, 2009 4:55 AM
Posted on January 28, 2009 04:55
Nagarjuna,
Custom scripts was the main reason for the error in our case which was couple of months back. I just wanted to post it out there so people can benefit from it. I updated the post with the possible reason.
Thanks for your example. I hope this will be helpful for other folks running into similar issues.
Posted by Peeyush Tugnawat | January 30, 2009 10:54 AM
Posted on January 30, 2009 10:54