My Oracle Support Banner

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

Last updated on JULY 13, 2019

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="<GUID>" REVISION="400080869230095.000" USERGUIDREF="<GUID>" TIME="9/5/2013 6:34:29 PM" SOURCEMACHINE="<GUID>"" INFORMVERSION="5.500249"><DATASTATUS xmlns="-SyncXML-Inform4" GUID="<GUID>"" REVISION="400080869230095.000" CHANGEREASON="Transcription Error" AUDITORDER="400080869230095.000" STATE="1" SET="1" ACTION=" ItemSet: Deleted" PREVIOUSAUDITORDER="399911470182095.000"><PATIENTREF GUID="<GUID>""><FORMSETREF GUID="<GUID>"" ORDER="1.000"><FORMREF GUID="<GUID>" REVISION="393444946417061.000" ORDER="1.000"><SECTIONREF GUID="<GUID>"><ITEMSETREF GUID="<GUID>" ORDER="395930786576095.000" /></SECTIONREF></FORMREF></FORMSETREF></PATIENTREF></DATASTATUS><QUERY QUERYGUID="<GUID>" REVISION="400080869230095.000" GROUPGUIDREF="<GUID>" TYPE="1" STATE="2" DATA="Initial Entry" USERGUIDREF=<GUID>" CHANGEREASON="Answer query" CONFLICTINFO="PREV:399990187998095.000;" xmlns="-SyncXML-Inform4"><PATIENTREF GUID="<GUID>"><FORMSETREF GUID=<GUID>" ORDER="1.000"><FORMREF GUID="<GUID>" REVISION="393444946417061.000" ORDER="1.000"><SECTIONREF GUID="<GUID>"><ITEMSETREF GUID="<GUID>" ORDER="395930786576095.000"><ITEMREF GUID="<GUID>" /></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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.