SBL-DAT-00494: The selected record has been deleted by another user since it was retrieved.

Applies to:

Siebel eCommunications - Version: 8.0.0.3 [20416] - Release: V8

Information in this document applies to any platform.

Symptoms

error SBL-DAT-00494 randomly occurs during task transaction. Task calls Data Validation Manager (DVM) for validation of a Transient Business Component (TBC). The error occurs depending on runtime differences. 

Cause

The error was determined to be caused by a commit step in the sub task. After removing the commit step from the sub task and placing it into the parent task the error did not anymore occur.

Solution

Documentation defect CR#12-1U0AWYV was opened to provide more details about the commit steps. What they exactly do and best practices to use them.

Applies to:

Siebel Tools - Version: 8.1.1 [21112] - Release: V8

Information in this document applies to any platform.

Symptoms

A copy of "Internal Product - ISS Admin" business component is being used to add a new organization to the product via COM Data Control but it fails with the following error on the "Associate" method:

"The selected record has been deleted by another user since it was retrieved. Please continue.(SBL-DAT-00494)"

Cause

It is found that the cause of this is due to the "Organization" multi-valued link (MVL) in the copied "Internal Product - ISS Admin" business component. This MVL is using "Internal Product - ISS Admin/Internal Division" link.

Solution

Creating a new link between the copied "Internal Product - ISS Admin" business component and "Internal Division" business component and use it in the "Organization" MVL for the copied "Internal Product - ISS Admin" business component resolves the error.

Applies to:

Siebel CRM - Version: 8.1.1.1 SIA [21211] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Symptoms

Siebel Version: 8.1.1. 1 SIA

Statement Of Issue: When updating same Activity record in two different sessions, throwing unexpected error.

Steps to Reproduce:
1. Go to application1 create a activity under service request screen with Type,Sub type and status fields filled and save the record and leave other fields blank.
2. Go to application 2 and query for service request to which activity has been added and select activity record added in application1
3. Enter values for remaining fields and save the record.
4. Now goto application1 and don't refresh activity applet enter the values for left out fields and save the record.

Error Thrown:
"The selected record has been deleted by another user since it was retrieved. Please continue.(SBL-DAT-00494)"
SBL-DBC-00111: An error has occurred writing to a record. Please continue or ask your systems administrator to check your application configuration if the problem persists.
The target name PAR_ROW_ID is specified more than once for an assignment in the same SQL statement

Business Impact: Misleading the users with errors.

Cause

The error is occurring as two records with same PAR_ROW_ID are getting inserted into S_EVT_ACT_X table from different sessions.


When creating the record, no fields based on S_EVT_ACT_X are filled. So when in another session any field based on extension table is updated, new record is created in S_EVT_ACT_X. At the same time if this user updates any field based on extension table, it will also tries to create new record because of which uniqueness error is occurring.

Solution

Set required field on any field based on S_EVT_ACT_X table.
This will ensure that while creating the record itself record is created in Intersection table.

1. Make any field in Action BC to be required which is fetched from S_EVT_ACT_X.
2. Compile the Action BC
3. Retest the issue.

Applies to:

Product Release: V7 (Professional)
Version: 7.8.2.4 [19224]
Database: Oracle 10.1.0.5
Application Server OS: HP-UX 11.11
Database Server OS: HP-UX 11.11

This document was previously published as Siebel SR 38-3365842991.

Symptoms

While trying to add members in the Loyalty Members screen and pressing Ctrl+S to save the record I get an error "The selected record has been deleted by another user since it was retrieved. Please continue(SBL-DAT-00494)".However when I go to the Loyalty Program Administration -- Members View I am able to see the member added just now.Now if I click on the member name hyperlink to go back again to the Loyalty Members screen I get the following error
"An error has occurred finding your prior place in the system.The record no longer exists or is not available to the view."This behaviour is reported in Vanilla Loyalty Application .I need some resolution urgently to this problem so that I may be able to give a prototype of Siebel Loyalty to the clients.
Thanks,

Solution

Message 1

For the benefit of others:

SUMMARY:

When creating a new loyalty member under Loyalty Program Administration screen > Programs > Members view the customer was getting the following error:
"The selected record has been deleted by another user since it was retrieved. Please continue(SBL-DAT-00494)"

However the member was visible in the view, but when drilling down on the record the following error was shown:
"We detected an Error which may have occurred for one or more of the following reasons:
An error has occurred finding your prior place in the system. The record no longer exists or is not available to the view. Please try a new query.(SBL-DAT-00223)"


RESOLUTION:
After some investigation it was found that there was no tier defined for the loyalty program. After creating and activating a default tier the problem was solved.

Kind regards,

Oracle | Siebel Technical Support

Keywords: loyalty member, create and loyalty member, SBL-DAT-00223, SBL-DAT-00494