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. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> 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<code>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; 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; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource</code>1 completion, Int32 timeout, Task& task, Boolean& 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.<>c__DisplayClass99_0.<ExecuteReaderInternal>b__0()
at BLToolkit.Data.DbManager.ExecuteOperation<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.<RunQuery>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& result) in D ...
Comments
Bruce, If you want i can upload/email the http log for this issue.
Tony, Are you pulling all fields or just select ones?
If you don't need the LR_remarks* fields, it will work if you leave them out of the field select.
we're using OFFSET for BNFS for all our account, ~ 15 years. This account LIMIT set to 1999. Suddenly yesterday RETS server timed out for History RE_1 only. Testing set LIMIT to 500 no issues History RE_1. Testing changed to INDEX mode - where we send 1 query fro all L_ListingID meeting DMQL query. From that we do dmql queries in batches of 1999 our mapped fields and that works. Seems like the RETS Server is timing. We do need the LR_remarks field.