000037354 - RSA Archer Data Feeds go into "Terminating" status immediately after "Pending" status and "Error during GetNextJob() for a specific instance." is logged

Document created by RSA Customer Support Employee on Apr 18, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037354
Applies ToRSA Product Set: Archer
RSA Product/Service Type: RSA Archer (On-Premise)
RSA Version/Condition: 6.4, 6.5
IssueWhen a Data Feed is started manually, the Data Feed goes into "Terminating" status immediately after going into a "Pending" status.

Additionally, the following error is logged into Jobframework.Host.


<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
    <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
        <EventID>1</EventID>
        <Type>3</Type>
        <SubType Name="Error">0</SubType>
        <Level>2</Level>
        <TimeCreated SystemTime="2019-04-10T20:51:36.3215056Z" />
        <Source Name="ArcherTech.JobFramework" />
        <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" />
        <Execution ProcessName="ArcherTech.JobFramework.Host" ProcessID="7016" ThreadID="6" />
        <AssemblyVersion>6.4.10200.1028</AssemblyVersion>
        <Channel />
        <Computer>SERVER</Computer>
    </System>
    <ApplicationData>
        <TraceData>
            <DataItem>
                <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
                    <TraceIdentifier>ArcherTech.JobFramework</TraceIdentifier>
                    <Description>Error during GetNextJob() for a specific instance.</Description>
                    <AppDomain>JobHost</AppDomain>
                    <Exception>
                        <ExceptionType>ArcherTech.Kernel.Providers.Data.ArcherDbException, ArcherTech.Kernel.Providers, Version=6.4.10200.1028, Culture=neutral, PublicKeyToken=null</ExceptionType>
                        <Message>The multi-part identifier "inst.ExecutionStatus" could not be bound.
The multi-part identifier "inst.BlockingBookmarks" could not be bound.
The multi-part identifier "inst.IsReadyToRun" could not be bound.
SQL statement: [dbo].[usp_async_job_queue_get_job_dequeuing_disabled] @RETURN_VALUE = null, @numJobs = 1, @filterXml = '&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;JobFilter /&gt;'</Message>
                        <Source>ArcherTech.Kernel.Providers</Source>
                        <ContextData>
                            <Instance>Archer</Instance>
                            <FilterXml>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;JobFilter /&gt;</FilterXml>
                            <Procedure>[dbo].[usp_async_job_queue_get_job_dequeuing_disabled]</Procedure>
                        </ContextData>
                        <StackTrace>   at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.WrapDatabaseCall(DbCommand command, Action methodToWrap)
   at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.ExecuteReader(DbCommand command)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(String storedProcedureName, Object[] parameterValues)
   at ArcherTech.JobFramework.SqlServerPlugins.DistributedSqlServerJobQueueProvider.GetNextJobsForInstance(KeyValuePair`2 connection, Int32 pollSize, JobFilter filter, Boolean isDequeuingDisabled)</StackTrace>
                    </Exception>
                </TraceRecord>
            </DataItem>
        </TraceData>
    </ApplicationData>
</E2ETraceEvent>



 
CauseJob processing has been disabled in the Archer Control Panel.
Resolution
  1. Archer Control Panel -> Plugins -> Job Engine Manager -> Servers Tab
  2. Uncheck the Discontinue Job Processing checkbox
User-added image
  1. Press the update button in the bottom right
User-added image
 

Attachments

    Outcomes