Ask Your Question
0

Downloading History resource for RE_1 is failing with server error

asked 2020-04-13 12:40:01 -0500

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 ... (more)

edit retag flag offensive close merge delete

Comments

Bruce, If you want i can upload/email the http log for this issue.

Tony gravatar imageTony ( 2020-04-13 12:45:34 -0500 )edit

Tony, Are you pulling all fields or just select ones?

bwolven gravatar imagebwolven ( 2020-04-13 15:41:37 -0500 )edit

If you don't need the LR_remarks* fields, it will work if you leave them out of the field select.

bwolven gravatar imagebwolven ( 2020-04-13 16:44:57 -0500 )edit

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.

Tony gravatar imageTony ( 2020-04-14 10:51:11 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2020-04-14 10:53:38 -0500

As a work-around we will explore changing this account from OFFSET to our INDEX mode so we initially selecting unique key field, then use that to download all our mapped fields.

edit flag offensive delete link more

Comments

Tony, when you get a chance, can you see if you are still having these timeout issues?
Hopefully this should be working better now.

bwolven gravatar imagebwolven ( 2020-08-07 17:29:00 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-04-13 12:40:01 -0500

Seen: 39 times

Last updated: Apr 13