Ask Your Question

Revision history [back]

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

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: http://sptbgmls.rets.paragonrels.com/rets/fnisrets.aspx/SPTBGMLS/login?rets-version=rets/1.7.2 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: http://sptbgmls.rets.paragonrels.com/rets/fnisrets.aspx/SPTBGMLS/search

  Task "SC - Spartanburg Data" failed