000032024 - Problem with processing an input entity in RSA Archer 5.5 Content save actions for the corresponding source row may have failed

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032024
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5
 
IssueParallel Data Feed faults due to a database deadlock on a Values List.
The log file indicates that more than one Data Feed is attempting to update a single Values List and this causes faults for a Data Feed.
 
<ApplicationData>
  <TraceData>
    <DataItem>
      <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
        <TraceIdentifier>ArcherTech.DataFeed</TraceIdentifier>
        <Description>There was a problem processing an input entity. Content save actions for the corresponding source row may have failed.</Description>
        <AppDomain>ArcherTech.JobFramework.Job.exe</AppDomain>
        <ContextData>
          <LogReferenceId>112315-135509-3637</LogReferenceId>
          <DataFeedId>4058</DataFeedId>
          <DataFeedName>Data_Feed_Alias</DataFeedName>
          <DataFeedHistoryId>7225685</DataFeedHistoryId>
        </ContextData>
        <Exception>
          <ExceptionType>System.Transactions.TransactionAbortedException, System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
          <Message>The transaction has aborted.</Message>
          <Source>System.Transactions</Source>
          <StackTrace> at System.Transactions.TransactionStateAborted.BeginCommit(InternalTransaction tx, Boolean asyncCommit, AsyncCallback asyncCallback, Object asyncState)
at System.Transactions.CommittableTransaction.Commit()
at System.Transactions.TransactionScope.InternalDispose()
at System.Transactions.TransactionScope.Dispose()
at ArcherTech.Kernel.Brokers.ValuesListDefinitionBroker.&lt;&gt;c__DisplayClassbf.&lt;PersistValuesListValue&gt;b__b3()
at ArcherTech.Kernel.Utility.BrokerHelper.RetryOnDbDeadlock(Action methodToExecute, String instanceName, Nullable`1 userId)
at ArcherTech.Kernel.Brokers.ValuesListDefinitionBroker.PersistValuesListValue(ValuesListValueDefinition persistVlValue, ValuesListValueDisplay persistVlValueDisplay, Boolean isUpdate, ValuesListValueSaveOptions saveOptions, Boolean setSystemProperties, ValuesListValueDefinition deleteOtherTextContentVlValue, IDictionary`2 persistRelatedVlValues, Boolean setSortOrder, ValuesListDefinitionSortType sortType, TreeRoot`1 dbVlValues, Boolean doRecalc, IDictionary`2 recalcVlValues, IList`1 reindexContentIds)
at ArcherTech.Kernel.Brokers.ValuesListDefinitionBroker.SaveValueListValue(ValuesListValueContainer valueContainer, ValuesListValueSaveOptions saveOptions, Boolean needsValidation, Boolean needsPermissioning, Boolean setSystemProperties, Boolean isImport)
at ArcherTech.Kernel.Channel.ContentWriterContentQueue.CreateValuesListValue(ValuesListValueContainer item)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ContentWriterContext.RetryCommand[T](Func`1 databaseCommand, String methodName)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ContentWriterContext.CreateValuesListValue(ValuesListValueContainer item)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ValuesListDefinition.CreateValuesListValue(String currentPath, String name, Boolean selectable, Nullable`1 parentValuesListValueId)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ValuesListDefinition.CreateNewValue(String value)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ValuesListDefinition.LookupValuesListId(ContentWriterContext context, XmlEntityNavigator navigator, String fieldName, String value)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ValuesListProcessor.&lt;Process&gt;b__4(XmlEntityNavigator n, IList`1 existing)
at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.RepeatingFieldProcessor.ProcessRepeating[T,U](Content existingContent, XmlEntityNavigator entityNavigator, Boolean allowInsert, Func`3 selector, Func`2 existingConverter, Func`2 builders)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ValuesListProcessor.Process(Content existingContent, XmlEntityNavigator entityListItem)
at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.EntityContent..ctor(Nullable`1 contentId, Int32 levelId, XmlEntityNavigator navigator, IEnumerable`1 fields)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.EntityProcessor.Execute(IEnumerable`1 contentSubset, XmlEntityNavigator entityListItem)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ContentWriterContext.ProcessContent(EntityProcessor processor, XmlEntityNavigator navigator, Boolean saveContent, Boolean allowUpdate)
at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ContentWriterContext.ProcessRootContent(EntityProcessor processor, XmlEntityNavigator navigator)
at ArcherTech.DataFeed.Channel.Components.ContentWriterEnumerable.ProcessContent(EntityListItem item)</StackTrace>
          <InnerException>
            <ExceptionType>System.TimeoutException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
            <Message>Transaction Timeout</Message>
            <Source />
            <StackTrace />
          </InnerException>
        </Exception>
      </TraceRecord>
    </DataItem>
  </TraceData>
</ApplicationData>
ResolutionDo not run Data Feeds that attempt to update the same Values List at the same time.

Attachments

    Outcomes