Ask Your Question
0

IRMLS column in metadata, but nolonger available

asked 2018-07-31 04:37:18 -0500

SmarterAget gravatar image

Running step "RENT" Data file: \10.0.1.105\data\procdata\IRMLS\817-IRMLS-RENT.txt Search query: (L_Status=|1_0,1_1,1_2,1_3,1_4,1_5,1_6,1_7,3_0) 0 records downloaded Error detected: server failed the request Request: SearchType=Property&Class=RR_5&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(L_Status=|1_0,1_1,1_2,1_3,1_4,1_5,1_6,1_7,3_0)&Select=LM_Int1_5,LM_Int1_8,LM_Int1_6,LM_Int4_1,LM_Int2_15,LM_Int2_17,LM_Int4_2,LM_Int2_16,LM_Int2_18,LM_Int1_11,LM_Int1_4,LM_int4_33,LM_Char1_8,LM_int4_34,LM_int4_35,LM_Char1_9,LM_int4_36,LM_Int2_3,LM_Char1_10,LM_Int2_4,LM_Int2_5,LM_Char1_11,LM_Int2_6,LM_Int2_7,LM_Char1_12,LM_Int2_8,LM_int4_37,LM_Dec_18,LM_char50_31,L_Address,L_AddressDirection,L_AddressNumber,L_AddressSearchNumber,L_AddressStreet,LM_Int4_17,LVC_Agent_Hit_Count,LR_remarks22,LM_Char25_20,LM_Char10_24,LV_vow_avm,LFD_AMENITIES_133,LM_Dec_10,LM_Dec_30,L_NumAcres,LM_Dec_1,LFD_ARCHITECTURALSTYLE_82,L_Area,LM_Dec_3,LM_char10_31,LM_char10_33,L_listings_associated_doc_count,LM_Dec_7,LM_char30_30,LM_DateTime_7,LM_char50_16,LM_DateTime_10,LFD_BASEMENTMATERIAL_92,LM_char30_27,LFD_BASEMENTFOUNDATION_78,LM_int4_38,LM_Int4_5,VT_VTourURL,LM_int4_29,LM_Char1_6,LM_int4_30,LFD_CABLECOMPANY_388,LM_Dec_5,L_City,L_Class,LVC_Client_Hit_Count,LM_char1_36,L_ListAgent2,L_ListOffice2,LFD_COMMONAMENITIES_134,LFD_COOLING_81,L_SellingAgent2,L_SellingOffice2,LM_Dec_29,LM_Char50_2,L_CDOM,LM_Char50_5,LM_int4_31,LM_Char1_7,LM_int4_32,LM_int4_23,LM_Char1_3,LM_int4_24,L_Remarks,L_LastDocUpdate,LFD_DOCUMENTSAVAILABLE_135,L_DOM,L_DOMLS,LFD_DRIVEWAY_394,LFD_ELECTRICCOMPANY_401,LM_Char10_13,LM_char50_30,LFD_ENERGYEFFICIENT_129,LFD_ENRGYEFFCNTWINDOORS_131,LM_char50_34,L_ExpirationDate,LM_Char25_2,LM_Int2_13,LM_Char1_15,LM_Int2_14,LM_int4_25,LM_Char1_4,LM_int4_26,LFD_FENCE_136,LM_char50_28,LFD_FIREPLACE_83,LM_char1_24,L_FirstPhotoAddDt,LFD_FLOORING_378,LM_Int4_11,LM_Dec_11,LM_char10_34,LM_Int4_18,LM_char1_21,LM_Dec_21,LFD_GASCOMPANY_408,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_GREENCERTIFICATIONS_132,LM_Char10_17,LM_Int4_9,LFD_HEATINGFUEL_80,LM_Char10_15,L_HotSheetDate,L_HowSold,LFD_HVAC_130,L_IdxInclude,L_InputDate,LM_char30_9,LM_int4_27,LM_Char1_5,LM_int4_28,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,LA2_AgentID,LA3_Address2,LA3_City,LA3_Email,LA3_UserFirstName,LA3_UserLastName,LA3_UserMI,LA3_PhoneNumber1CountryCodeId,LA3_PhoneNumber1Ext,LA3_PhoneNumber1,LA3_PhoneNumber2CountryCodeId,LA3_PhoneNumber2Ext,LA3_PhoneNumber2,LA3_PhoneNumber3CountryCodeId,LA3_PhoneNumber3Ext,LA3_PhoneNumber3,LA3_PhoneNumber4CountryCodeId,LA3_PhoneNumber4Ext,LA3_PhoneNumber4,LA3_PhoneNumber5CountryCodeId,LA3_PhoneNumber5Ext,LA3_PhoneNumber5,LA3_State,LA3_Status,LA3_HiddenUsCID,LA3_WebPage,LA3_Zip,LA3_AddressStreet,LA3_PhoneNumber1Desc,LA3_PhoneNumber2Desc,LA3_PhoneNumber3Desc,LA3_PhoneNumber4Desc,LA3_PhoneNumber5Desc,LM_char10_71,LM_char10_35,LM_Int4_3,LM_Int4_4,LFD_LEASEINCLUDES_84,LFD_LEASETERM_89,L_ClosingDate,L_SoldPrice,LM_char100_1,LM_char100_4,L_ListAgent1,L_ListingTeamId,L_ListingDate,LM_char100_5,L_ListOffice1,LM_int4_21,LM_Char1_2,LM_int4_22,LO1_board_id,LO1_Char10_3,LO1_BranchOfOrgID,LO1_OrgAddressStreet,LO1_ShortName,LO1_OrgAddress2,LO1_OrgCity,LO1_EMail,LO1_HiddenOrgID,LO1_Char50_1,LO1_OrganizationName,LO1_PhoneNumber1,LO1_OrgState,LO1_HiddenOtyID,LO1_WebPage,LO1_OrgZip,LO1_PhoneNumber1CountryCodeId,LO1_PhoneNumber1Desc,LO1_PhoneNumber1Ext,LO2_board_id,LO2_Char10_3,LO2_BranchOfOrgID,LO2_OrgAddressStreet,LO2_ShortName,LO2_OrgAddress2,LO2_OrgCity,LO2_EMail,LO2_HiddenOrgID,LO2_Char50_1,LO2_OrganizationName,LO2_PhoneNumber1,LO2_OrgState,LO2_HiddenOtyID,LO2_WebPage,LO2_OrgZip,LO2_PhoneNumber1CountryCodeId,LO2_PhoneNumber1Desc,LO2_PhoneNumber1Ext,LFD_LOCATION_138,LM_Char25_26,LM_Char10_25,LM_Int2_11,LM_Char1_14,LM_Int2_12,LFD_LOTDESCRIPTION_76,LM_Char50_4,LM_Int2_1,L_LvtDate,LM_Int4_10,LM_Char10_14,L_DisplayId,L_AskingPrice,LM_Char10_20,LM_char50_15,LM_char50_25,LM_char100_3,L_OffMarketDate,L_ListingsOffMarketStatusDate,LM_char1_23,L_ListAgent3,LM_char50_33,L_OriginalPrice,L_SellingAgent3,LM_char50_32,LM_Dec_8,LM_char10_32,LM_Char25_24,LM_Int4_20,LM_char10_36,LM_Int4_19,LM_Char25_15,LM_Int4_8,LM_char1_28,LM_Int1_12,LM_Char25_16,LM_Int1_9,LM_char1_25,LM_Int1_10,LM_char10_37,LM_Int4_13,LM_Char25_13,LM_Int4_14,LM_char10_38,LM_Int4_15,LM_Char25_14,LM_Int4_16,LM_char50_6,LFD_OWNERPAYS_87,LM_Char10_30,LM_char50_40,LM_Char50_1,L_ContractDate,LM_Dec_27,LM_char10_54,L_PictureCount,L_Last_Photo_updt,LM_char10_43,LM_char10_50,LM_Char1_17,LM_char50_9,L_PriceDate,L_PricePerSQFT,LM_Dec_32,LR_remarks44,L_Type_,LV_vow_include,LM_Int2_9,LM_Char1_13,LM_Int2_10,LR_remarks11,LM_Char25_8,LFD_ROOFMATERIAL_137,SA1_Address2,SA1_City,SA1_Email,SA1_UserFirstName,SA1_UserLastName,SA1_LoginName,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,SA2_Address2,SA2_City,SA2_Email,SA2_UserFirstName,SA2_UserLastName,SA2_UserMI,SA2_PhoneNumber1CountryCodeId,SA2_PhoneNumber1Ext,SA2_PhoneNumber1,SA2_PhoneNumber2CountryCodeId,SA2_PhoneNumber2Ext,SA2_PhoneNumber2,SA2_PhoneNumber3CountryCodeId,SA2_PhoneNumber3Ext,SA2_PhoneNumber3,SA2_PhoneNumber4CountryCodeId,SA2_PhoneNumber4Ext,SA2_PhoneNumber4,SA2_PhoneNumber5CountryCodeId,SA2_PhoneNumber5Ext,SA2_PhoneNumber5,SA2_State,SA2_Status,SA2_HiddenUsCID,SA2_WebPage,SA2_Zip,SA2_AddressStreet,SA2_PhoneNumber1Desc,SA2_PhoneNumber2Desc,SA2_PhoneNumber3Desc,SA2_PhoneNumber4Desc,SA2_PhoneNumber5Desc,SA3_Address2,SA3_City,SA3_Email,SA3_UserFirstName ... (more)

edit retag flag offensive close merge delete

Comments

RETS Status code = 20202: Invalid Select. Field [LM_char50_16] does not exist in Class [RR_5]. Step finished at 7/31/2018 5:27:18 AM

SmarterAget gravatar imageSmarterAget ( 2018-07-31 04:37:50 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-07-31 09:17:44 -0500

updated 2018-07-31 09:18:56 -0500

Can you verify this again. The field is disabled in Paragon for that class and I don't see it in the metadata for RR_5. It is also disabled for CL_7.

edit flag offensive delete link more

Comments

this can be closed out had to clear the metadata cache and remove the old metadata file.

SmarterAget gravatar imageSmarterAget ( 2018-08-01 07:52:38 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-07-31 04:37:18 -0500

Seen: 13 times

Last updated: Jul 31