000036064 - RSA Archer users are unable to delete content that has references to content in an unlicensed application

Document created by RSA Customer Support Employee on Mar 1, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036064
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.2.0.6.1
IssueArcher users are unable to delete content that has references to content in an unlicensed application.

The following symptoms are observed:
  1. The Bulk Delete job fails with a foreign key constraint error.
  2. The delete button on the record takes you back to the search results and does not delete the record.
  3. The delete from search results page incorrectly indicates the records were deleted but they are not.

Log entry from the delete job triggered from the Application Builder page for the application/questionnaire.

<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
  <ApplicationData>
    <TraceData>
      <DataItem>
        <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
          <TraceIdentifier>Archer.Kernel</TraceIdentifier>
          <UserId>USERID</UserId>
          <Description>The DELETE statement conflicted with the REFERENCE constraint "FK_tblIVModuleContent_tblIVContent_2". The conflict occurred in database "DATABASE_NAME", table "dbo.tblIVModuleContent", column 'record_id'.
The statement has been terminated.
SQL statement: usp_delete_level_content @userToken = 'C8025C77894E81E6007DA71C8D16B4C6', @levelId = 17</Description>
          <AppDomain>ArcherTech.JobFramework.Job.exe</AppDomain>
          <Exception>
            <ExceptionType>ArcherTech.Kernel.Utility.Data.ArcherDbException, ArcherTech.Kernel, Version=6.2.601.1000, Culture=neutral, PublicKeyToken=null</ExceptionType>
            <Message>The DELETE statement conflicted with the REFERENCE constraint "FK_tblIVModuleContent_tblIVContent_2". The conflict occurred in database "DATABASE_NAME", table "dbo.tblIVModuleContent", column 'record_id'.
The statement has been terminated.
SQL statement: usp_delete_level_content @userToken = 'C8025C77894E81E6007DA71C8D16B4C6', @levelId = 17</Message>
            <Source>ArcherTech.Kernel</Source>
            <StackTrace>   at ArcherTech.Kernel.Utility.Data.ArcherSqlDatabase.WrapDatabaseCall(DbCommand command, Action methodToWrap)
   at ArcherTech.Kernel.Utility.Data.ArcherSqlDatabase.ExecuteScalar(DbCommand command)
   at ArcherTech.Kernel.DataSource.Db.ContentDataSource.DeleteLevelContent(Int32 levelId)
   at ArcherTech.Kernel.Brokers.ContentBroker.DeleteLevelContent(Int32 levelId, Boolean checkLevelPermissions)
   at ArcherTech.Kernel.Activities.DeleteLevelContentActivity.Execute(ActivityExecutionContext executionContext)
   at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
   at System.Workflow.Runtime.Scheduler.Run()</StackTrace>
          </Exception>
        </TraceRecord>
      </DataItem>
    </TraceData>
  </ApplicationData>
</E2ETraceEvent>


 
CauseIt is not possible to delete content records through the Archer user interface if those content records have cross-references or related records relationships to content records in an application that is no longer licensed.
ResolutionThis defect will be fixed in a later release.
WorkaroundThe content can be deleted through the Archer API.
  • Complete a full database backup of the Archer instance
  • Use the Archer API to delete the records.
You may write your own application or you may use the Archer Bulk Deleter tool available on the Archer community.
https://community.rsa.com/docs/DOC-57887


 

Attachments

    Outcomes