000033180 - Data Publication Timing Out in RSA Archer 5.x

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 Number000033180
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.x
Platform: Windows
 
IssueWhen running a Data Publication to 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 Management Studio, run the following command against the Instance database:
sp_recompile 'usp_get_object_content_text'

Attachments

    Outcomes