Deadlock Errors When Using Sybase (Doc ID 450041.1)

Last updated on AUGUST 30, 2017

Applies to:

Oracle WebCenter Content - Version: 6.2.0 to 6.2.0 - Release: Stellent to Stellent
Information in this document applies to any platform.
Product: Content Server
Version: 6.2

Symptoms

I'm using archiver to import an archive from our production 6.2 server to the new production 7.5 server.  I encountered the following error message :

Import error for archive 'test' in collection 'stellent': Unable to execute service IMPORT_ARCHIVE and function Urevision2.
(System Error: Unable to execute query 'Urevision2(UPDATE Revisions SET dDocType='Memo', dDocTitle='testtitle', dDocAuthor='sysadmin', dCreateDate={ts '2000-06-02 15:00:00'}, dInDate={ts '2000-01-19 00:00:00'},
dOutDate=null, dRevLabel='1', dReleaseState='U', dDocAccount='', dSecurityGroup='Public',
dStatus='GENWWW', dIndexerState = ' ', dPublishType='' WHERE dID=12345)'. Your server command (family id #0, process id #269) encountered a deadlock situation. Please re-run your command.) [ Details <javascript:if(typeof show!='undefined')show('0.30889137450915827')> ]
An
error has occurred. The stack trace below shows more information.
!csImportErrorForArchiveInCollection,stellent,test77!$!csServiceDataException,IMPORT_ARCHIVE,Urevision2!$!csSystemError,\!csDbUnableToExecuteQuery\,Urevision2(UPDATE
Revisions SET dDocType='Memo'\\\, dDocTitle='testtitle'\\\, dDocAuthor='sysadmin'\\\, dCreateDate={ts
'2000-06-02 15:00:00'}\\\, dInDate={ts '2000-01-19 00:00:00'}\\\,
<br> dOutDate=null\\\, dRevLabel='1'\\\, dReleaseState='U'\\\,
dDocAccount=''\\\, dSecurityGroup='Final'\\\,
<br> dStatus='GENWWW'\\\, dIndexerState = ' '\\\, dPublishType=''
WHERE dID=12345)\!$Your server command (family id #0\\\, process id
#269) encountered a deadlock situation. Please re-run your command.

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