X

Peeyush Tugnawat's Blog

  • January 27, 2009

Siebel Record Locking with Web Services

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

Join the discussion

Comments ( 2 )
  • nagarjuna Wednesday, January 28, 2009
    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.
  • Peeyush Tugnawat Friday, January 30, 2009
    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.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.