Ask Your Question
0

LM_char5_19 field to short needs 6 char for MF_5 pull lease term lookup

asked 2016-09-01 12:13:57 -0500

when running MF_5 update i hit an error.

LM_char5_19 has multiple options and one is SEASON for unit 5 lease term

but the field is a 5 char and is cutting of the end and then kicks the following error

ValueError: unknown XML element <element 'rets-status'="" at="" 0x8bb6840=""> with attributes {'ReplyText': 'Undecoded values were sent: Miscellaneous Search Error. Lookup: value SEASO not found in Lookup table U2LseTerm_Lkp_5 for Resource 1. [LM_char5_19] ', 'ReplyCode': '20203'}

it will break on all the other lseTerm_Lkp fields for the other units also

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2016-09-06 15:07:08 -0500

This issue has been fixed. The new field name for "Unit 5 Lease Term" is: LM_char10_63.

edit flag offensive delete link more

Comments

Still Seeing: Request: SearchType=Property&Class=MF_5&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(L_ListingID=0%2B)&Select= RETS Status code = 20203: Undecoded values were sent: Miscellaneous Search Error. Lookup: value SEASO not found in Lookup table U2LseTerm_Lkp_5 for Resource 1. [LM_char5_19]

darensanborn gravatar imagedarensanborn ( 2016-09-09 09:04:39 -0500 )edit

this field needs to be removed from the mf_5 table as it is still trying to do look up.

bscdata gravatar imagebscdata ( 2016-09-09 12:26:05 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-09-01 12:13:57 -0500

Seen: 42 times

Last updated: Sep 06 '16