Unable to merge Account records - SBL-DBC-00111
Last updated on MARCH 02, 2017
Applies to:Siebel Assignment Manager - Version 184.108.40.206  and later
Product Release: V7 (Enterprise)
Version: 220.127.116.11 
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.
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: ,[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.
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