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

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,

### 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
format=COMPACT
searchtype=Property
Query=(L_ListingID=0+),(L_UpdateDate=2021-08-07T10:08:46+)
class=RE_1
standardnames=0
limit=2000
querytype=DMQL2querytype=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,

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