Ask Your Question

Revision history [back]

Downloading History resource for RE_1 is failing with server error

URL:http://mlsbox.rets.paragonrels.com/rets/fnisrets.aspx/MLSBOX/login?rets-version=rets/1.7.2 Account:iCheck

When downloading History Resource, all classes work as expected except for RE_1.

we do this download daily for years. No recent changes to our query.

<resource>History</resource> <class>RE_1</class> <dmql_query>(L_UpdateDate=2020-04-11T00:00:00Z+)|(L_Last_Photo_updt=2020-04-11T00:00:00Z+)</dmql_query>

Rets SERVER error <rets-status replycode="20203" replytext="Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. - BLToolkit.Data.DataException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---&gt; System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---&gt; System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action&lt;code&gt;1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp;amp; dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp;amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource&lt;/code&gt;1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at BLToolkit.Data.DbManager.&lt;&gt;c__DisplayClass99_0.&lt;ExecuteReaderInternal&gt;b__0() at BLToolkit.Data.DbManager.ExecuteOperation&lt;a href=" operationtype="" operationtype,="" func<code="">1 operation) --- End of inner exception stack trace --- at BLToolkit.Data.DbManager.OnOperationException(OperationType op, DataException ex) at BLToolkit.Data.DbManager.HandleOperationException(OperationType op, Exception ex) at BLToolkit.Data.DbManager.ExecuteOperation[T](OperationType operationType, Func1 operation">T at BLToolkit.Data.DbManager.BLToolkit.Data.Linq.IDataContext.ExecuteReader(Object query) at BLToolkit.Data.Linq.Query1.&lt;RunQuery&gt;d__25.MoveNext() at BLToolkit.Data.Linq.Query1.<Map>d__46.MoveNext() at System.Linq.Lookup2.Create[TSource](IEnumerable1 source, Func2 keySelector, Func2 elementSelector, IEqualityComparer1 comparer) at System.Linq.GroupedEnumerable3.GetEnumerator() at System.Linq.Enumerable.ToDictionaryTSource,TKey,TElement at FNISDex.Items.RetsHistoryRemarksLookup.NewBatch(IEnumerable1 keys) in D:\work\167\s\Tags\5.76\Business\FNISDex\Items\RetsHistoryRemarksLookup.cs:line 30 at FNISDex.Items.DynamicBatchingLookup2.TryRefresh() in D:\work\167\s\Tags\5.76\Business\FNISDex\Items\DynamicBatchingLookup.cs:line 52 at FNISDex.Items.DynamicBatchingLookup2.TryGet(TKey key, TResult&amp; result) in D:\work\167\s\Tags\5.76\Business\FNISDex\Items\DynamicBatchingLookup.cs:line 41 at FNISDex.RetsOutput.RetsHistoryOutput.GetDisplayString(IDictionary2 dataRow, IRetsSelectedField retsSelectedField) in D:\work\167\s\Tags\5.76\Business\FNISDex\RetsOutput\RetsHistoryOutput.cs:line 102 at FNISDex.RetsOutputFormatter.RetsColumnValueLookup.GetColumnValue(IDictionary2 dataRow, IRetsSelectedField retsSelectedField) in D:\work\167\s\Tags\5.76\Business\FNISDex\RetsOutputFormatter\RetsColumnValueLookup.cs:line 44 at FNISDex.RetsOutputFormatter.CompactFormatter.OnNewRow(IDictionary2 dataRow, IRetsSelectedField[] selectedFields) in D:\work\167\s\Tags\5.76\Business\FNISDex\RetsOutputFormatter\CompactFormatter.cs:line 47 at System.Linq.Enumerable.WhereSelectListIterator2.MoveNext() at FNISDex.RetsOutputFormatter.RetsOutputFormatter1.Flush() in D:\work\167\s\Tags\5.76\Business\FNISDex\RetsOutputFormatter\RetsOutputFormatter.cs:line 57 at FNISDex.RetsOutput.RetsJoinedTableOutput.OutputQueryResults(IRetsOutputDataFormatter output, IRetsSelectedField[] selectedFields, Int32& recordCount) in D:\work\167\s\Tags\5.76\Business\FNISDex\RetsOutput\RetsJoinedTableOutput.cs:line 324 at FNISDex.RetsOutput.RetsJoinedTableOutput.PerformJoinedTableSearch() in D:\work\167\s\Tags\5.76\Business\FNISDex\RetsOutput\RetsJoinedTableOutput.cs:line 200 (BLToolkit.4)" /> </rets>