Ask Your Question

Tony's profile - activity

2020-05-26 22:48:12 -0500 received badge  Notable Question (source)
2020-04-17 11:22:36 -0500 marked best answer 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 ... (more)

2020-04-14 11:43:21 -0500 received badge  Popular Question (source)
2020-04-14 10:53:38 -0500 commented question Downloading History resource for RE_1 is failing with server error

As a work-around we will explore changing this account from OFFSET to our INDEX mode so we initially selecting unique k

2020-04-14 10:51:11 -0500 commented question Downloading History resource for RE_1 is failing with server error

we're using OFFSET for BNFS for all our account, ~ 15 years. This account LIMIT set to 1999. Suddenly yesterday RETS ser

2020-04-14 10:34:16 -0500 received badge  Enthusiast
2020-04-13 12:45:34 -0500 commented question Downloading History resource for RE_1 is failing with server error

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

2020-04-13 12:40:01 -0500 asked a question Downloading History resource for RE_1 is failing with server error

Downloading History resource for RE_1 is failing with server error URL:http://mlsbox.rets.paragonrels.com/rets/fnisrets.

2020-03-28 12:17:09 -0500 received badge  Famous Question (source)
2019-04-04 13:42:12 -0500 received badge  Popular Question (source)
2019-04-01 12:03:21 -0500 marked best answer This is a BNFS server time issue.

* This is not a RETS issue, it's a BNFS server time issue. * we were asked to report this on behalf of our mutual customer.

URL: http://bcar.rets.paragonrels.com/rets... Account: iCheckRETS1

The timestamp you are sending is off by up to 3 minutes too fast causing authentication depending on time to fail.

Recommend all BNFS servers to synchronize to the correct GMT internet time.

2019-04-01 10:36:12 -0500 asked a question This is a BNFS server time issue.

This is a BNFS server time issue. * This is not a RETS issue, it's a BNFS server time issue. * we were asked to report t

2019-01-25 08:59:54 -0500 received badge  Famous Question (source)
2018-11-15 09:47:09 -0500 commented answer History DMQL queries are timeing out

Let me check with NEREN and I will update you.

2018-11-08 17:07:30 -0500 commented question History DMQL queries are timeing out

The list below shows 3 jobs beginning at 1700. Only the last job starting at 17:01:54 was set to use batch 1,00. This i

2018-11-08 16:44:39 -0500 received badge  Famous Question (source)
2018-11-08 16:39:37 -0500 commented question History DMQL queries are timeing out

That 15 minutes is for the whole job to run, which consists of many DMQL queries. So this shows a difference where the

2018-11-08 15:53:34 -0500 commented question History DMQL queries are timeing out

11/8/2018 16:02:28 Elapsed Time 15:44 (batch 100)

2018-11-08 15:37:48 -0500 commented question History DMQL queries are timeing out

Just changed batch to 1,000 Queries run hourly next run at 1700 EST

2018-11-08 15:35:38 -0500 commented question History DMQL queries are timeing out

As of this post, from today's logs: All queries times are EST using batch of 100, following this response will change to

2018-11-08 15:34:42 -0500 commented question History DMQL queries are timeing out

As of this post, from today's logs: All queries times are EST using batch of 100, following this response will change to

2018-11-08 15:34:02 -0500 commented question History DMQL queries are timeing out

As of this post, from today's logs: All queries times are EST using batch of 100, following this response will change to

2018-11-08 14:32:02 -0500 received badge  Notable Question (source)
2018-11-08 14:06:44 -0500 received badge  Popular Question (source)
2018-10-18 18:59:38 -0500 commented question History DMQL queries are timeing out

OK, thanks

2018-10-18 11:49:22 -0500 commented question History DMQL queries are timeing out

Hi Bruce, What HTML timout are you referring to? This is a back office script using php with phprets v1 with no explic

2018-10-18 11:49:22 -0500 received badge  Commentator
2018-10-18 09:18:27 -0500 asked a question History DMQL queries are timeing out

History DMQL queries are timeing out http://neren.rets.paragonrels.com/rets/fnisrets.aspx/NEREN/login?rets-version=rets/

2018-06-26 13:56:55 -0500 marked best answer get object Document
  1. http://neren.rets.paragonrels.com/ret...
  2. rus0808

We received a message from the MLS that you need us to contact you regarding an issue they are seeing related to high levels of queries.

2018-06-24 09:16:18 -0500 commented answer get object Document

OK, we will add Logout to all our queries

2018-06-24 09:14:54 -0500 received badge  Notable Question (source)
2018-06-19 13:52:22 -0500 received badge  Notable Question (source)
2018-06-19 13:16:53 -0500 commented answer get object Document

There seems to be an issue today with our RETS downloads at 10 AM all 3 batches failed, 11 am completed without errors,

2018-06-19 11:57:34 -0500 commented answer get object Document

NO! After reviewing our logs, the last time anything was imported from the history resource was 8/30/17. Why is that?

2018-06-19 11:44:53 -0500 received badge  Popular Question (source)
2018-06-19 07:13:57 -0500 answered a question get object Document

This is a dynamic batch query derived from all listings in our local database that do not have any history records in ba

2018-06-18 16:18:46 -0500 asked a question get object Document

get object Document http://neren.rets.paragonrels.com/rets/fnisrets.aspx/NEREN/login?rets-version=rets/1.7.2 rus0808

2018-05-03 09:02:50 -0500 received badge  Notable Question (source)
2018-05-03 09:02:50 -0500 received badge  Famous Question (source)
2018-01-21 15:46:17 -0500 received badge  Famous Question (source)
2017-10-04 13:29:50 -0500 received badge  Notable Question (source)
2017-08-21 14:59:13 -0500 received badge  Popular Question (source)
2017-08-21 10:23:00 -0500 received badge  Notable Question (source)
2017-08-21 10:23:00 -0500 received badge  Popular Question (source)
2017-08-21 10:23:00 -0500 received badge  Famous Question (source)
2017-08-16 17:31:41 -0500 asked a question RETS Server host time

RETS Server host time Host: http://neren.rets.paragonrels.com/rets/fnisrets.aspx/NEREN/login RETS versions 1.5 - 1.8 R

2017-08-16 09:34:12 -0500 asked a question RETS 1.8 update transaction - validate-flag values 0|1|2

RETS 1.8 update transaction - validate-flag values 0|1|2 User: iCheck URL: /rets/fnisrets.aspx/RANWMLS/update Having a

2017-08-14 14:11:29 -0500 received badge  Famous Question (source)
2017-07-12 13:51:50 -0500 marked best answer L_UpdateDate is triggered when images added/deleted

URL: https://ranwmls-rets.paragonrels.com/... User iCheck

Description: RANW MLS would like iCheck to send email notifications to members anytime a listing has been modified, but only when data in the listing has changed, not when only a photo was added or deleted.

Issue: It appears when a photo is added or deleted by the a member or BNFS process it triggers both the Listings Modified Time Stamp (L_UpdateDate) and the Image Modified Time Stamp (L_Last_Photo_updt). Additionally when a photo is added or deleted, the Listing’s Image Count (L_PictureCount) is changed which may be why Listings Modified Time Stamp (L_UpdateDate) is updated.

The problem: iCheck is using the Listings Modified Time Stamp (L_UpdateDate) to detect when the listing (data) has been modified in order to send the email notifications. Resulting in emails being sent when only a photo has been modified by a member or BNFS.

Possible Remedies/work-around: 1. BNFS advise iCheck if there is a different RETS timestamp field to use to detect when only listing’s data has changed (excluding L_ PictureCount)? 2. When a photo is added or deleted BNFS stop triggering a Listings Modified Time Stamp (L_UpdateDate) and only trigger an Image Modified Time Stamp (L_Last_Photo_updt).

Side note: In RANW MLS’s metadata Table the ModTimeStamp column is set to false for all fields, it should be set to true for any field that triggers the ModfiedTime Stamp Change.