WCFBOR_UT undecoded metadata

MissingMetdata
retag add tags

Having an issue with come critical fields in this MLS

  Running task "628-WCFBOR_IA"

Server: http://wcfbor-rets.paragonrels.com/re... User name: SK03 Full pull Local time: 1/9/2017 8:43:25 AM Server time: Mon, 09 Jan 2017 13:43:24 GMT

Running step "FARM"

Data file: K:\procdata\WCFBOR_IA\628-WCFBOR_IA-FARM.txt Search query: (L_Status=|1_0,1_2) 21 records downloaded Error detected: server failed the request Request: SearchType=Property&Class=FA_5&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(L_Status=|1_0,1_2)&Select=LFD_ACREAGE_84,L_NumAcres,LM_Char10_18,L_Address,L_AddressDirection,L_AddressNumber,L_AddressSearchNumber,L_AddressStreet,L_ListAgent1,LVC_Agent_Hit_Count,LR_remarks11,LFD_APPLIANCES_119,LM_char30_3,L_listings_associated_doc_count,LFD_BARNS_86,LFD_BASEMENT_87,LFD_BATHFEATURES_88,LM_char5_10,LM_char5_11,LM_Char50_5,LM_Char50_2,L_City,L_Class,LVC_Client_Hit_Count,L_SoldPrice,L_ClosingDate,LM_DateTime_1,LM_Char10_21,LFD_CONSTRUCTION_89,LM_Char10_29,LM_Char10_30,LM_char10_31,LM_char10_32,LM_char10_33,L_ContractDate,LFD_COOLING_90,LM_Char10_4,LM_Dec_1,LM_Dec_2,LM_char5_6,LM_char5_7,LM_Char10_3,LM_char5_1,LFD_CROPS_91,L_CDOM,LM_char255_1,LM_char255_2,LM_char100_1,LM_char100_2,LM_char100_3,LFD_DININGFACILITY_92,L_LastDocUpdate,LFD_DOCUMENTSONFILE_93,L_DOM,L_DOMLS,LM_Char25_5,LR_remarks33,LM_Char10_6,LFD_EQUIPMENT_94,L_ExpirationDate,LFD_EXTERIORAMENITIES_95,LM_Char10_24,LM_Char10_22,LFD_FENCING_96,LFD_FINANCETYPE_120,L_FirstPhotoAddDt,LM_Char10_10,LM_char10_39,LM_char10_40,LM_char10_41,LM_char10_42,LM_char10_43,LM_Char10_25,LM_Char10_13,LFD_GARAGECARPORT_97,LMD_MP_AddressLine,LMD_MP_Latitude,LMD_MP_Longitude,LMD_MP_MatchCode,LMD_MP_MatchedMethod,LMD_MP_PostalCode,LMD_MP_PrimaryCity,LMD_MP_Quality,LMD_MP_SecondaryCity,LMD_MP_Subdivision,LMD_MP_UpdateDate,LMD_MP_ZoomLevel,LFD_GRAINBINCAPACITY_98,LFD_GRAINBINFEATURES_99,LM_Char10_15,LFD_HEATTYPE_100,L_HotSheetDate,LM_Char25_10,L_HowSold,LM_Char10_5,LFD_HUNTING_101,LFD_IMPROVEMENTRATING_127,L_InputDate,LFD_INTERIORAMENITIES_102,L_IdxInclude,LA1_Address2,LA1_City,LA1_Email,LA1_UserFirstName,LA1_UserLastName,LA1_LoginName,LA1_UserMI,LA1_PhoneNumber1CountryCodeId,LA1_PhoneNumber1Ext,LA1_PhoneNumber1,LA1_PhoneNumber2CountryCodeId,LA1_PhoneNumber2Ext,LA1_PhoneNumber2,LA1_PhoneNumber3CountryCodeId,LA1_PhoneNumber3Ext,LA1_PhoneNumber3,LA1_PhoneNumber4CountryCodeId,LA1_PhoneNumber4Ext,LA1_PhoneNumber4,LA1_PhoneNumber5CountryCodeId,LA1_PhoneNumber5Ext,LA1_PhoneNumber5,LA1_State,LA1_Status,LA1_HiddenUsCID,LA1_WebPage,LA1_Zip,LA1_AddressStreet,LA1_PhoneNumber1Desc,LA1_PhoneNumber2Desc,LA1_PhoneNumber3Desc,LA1_PhoneNumber4Desc,LA1_PhoneNumber5Desc,LA1_AgentID,LA2_Address2,LA2_City,LA2_Email,LA2_UserFirstName,LA2_UserLastName,LA2_UserMI,LA2_PhoneNumber1CountryCodeId,LA2_PhoneNumber1Ext,LA2_PhoneNumber1,LA2_PhoneNumber2CountryCodeId,LA2_PhoneNumber2Ext,LA2_PhoneNumber2,LA2_PhoneNumber3CountryCodeId,LA2_PhoneNumber3Ext,LA2_PhoneNumber3,LA2_PhoneNumber4CountryCodeId,LA2_PhoneNumber4Ext,LA2_PhoneNumber4,LA2_PhoneNumber5CountryCodeId,LA2_PhoneNumber5Ext,LA2_PhoneNumber5,LA2_State,LA2_Status,LA2_HiddenUsCID,LA2_WebPage,LA2_Zip,LA2_AddressStreet,LA2_PhoneNumber1Desc,LA2_PhoneNumber2Desc,LA2_PhoneNumber3Desc,LA2_PhoneNumber4Desc,LA2_PhoneNumber5Desc,LFD_LANDIMPROVEMENT_103,LFD_LANDUSE_104,LFD_LAUNDRY_106,LM_Char10_23,LM_char512_1,L_ListAgent2,L_ListingDate,L_ListOffice1,L_ListOffice2,LO1_board_id,LO1_BranchOfOrgID,LO1_OrgAddressStreet,LO1_ShortName,LO1_OrgAddress2,LO1_OrgCity,LO1_EMail,LO1_HiddenOrgID,LO1_OrganizationName,LO1_PhoneNumber1,LO1_OrgState,LO1_HiddenOtyID,LO1_WebPage,LO1_OrgZip,LO1_PhoneNumber1CountryCodeId,LO1_PhoneNumber1Desc,LO1_PhoneNumber1Ext,LO2_board_id,LO2_BranchOfOrgID,LO2_OrgAddressStreet,LO2_ShortName,LO2_OrgAddress2,LO2_OrgCity,LO2_EMail,LO2_HiddenOrgID,LO2_OrganizationName,LO2_PhoneNumber1,LO2_OrgState,LO2_HiddenOtyID,LO2_WebPage,LO2_OrgZip,LO2_PhoneNumber1CountryCodeId,LO2_PhoneNumber1Desc,LO2_PhoneNumber1Ext,LFD_LOTDESCRIPTION_107,LM_Char25_3,LM_Char25_2,LM_Char10_19,LM_Char10_7,L_DisplayId,L_Area,LM_Char10_20,LM_char5_8,LM_char5_9,L_OffMarketDate,L_OriginalPrice,LM_Char50_4,LM_Char25_1,LM_char5_4,LM_char50_7,L_PictureCount,L_Last_Photo_updt,LFD_PONDS_108,L_AskingPrice,L_PriceDate,LM_Char10_2,LM_Char50_3,LR_remarks22,LFD_RECENTCROPS_109,LM_Char10_17,LM_Char25_27,LM_char5_5,LFD_ROADFRONTAGE_110,LM_Char10_28,LM_char10_34,LM_char10_35,LM_char10_36,LM_char10_37,LM_char10_38,SA1_Address2,SA1_City,SA1_Email,SA1_UserFirstName,SA1_UserLastName,SA1_UserMI,SA1_PhoneNumber1CountryCodeId,SA1_PhoneNumber1Ext,SA1_PhoneNumber1,SA1_PhoneNumber2CountryCodeId,SA1_PhoneNumber2Ext,SA1_PhoneNumber2,SA1_PhoneNumber3CountryCodeId,SA1_PhoneNumber3Ext,SA1_PhoneNumber3,SA1_PhoneNumber4CountryCodeId,SA1_PhoneNumber4Ext,SA1_PhoneNumber4,SA1_PhoneNumber5CountryCodeId,SA1_PhoneNumber5Ext,SA1_PhoneNumber5,SA1_State,SA1_Status,SA1_HiddenUsCID,SA1_WebPage,SA1_Zip,SA1_AddressStreet,SA1_PhoneNumber1Desc,SA1_PhoneNumber2Desc,SA1_PhoneNumber3Desc,SA1_PhoneNumber4Desc,SA1_PhoneNumber5Desc,LM_Char25_28,L_SaleRent,L_SystemPrice,LM_char5_36,L_SellingAgent1,LM_Char50_1,L_SellingOffice1,LFD_SEWER_111,LM_Char10_12,SO1_board_id,SO1_BranchOfOrgID,SO1_OrgAddressStreet,SO1_ShortName,SO1_OrgAddress2,SO1_OrgCity,SO1_EMail,SO1_HiddenOrgID,SO1_OrganizationName,SO1_PhoneNumber1,SO1_OrgState,SO1_HiddenOtyID,SO1_WebPage,SO1_OrgZip,SO1_PhoneNumber1CountryCodeId,SO1_PhoneNumber1Desc,SO1_PhoneNumber1Ext,LM_Char10_26,LM_char50_6,LFD_SOILTYPE_112,LM_Char10_8,L_State,L_Status,L_StatusCatID,L_StatusDate,L_StreetDesignationId,LFD_STRUCTURE_113,L_ListingID,T_tax_db_id,T_list_tax_property_id,LM_Char10_27,LM_char5_2,LM_Char25_4,LFD_TOPOGRAPHY_114,LM_Char10_16,L_Type_,L_Address2,L_UpdateDate,LFD_UTILITIESAVAILABLE_115,VT_VTourURL,VT_ExtVTourURL1,LV_vow_address,LV_vow_avm,LV_vow_comment,LV_vow_include,LFD_WATERSUPPLYUL_122,LM_Char10_11,LFD_WINDOWS_116,LM_char5_3,LM_Int4_1,L_Zip,LM_char10_70,LM_Char10_9 RETS Status code = 20203: Undecoded values were sent: Miscellaneous Search Error. Lookup: value Genoa not found in Lookup table City_Lkp_5 for Resource 1. [L_City] Miscellaneous Search Error. Lookup: value Vernon not found in Lookup table County_Lkp_5 for Resource 1. [LM_Char10_3] Miscellaneous Search Error. Lookup: value 54632 not found in Lookup table ZipCode_Lkp_5 for Resource 1. [LM_char10_70]