Ask Your Question

Lookup: value THERESEDUN not found in Lookup table SecOrSub_Lkp_1 for Resource 1

asked 2016-11-21 08:17:37 -0600

This worked great for a few days but started getting this error on Friday while trying to pull residential listings.

We're using the latest rets connector 1.2.7160

  Running task "SC - Spartanburg Data"

Server: User name: ParAgon Full pull Local time: 11/19/2016 8:04:50 AM Server time: Sat, 19 Nov 2016 13:04:50 GMT

Running step "Multi"

Data file: D:\inetpub\wwwroot\schedule\idx_downloads\SC_spartanburg_multi.txt Search query: (L_Status=|1_0,1_1),(LM_Char10_5=|Y) 29 records downloaded RETS Status code = 0: SUCCESS Step finished at 11/19/2016 8:04:51 AM

Running step "res"

Data file: D:\inetpub\wwwroot\schedule\idx_downloads\SC_spartanburg_residential.txt Search query: (L_Status=|1_0,1_1),(LM_Char10_5=|Y) 1436 records downloaded Error detected: server failed the request Request: SearchType=Property&Class=RE_1&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(L_Status=|1_0,1_1),(LM_Char10_5=|Y)&Select=L_DisplayId,LO1_OrganizationName,LO1_PhoneNumber1,L_ListingDate,L_AskingPrice,L_Type_,LR_remarks11,L_State,L_AddressNumber,L_AddressStreet,L_AddressDirection,L_City,L_Zip,LM_Char10_3,L_Area,LM_Int2_1,L_NumAcres,LM_Char25_3,L_SquareFeet,L_Keyword1,L_Keyword2,L_Keyword3,L_Keyword10,LM_Char10_7,LM_Char10_9,LM_Char10_8,LM_Char10_10,VT_VTourURL,L_PictureCount,LM_Int4_4,LM_Int4_1,LFD_HOAINCLUDES_19,L_Keyword9,LM_Int4_2,LM_Int4_3,LM_char5_6,LM_char5_7,LM_char5_4,LM_char5_5,LFD_AMENITIES_20,LFD_APPLIANCES_12,LFD_BASEMENT_18,LM_Char25_5,LFD_COOLINGFUEL_62,LFD_COOLINGSYSTEM_7,LFD_DRIVEWAY_66,LFD_EXTERIOR_3,LFD_EXTERIORFEATURES_13,LFD_FLOORS_5,LFD_FOUNDATION_4,L_Keyword6,LFD_GARAGECARPORT_8,LFD_GARBAGEPICKUP_65,LFD_HEATSYSTEM_6,LFD_HEATINGFUELTYPE_63,LFD_INTERIORFEATURES_14,LFD_LOTDESCRIPTION_11,L_Keyword7,LFD_MOBILEHOME_82,LFD_ROOF_2,LM_Char10_2,LFD_SEWER_10,LFD_SPECIALTYROOMS_17,LFD_STORAGESPACE_21,LFD_STYLE_1,LM_Char10_15,LM_Char10_17,LM_Char10_16,LFD_WATER_9,LM_Char10_6,LFD_WATERHEATER_83,LM_Char25_4 RETS Status code = 20203: Undecoded values were sent: Miscellaneous Search Error. Lookup: value THERESEDUN not found in Lookup table SecOrSub_Lkp_1 for Resource 1. [LM_Char10_2]

Step finished at 11/19/2016 8:05:34 AM

Last URL requested:

  Task "SC - Spartanburg Data" failed
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2016-11-21 10:57:20 -0600

updated 2016-12-08 15:48:30 -0600

I notified the SSM who will coordinate getting this fixed.

Update 2016-11-23 15:20 CST: Still waiting for the refresh to be approved and scheduled.

In the mean time you could break it up into two requests. One that excludes that lookup value to get everything but those. And a second one that Only includes that lookup value. Even though it fails, you would still get the data. It just includes the undecoded value for the field since it isn't in the lookup metadata.

You can also do the search using COMPACT which will return the undecoded value for the field and use the lookup metadata in your client to populate the decoded value. Then you have much more control over how they are handled and the download won't return an error.

Update 2016-12-07 14:25 CST: Sent followup request about RETS Refresh.

Update 2016-12-08 11:52 CST: The RETS Refresh has been completed. Please verify that your issues are fixed and add a comment this site. Thanks for your patience.

edit flag offensive delete link more


Hi, it's been a few days and I'm still getting the same error and am not able to run an update. Any idea when they will get to this? Thank you.

Paragon gravatar imageParagon ( 2016-11-23 14:20:05 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-21 08:17:37 -0600

Seen: 416 times

Last updated: Dec 08 '16