Unable to merge Account records - SBL-DBC-00111 (Doc ID 523404.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Assignment Manager - Version 7.5.3.4 [16180] and later
All Platforms
Product Release: V7 (Enterprise)
Version: 7.5.3.4 [16180]
Database: Microsoft SQL Server 2000
Application Server OS: Microsoft Windows 2000 Server
Database Server OS: Microsoft Windows 2000 Server

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


Symptoms

We cannot merge Account records in our Production environment. When two Accounts are selected to be merged and the user clicks the ‘Merge Records’ functionality, they are promoted to confirm that they wish to merge the two records as expected.  After some time, the following error message appears.

We detected an Error that may have occurred for one or more of the following reasons:
An error has occurred writing to a record. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)

When we try to merge two Contact records in the same way , we can successfully merge them.

In addition, when we try to merge two Accounts in our QA environment using the same SRF file, we can successfully merge them which suggests that the issue could be data related or our Production environment has some different settings than QA.

I have looked at the Application Object Manager log file generated on the server and it indicates that the process was locked by another process. The actual error in the AOM log is:

SQLError: [40001],[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms