CIS 4.5/4.6 - "CANNOT_DELETE_ALREADY_DELETED_RECORD" error (Doc ID 1583854.1)

Last updated on JULY 24, 2014

Applies to:

Oracle Health Sciences CIS - Version 4.5.1.2 and later
Information in this document applies to any platform.

Symptoms

 During CIS 4.5/4.6 synchronization via CentralAdmin, the error "CANNOT_DELETE_ALREADY_DELETED_RECORD" appears, for example:

 Sync connection has faulted.

There was a problem trying to process a previously faulted transaction.  The transaction may have been edited through the CIS Administration
There was a problem trying to send(put) transactions to the Clintrial Adapter.
System.Web.Services.Protocols.SoapException: [CANNOT_DELETE_ALREADY_DELETED_RECORD] Unable to delete already-deleted record from Panel  
  <PANEL NAME>
Protocol: <PROTOCOL NAME>

XML Content:
<TRANSACTION xmlns="<COMPANYNAME>-SyncXML-Inform4" GUID="{E7415FB0-514A-477C-8E16-99ACE280A250}" REVISION="400080869230095.000" USERGUIDREF="{1856D0B8-D858-4A31-988E-459623436B0C}" TIME="9/5/2013 6:34:29 PM" SOURCEMACHINE="{B712FD55-016D-462A-B64B-FFA8BFD5E2D3}" INFORMVERSION="5.500249"><DATASTATUS xmlns="-SyncXML-Inform4" GUID="{8BD45521-1F5D-476B-BCCD-D8EAD45D485A}" REVISION="400080869230095.000" CHANGEREASON="Transcription Error" AUDITORDER="400080869230095.000" STATE="1" SET="1" ACTION=" ItemSet: Deleted" PREVIOUSAUDITORDER="399911470182095.000"><PATIENTREF GUID="{ED3C76EE-0B3E-45A4-90B7-C2952DD92F4F}"><FORMSETREF GUID="{15520EAD-90F0-431A-8216-E02300297974}" ORDER="1.000"><FORMREF GUID="{2B03700E-A71C-42DD-A159-F8872789A366}" REVISION="393444946417061.000" ORDER="1.000"><SECTIONREF GUID="{75D67A5C-404E-4C1B-9AB6-00EA93DB83F1}"><ITEMSETREF GUID="{B868A82C-49FC-4683-89E6-A558B5449195}" ORDER="395930786576095.000" /></SECTIONREF></FORMREF></FORMSETREF></PATIENTREF></DATASTATUS><QUERY QUERYGUID="{A8E8E537-E23B-401B-9A82-04E0E8D55200}" REVISION="400080869230095.000" GROUPGUIDREF="{2EC28266-CCD5-4333-9F0C-9CE90F27912A}" TYPE="1" STATE="2" DATA="Initial Entry" USERGUIDREF="{2A69283B-5D48-4D73-BC67-B0524FB996FC}" CHANGEREASON="Answer query" CONFLICTINFO="PREV:399990187998095.000;" xmlns="-SyncXML-Inform4"><PATIENTREF GUID="{ED3C76EE-0B3E-45A4-90B7-C2952DD92F4F}"><FORMSETREF GUID="{15520EAD-90F0-431A-8216-E02300297974}" ORDER="1.000"><FORMREF GUID="{2B03700E-A71C-42DD-A159-F8872789A366}" REVISION="393444946417061.000" ORDER="1.000"><SECTIONREF GUID="{75D67A5C-404E-4C1B-9AB6-00EA93DB83F1}"><ITEMSETREF GUID="{B868A82C-49FC-4683-89E6-A558B5449195}" ORDER="395930786576095.000"><ITEMREF GUID="{68A45413-ACCE-413B-9BE6-A705A02C50FC}" /></ITEMSETREF></SECTIONREF></FORMREF></FORMSETREF></PATIENTREF></QUERY></TRANSACTION> ---> [CANNOT_DELETE_ALREADY_DELETED_RECORD] Unable to delete already-deleted record from Panel  
 <PANEL NAME>
Protocol: <PROTOCOL NAME>

XML Content:
<TRANSACTION ....></TRANSACTION>

A similar error could also occur if <FORMSTATUS> appears in the transaction xml.

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