Ask Your Question

Revision history [back]

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

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.

Many thanks,

Dan Stegman Terradatum/Lone Wolf

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

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

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.

Many thanks,

Dan Stegman Terradatum/Lone WolfStegman

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

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