Query errors with a timeout

edit

Looking into the issue.

I am able to reproduce it in the RE_1 class only.
If I set offset = 0 it doesn't seem to hang..
Not sure why it is happening yet.

Yes, it is happening only for RE_1

Can you try adding one of the LM_* fields to your select and see if it works with that.
Doesn't matter which one.

It works. If I do count=2 that works, if I do limit=27 it works, if I do limit=29 it times out. I am sure it has nothing to do with 29. http://wcfbor.rets.paragonrels.com/re... http://wcfbor.rets.paragonrels.com/re...

When I run your original query, if I use offset=1 and limit=31 or higher it times out.
When I add LM_Char10_2 to your original select, I don't get the timeout.
If you are working after adding a LM_* field, then we should be good until our DBA has time to do further analysis on this.

This query is created dynamically, so we cannot do a custom query for just this feed. So far, all other paragon feeds work fine. This is the first time we have encountered this.

Do you know when this timeout issue started happening?

This is the first time we are setting up this feed in our system. So, this started after we set it up last week. If I do not select any fields, it works, I get all data back. that is so strange. Also, this happens only for RE_1

I know. That is what I am seeing too. If all fields are returned, it doesn't hang.
Or if you add another field like LM_* to the pull it doesn't hang.
Not sure what the issue is yet. DBA still looking at it too.

For now if you can just configure it to return all fields instead of the few you need to get you working.
We will still try to figure out why it is happening and it only seems to happen on this MLS DB.

Actually, that is what we will be doing until this gets resolved. Thank you for your help. We will wait to hear back on this and then we can change this back to the standard query

We have another one with the same problem. Longview TX. If I make changes like prev. case, they work.

username: dandornoon

http://lgvboard.rets.paragonrels.com/...

Can you check your WCFBOR and LGVBOARD pulls again with the restricted fields and see if you still get the timeouts?
I was able to reproduce them before but they both seem to be working now for me.

Thank you. They both are working fine right now. Again, Thank you very much for your help. Rohini