Questionnaire Campaign Fails with 'Sequence Contains No Elements' Error in Archer

[KB-Sync1]

Article Number

000036592

Applies To

Product(s): Archer
Version(s): All Versions
Primary Deployment: On Premises/AWS Hosted/AWS SaaS

---

Description

A manual Questionnaire Campaign fails with the below error message in the ArcherTech.JobFramework.Job logs:

<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="2024-05-28T15:50:22.5448033Z" />
        <Source Name="ArcherTech.JobFramework" />
        <Correlation ActivityID="{39017285-e1ec-4111-b691-c9c2e73a8e6b}" />
        <Execution ProcessName="ArcherTech.JobFramework.Job" ProcessID="6068" ThreadID="1" />
        <AssemblyVersion>1.1.57.0</AssemblyVersion>
        <Channel />
        <Computer>SERVERNAME</Computer>
    </System>
    <ApplicationData>
        <TraceData>
            <DataItem>
                <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
                    <TraceIdentifier>ArcherTech.JobFramework</TraceIdentifier>
                    <Description>Sequence contains no elements</Description>
                    <AppDomain>ArcherTech.JobFramework.Job.exe</AppDomain>
                    <Exception>
                        <ExceptionType>System.InvalidOperationException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
                        <Message>Sequence contains no elements</Message>
                        <Source>System.Core</Source>
                        <StackTrace>   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
   at ArcherTech.Kernel.Brokers.SetTargetContentIdTask.Execute(ContentContext contentContext)
   at ArcherTech.Kernel.Brokers.TaskExecutionHelper.ExecuteTasks[T](T contentContext, IList`1 tasks)
   at ArcherTech.Kernel.Brokers.ContentBroker.ExecuteContentSavePlan(ContentContext contentContext, IDictionary`2 indexMap, ContentSavePerformanceData performanceData, BatchContentSaveResult returnResults)
   at ArcherTech.Kernel.Brokers.ContentBroker.Save(IList`1 contentContainers, Nullable`1 subformFieldId, ContentSaveOptions saveOptions)
   at ArcherTech.Kernel.Jobs.CampaignGenerationHelper.SaveContents(ExtendedSessionContext extendedSessionContext, IList`1 contentsToSave, QuestionnaireCampaign campaign)
   at ArcherTech.Kernel.Jobs.ManualCampaignGenerationJobHandler.SaveQuestionnaireContents_ExecuteCode(Object sender, EventArgs e)
   at System.Workflow.ComponentModel.Activity.RaiseEvent(DependencyProperty dependencyEvent, Object sender, EventArgs e)
   at System.Workflow.Activities.CodeActivity.Execute(ActivityExecutionContext executionContext)
   at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
   at System.Workflow.Runtime.Scheduler.Run()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at ArcherTech.Kernel.Jobs.ManualCampaignGenerationJobHandler.handleJobFailedActivity_ExecuteCode(Object sender, EventArgs e)
   at System.Workflow.ComponentModel.Activity.RaiseEvent(DependencyProperty dependencyEvent, Object sender, EventArgs e)
   at System.Workflow.Activities.CodeActivity.Execute(ActivityExecutionContext executionContext)
   at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
   at System.Workflow.Runtime.Scheduler.Run()</StackTrace>
                    </Exception>
                </TraceRecord>
            </DataItem>
        </TraceData>
    </ApplicationData>
</E2ETraceEvent>

Cause

When the Questionnaire's Target field is inactive, the job that processes the Campaigns cannot create the Questionnaire records.
Also, the Questionnaire's Target field may have been renamed.

Resolution

Follow the steps below:

1. Navigate to the Application Builder and open the Questionnaire.
2. Identify the Cross-Reference field that is used as the Target field for the Questionnaire.
Note: The Cross-Reference field will be locked.
3. Set the Cross-Reference field to active under the Field Properties.
4. Save the field.
5. Re-run the Campaign.