Issue | In this scenario, the issue can be discovered when trying to implement and run a data feed to create records into an application. The data feed will error out and you will get an error in the Archer JobFramework logs that shows:
<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent"> <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system"> <EventID>3</EventID> <Type>3</Type> <SubType Name="Critical">0</SubType> <Level>1</Level> <TimeCreated SystemTime="2019-07-27T13:19:56.0085154Z" /> <Source Name="ArcherTech.DataFeed" /> <Correlation ActivityID="{f7d2f37c-9724-4c10-ad92-58d9afbbdbcb}" /> <Execution ProcessName="ArcherTech.JobFramework.Job" ProcessID="20276" ThreadID="1" /> <AssemblyVersion>6.4.200.1032</AssemblyVersion> <Channel /> <Computer>XXXXXXXXXXXXXX</Computer> </System> <ApplicationData> <TraceData> <DataItem> <TraceRecord Severity="Critical" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord"> <TraceIdentifier>ArcherTech.DataFeed</TraceIdentifier> <Description>An error occurred calling database. Retrying process: SaveContent</Description> <AppDomain>ArcherTech.JobFramework.Job.exe</AppDomain> <ContextData> <WaitTime>5000</WaitTime> <RetryAttempts>1</RetryAttempts> <LogReferenceId>072719-131956-0085</LogReferenceId> <DataFeedId>11126</DataFeedId> <DataFeedName>XXX_DATAFEED_#</DataFeedName> <DataFeedHistoryId>3605403</DataFeedHistoryId> </ContextData> <Exception> <ExceptionType>ArcherTech.Kernel.Providers.Data.ArcherDbException, ArcherTech.Kernel.Providers, Version=6.4.200.1032, Culture=neutral, PublicKeyToken=null</ExceptionType> <Message>Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. SQL statement: usp_update_content @userToken = 'EAAB87D220B840F3F2D2136618EE4202', @contentXml = '<ROOT><V a="1020446" /><V a="1944895" /><V a="2030538" /><V a="2355439" /><V a="1021421" /><V a="1021541" /><V a="1021543" /><V a="1020445" /><V a="3158490" /></ROOT>', @mainContentId = , @auditRecord = False, @updateDate = '7/27/2019 1:13:55 PM'</Message> <Source>ArcherTech.Kernel.Providers</Source> <StackTrace> at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.WrapDatabaseCall(DbCommand command, Action methodToWrap) at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.ExecuteReader(DbCommand command) at ArcherTech.Kernel.DataSource.Db.DataSourceBase.PopulateIdPair[TKey,TValue](DbCommand command, MapIdPair`2 mapIdPairDelegate) at ArcherTech.Kernel.DataSource.Db.ContentDataSource.Update(IEnumerable`1 contentIds, Nullable`1 mainContentId, Boolean auditRecord) at ArcherTech.Kernel.Brokers.UpdateRelatedContentRecordTask.Execute(ContentContext contentContext) at ArcherTech.Kernel.Brokers.TaskExecutionHelper.ExecuteTasks[T](T contentContext, IList`1 tasks) at ArcherTech.Kernel.Brokers.TransactionalTask`1.ExecuteTransaction(T contentContext) at ArcherTech.Kernel.Brokers.TransactionalTask`1.Execute(T contentContext) at ArcherTech.Kernel.Brokers.TaskExecutionHelper.ExecuteTasks[T](T contentContext, IList`1 tasks) at ArcherTech.Kernel.Brokers.RollbackUnsuccessfulContentInsertTask.Execute(ContentContext contentContext) at ArcherTech.Kernel.Brokers.TaskExecutionHelper.ExecuteTasks[T](T contentContext, IList`1 tasks) at ArcherTech.Kernel.Brokers.IndexedContentIteratorTask`1.ExecuteNonthreadedIterator(T contentContext, IList`1 indexedContentContexts) 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.DataFeed.Channel.Components.ContentProcessors.ContentWriterContext.<>c__DisplayClass57_0.<SaveContent>b__4() at ArcherTech.DataFeed.Channel.Components.ContentProcessors.ContentWriterContext.RetryCommand[T](Func`1 databaseCommand, String methodName)</StackTrace> <InnerException> <ExceptionType>System.ComponentModel.Win32Exception, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> <Message>The wait operation timed out</Message> <Source /> <StackTrace /> </InnerException> </Exception> </TraceRecord> </DataItem> </TraceData> </ApplicationData> </E2ETraceEvent>
Next, when attempting to save a record manually in the application, it will spin for a while and eventually time out. The w3wp logs will show:
<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent"> <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system"> <EventID>0</EventID> <Type>3</Type> <SubType Name="Error">0</SubType> <Level>2</Level> <TimeCreated SystemTime="2019-07-30T13:21:32.2237125Z" /> <Source Name="Archer.Web" /> <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" /> <Execution ProcessName="w3wp" ProcessID="7504" ThreadID="39" /> <AssemblyVersion>6.4.200.1032</AssemblyVersion> <Channel /> <Computer>XXXXXXXXXXXXXX</Computer> </System> <ApplicationData> <TraceData> <DataItem> <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord"> <TraceIdentifier>Archer.Web</TraceIdentifier> <LogReferenceId>073019-132132-2237</LogReferenceId> <Description>Request timed out.</Description> <AppDomain>/LM/W3SVC/1/ROOT/RSAarcher-1-132089573672156961</AppDomain> <ContextData> <BaseUrl>https://XXXXXXXXX.XXXX.XXX/RSAarcher/GenericContent/Record.aspx</BaseUrl> <id>0</id> <Module>ModuleId: 84, ModuleName: Contacts, ModuleStatus: ActiveInProduction, ModuleType: Application</Module> <frameWidthHeight>1366,598</frameWidthHeight> </ContextData> <Exception> <ExceptionType>System.Web.HttpException, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</ExceptionType> <Message>Request timed out.</Message> <Source /> <StackTrace /> </Exception> </TraceRecord> </DataItem> </TraceData> </ApplicationData> </E2ETraceEvent>
|