Unable to merge Account records - SBL-DBC-00111
(Doc ID 523404.1)
Last updated on SEPTEMBER 04, 2018
Applies to:Siebel Assignment Manager - Version 22.214.171.124  and later
Product Release: V7 (Enterprise)
Version: 126.96.36.199 
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!