Ask Your Question

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
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

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:


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


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

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

This should be resolved now!

edit flag offensive delete link more


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


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

Seen: 8,998 times

Last updated: Sep 15 '21