Ask Your Question
0

Search Error - (20206) [Illegal number in range for field [L_StatusCatID]] on a new feed

asked 2021-09-15 08:14:33 -0600

updated 2021-09-15 08:26:50 -0600

Hello, We are trying to set up a new RETS feed with you for Tehama County Association of Realtors. I can access the Member and Office classes without issues, but when I try to pull any of the Property classes, I get the error:

Search Error - (20206) [Illegal number in range for field [L_StatusCatID]]

I do not use the L_StatusCatID field in my select or query, so I'm not sure why I'm seeing this unless it is a required field in the query, which I have never seen on any Black Knight feeds (we have over 50).

I am using the following information:

version: RETS/1.7.2
login: http://tcaor-rets.paragonrels.com:80/rets/fnisrets.aspx/TCAOR/login
user: TERRADATUMRETS select=LA1_AgentID,LMD_MP_Latitude,LMD_MP_Longitude,LMD_MP_Subdivision,LM_Char10_1,LO1_ShortName,LO1_board_id,LO2_HiddenOrgID,LO2_ShortName,L_Address,L_Address2,L_AddressDirection,L_AddressNumber,L_AddressSearchNumber,L_AddressStreet,L_Area,L_AskingPrice,L_CDOM,L_City,L_Class,L_ClosingDate,L_ContractDate,L_DOM,L_ExpirationDate,L_InputDate,L_ListAgent1,L_ListAgent2,L_ListOffice1,L_ListOffice2,L_ListingDate,L_ListingID,L_NumAcres,L_OriginalPrice,L_SellingAgent1,L_SellingAgent2,L_SellingOffice1,L_SellingOffice2,L_SoldPrice,L_State,L_Status,L_StatusDate,L_Type_,L_UpdateDate,L_Zip,T_list_tax_property_id,T_tax_db_id
format=COMPACT
searchtype=Property
Query=(L_ListingID=0+),(L_UpdateDate=2021-08-07T10:08:46+)
class=RE_1
standardnames=0
limit=2000
querytype=DMQL2

Any suggestions? I also have this same error using BRIGHT Conduit for RETS, and a colleague at Lone Wolf has no issue with her credentials (same query and endpoint as above) but does with ours.

I did also try changing my query to:

Query=(L_ListingID=0+),(L_StatusCatID=1,2,3,4,5,6),(L_UpdateDate=2021-08-07T10:08:46+)

And I get the same error. I was hoping putting it in there with numeric values would get around the issue.

Many thanks,

Dan Stegman

edit retag flag offensive close merge delete

Comments

Hey Dan! It looks like the filter for your profile was not in the valid format. I've reached out to the MLS' point of contact, i'll post here once it's resolved.

Thank you,

Sadie gravatar imageSadie ( 2021-09-15 09:27:07 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2021-09-15 09:50:15 -0600

This should be resolved now!

edit flag offensive delete link more

Comments

Sadie, Thank you for your prompt attention. Glad it was an easy fix. Dan

dstegman gravatar imagedstegman ( 2021-09-15 09:53:22 -0600 )edit

You're welcome! And me too!

Sadie gravatar imageSadie ( 2021-09-15 11:07:16 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-09-15 08:14:33 -0600

Seen: 8,963 times

Last updated: Sep 15 '21