Deadlock Errors When Using Sybase
(Doc ID 450041.1)
Last updated on MAY 22, 2020
Applies to:
Oracle WebCenter Content - Version 7.0 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |