000033180 - RSA Archer Data Publication Job failing due to timeout

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 30, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033180
Applies ToRSA Product Set: RSA Archer
RSA Product/Service Type: RSA Archer
RSA Version/Condition: Any
Platform: Windows
 
IssueWhen running a Data Publication targeting a SQL server, one table fails due to a timeout.
CauseA long running SQL stored procedure.  

The following exception is from the JobFramework log file.

<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
  <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
    <SubType Name="Error">0</SubType>
    <Source Name="ArcherTech.DataPublication" />
    <Execution ProcessName="ArcherTech.JobFramework.Job" ProcessID="2296" ThreadID="1" />
    <Computer>XXXXXXXXXX</Computer>
  </System>
  <ApplicationData>
    <TraceData>
      <DataItem>
        <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
          <TraceIdentifier>ArcherTech.DataPublication</TraceIdentifier>
          <LogReferenceId>042916-165524-3269</LogReferenceId>
          <Description>Data Publication Job 'XXXXXXXXX' failed at 4/29/2016 4:55:24 PM</Description>
          <AppDomain>ArcherTech.JobFramework.Job.exe</AppDomain>
          <ContextData>
            <GroupJobId>{f3302e27-5fab-48c7-b9f2-cedf25b0ee3e}</GroupJobId>
            <PublicationId>1</PublicationId>
            <PublicationHistoryId>85</PublicationHistoryId>
            <ParentJobId>{a5c05553-4d35-4f2b-af8f-6c771caec933}</ParentJobId>
            <PublicationName>XXXXXXXXX</PublicationName>
            <SolutionId>52</SolutionId>
            <SolutionName>XXXXXXXX</SolutionName>
          </ContextData>
          <Exception>
            <ExceptionType>System.ArgumentNullException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
            <Message>Value cannot be null.
Parameter name: source</Message>
            <Source>System.Core</Source>
            <StackTrace> at System.Linq.Enumerable.SelectMany[TSource,TResult](IEnumerable`1 source, Func`2 selector)
at ArcherTech.DataPublication.PublishContentIds.Publish(IList`1 previousMetadata, IList`1 currentMetadata)
at ArcherTech.DataPublication.PrepareTargetDatabase.Execute(Int32 dataPublicationId, ActivityExecutionContext executionContext, Guid workflowInstanceId)</StackTrace>
          </Exception>
        </TraceRecord>
      </DataItem>
    </TraceData>
  </ApplicationData>
</E2ETraceEvent>


 
WorkaroundFrom SQL Server Management Studio, run the following command against the Instance database:

sp_recompile 'usp_get_object_content_text'

Attachments

    Outcomes