Something wrong with the Demo Server?

[Keith T. Garner]

On Apr 29, 2008, at 8:49 AM, Johnathon Sanders wrote:
> There seems to be something wrong with the demo server. I can log in
> fine, but the queries just return a 20513. For example, try
> http://demo.crt.realtors.org:6103/rets/search?SearchType=Property&Class=ResidentialProperty&Query=(LP=300000-)
> Is there something i should be doing differently?

It looks like there are two things at work here. One, you missed a
required parameter as specified in Section 7.3 of the RETS spec. You
need to have a QueryType=DMQL2 in there.

The second problem is the error message, but its a non-issue after you
take care of the above. However, we should still change it to give a
better message. On the server, we're getting a NullPointerException
due to traving to evaluate the missing (required) QueryType header.
We should maybe test that first before trying to evaluate on it.

Outside of this, I also recommend doin g queries as POST as many http
client and server libraries do DIGEST-AUTH wrong in the presence of
the query parameters on the URL.

Keith

--
Keith T. Garner - Managing Director - Center for REALTOR� Technology
kga...@realtors.org - 312-329-3294 - http://blog.realtors.org/crt

[Keith T. Garner]

On Apr 29, 2008, at 2:10 PM, Johnathon Sanders wrote:
> Thank you for the reply. That was dumb of me, I knew better then to
> not include the QueryType. However, now that I do, it says
> "Miscellaneous Search Error: Invalid query type: DMQL2". There must've
> been something that changed recently, because I know I've gotten
> queries
> to work on this server before... Does it actually work for you? I just
> tried:
> http://demo.crt.realtors.org:6103/rets/search?&SearchType=PropertyClass=ResidentialProperty&Query=(LP=300000-)&QueryType=DMQL2

Now it sounds like you're missing the "RETS-Version: 1.5" header.
Variman will fall back to RETS 1.0 behavior in the absence of that
header. DMQL2 is valid for RETS 1.5 and RETS 1.5 only. RETS 1.0 was
only DMQL.

[Keith T. Garner]

Okay, look like you found an interesting bug in Variman by sending an
illegal query. The query in the file you sent is '(LD=0+),(LS=A*)'

LD is a date, and what you sent was not a valid date. What's
interesting is its again a case of us sending a bad error message, but
its still a bad query. In any case, here's what's happening on the
server side:

-> SELECT: LD DMQL: (LD=0+),(LS=A*) SQL: SELECT r_ld FROM
rets_property_res WHERE ((r_ld >= '0')) AND (r_ls LIKE 'A%')
29 Apr 2008 14:46:23,248 ERROR [209.98.202.99 Joe]
org.realtors.rets.server.webapp.RetsServlet
-> Caught org.realtors.rets.server.RetsServerException:
org.postgresql.util.PSQLException:
ERROR: date/time field value out of range: "0"

Keith

On Apr 29, 2008, at 2:57 PM, Johnathon Sanders wrote:

> Keith,
> I've just realized that this issue is just like a thread we had on
> this list about 7 months ago... only at that point I was using the
> JRETSC API, and upon switching to the CART API, it magically worked.
> However, I am currently using the CART API and this problem has popped
> back up. I'm attaching the full TCP stream of the request, from
> login to
> error, I'm making (the query request is a little more detailed then
> the
> one I pasted in earlier). It will show that the RETS version is
> getting
> set to 1.5. Back in October, you mentioned that the API was trying to
> access port 80 instead of 6103, and that was the issue... but
> looking at
> this feed, it looks like it is now correctly trying to access 6103
> properly. Any ideas? Thanks for your time!
> ~Johnathon

>
>
>
> On Tue, 2008-04-29 at 14:23 -0500, Keith T. Garner wrote:
>> On Apr 29, 2008, at 2:10 PM, Johnathon Sanders wrote:
>>> Thank you for the reply. That was dumb of me, I knew better then
>>> to
>>> not include the QueryType. However, now that I do, it says
>>> "Miscellaneous Search Error: Invalid query type: DMQL2". There
>>> must've
>>> been something that changed recently, because I know I've gotten
>>> queries
>>> to work on this server before... Does it actually work for you? I
>>> just
>>> tried:
>>> http://demo.crt.realtors.org:6103/rets/search?&SearchType=PropertyClass=ResidentialProperty&Query=(LP=300000-)&QueryType=DMQL2
>>
>> Now it sounds like you're missing the "RETS-Version: 1.5" header.
>> Variman will fall back to RETS 1.0 behavior in the absence of that
>> header. DMQL2 is valid for RETS 1.5 and RETS 1.5 only. RETS 1.0 was
>> only DMQL.
>>
>> Keith
>>

> _______________________________________________
> Variman-users mailing list
> Varima...@crt.realtors.org
> http://mail.crt.realtors.org/mailman/listinfo/variman-users

[Tony Russo]

Looks like some things are missing and a couple of typos, see if this works for you.



http://demo.crt.realtors.org:6103/rets/search?Class=ResidentialProperty&Count=1&Format=COMPACT&Limit=NONE&Query=(LP=300000-)&QueryType=DMQL2&SearchType=Property&StandardNames=0



Tony





-----Original Message-----
From: variman-us...@crt.realtors.org [mailto:variman-us...@crt.realtors.org] On Behalf Of Johnathon Sanders
Sent: Tuesday, April 29, 2008 3:11 PM
To: For users/developers of the Variman RETS Server
Subject: Re: [Variman] Something wrong with the Demo Server?



Keith,

Thank you for the reply. That was dumb of me, I knew better then to

not include the QueryType. However, now that I do, it says

"Miscellaneous Search Error: Invalid query type: DMQL2". There must've

been something that changed recently, because I know I've gotten queries

to work on this server before... Does it actually work for you? I just

tried:

http://demo.crt.realtors.org:6103/rets/search?&SearchType=PropertyClass=ResidentialProperty&Query=(LP=300000-)&QueryType=DMQL2

~Johnathon

On Tue, 2008-04-29 at 11:16 -0500, Keith T. Garner wrote:

> On Apr 29, 2008, at 8:49 AM, Johnathon Sanders wrote:

> > There seems to be something wrong with the demo server. I can log in

> > fine, but the queries just return a 20513. For example, try

> > http://demo.crt.realtors.org:6103/rets/search?SearchType=Property&Class=ResidentialProperty&Query=(LP=300000-)

> > Is there something i should be doing differently?

>

> It looks like there are two things at work here. One, you missed a

> required parameter as specified in Section 7.3 of the RETS spec. You

> need to have a QueryType=DMQL2 in there.

>

> The second problem is the error message, but its a non-issue after you

> take care of the above. However, we should still change it to give a

> better message. On the server, we're getting a NullPointerException

> due to traving to evaluate the missing (required) QueryType header.

> We should maybe test that first before trying to evaluate on it.

>

> Outside of this, I also recommend doing queries as POST as many http

> client and server libraries do DIGEST-AUTH wrong in the presence of

> the query parameters on the URL.

>

[Tony Russo]

Hi Johnathon,



That link does not seem to work from IE browser, however it does work using a RETS Client. This RETS search:



Class=ResidentialProperty&Count=1&Format=COMPACT-DECODED&Limit=NONE&Query=(LP=300000-)&QueryType=DMQL2&SearchType=Property&StandardNames=0



Returns this data:











LN CLDATE CODATE LD TIMESTAMP CP LP AGENTID OFFICEID BOARD BATHS BEDROOMS LS STNUM UNNUM STREETDIRECTION STNAME CITY COUNTY STATE ZIPCODE YearBuilt Garage LivingArea TotalRooms SQFT

LN000002 2005-03-23 250000 Joe 1 3 Active 1250 E Armitage Ave Chicago Cook IL 60613 1975 3 900 8

LN000001 2005-04-14 300000 agent07 2 5 Active 430 N Michigan Ave Chicago Cook IL 60605 1989 1 1400 11 1250.12

LN000005 2004-09-01 2004-07-04 233000 250000 agent07 3 4 Closed 625 N Michigan Chicago Cook IL 60605 1978 2 1100 9 1500.2323

Tony



-----Original Message-----
From: variman-us...@crt.realtors.org [mailto:variman-us...@crt.realtors.org] On Behalf Of Johnathon Sanders
Sent: Tuesday, April 29, 2008 3:59 PM
To: For users/developers of the Variman RETS Server
Subject: Re: [Variman] Something wrong with the Demo Server?

Tony,

Thanks for your help. Unfortunately, I still have the same problem

even using th e link provided.

~Johnathon





On Tue, 2008-04-29 at 15:21 -0400, Tony Russo wrote:

>

>

> Looks like some things are missing and a couple of typos, see if this

> works for you.

>

>

>

> http://demo.crt.realtors.org:6103/rets/search?Class=ResidentialProperty&Count=1&Format=COMPACT&Limit=NONE&Query=(LP=300000-)&QueryType=DMQL2&SearchType=Property&StandardNames=0

>

>

>

> Tony

>

>

>

>

>

> -----Original Message-----

> From: variman-us...@crt.realtors.org

> [mailto:variman-us...@crt.realtors.org] On Behalf Of Johnathon

> Sanders

> Sent: Tuesday, April 29, 2008 3:11 PM

> To: For users/developers of the Variman RETS Server

> Subject: Re: [Variman] Something wrong with the Demo Server?

>

>

>

> Keith,

>

> Tha nk you for the reply. That was dumb of me, I knew better then

[sanjay...@gmail.com]

 I am also facing the same problem.

    I am getting the metadata of resouces and tables as a whole(ID=0), but i am not getting a single resource or table by by searching with its    ID.

ie
http://localhost:8080/variman/rets/getMetadata?Type=METADATA-RESOURCE&ID=0&Format=COMPACT is working but
http://localhost:8080/variman/rets/getMetadata?Type=METADATA-RESOURCE&ID=123&Format=COMPACT is not working where 123 is one of the resource id.