First time here? Check out the FAQ!
0

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

  • retag add tags

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

bscdata's avatar
bscdata
asked 2016-09-01 12:13:57 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

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

bwolven's avatar
bwolven
answered 2016-09-06 15:07:08 -0500
edit flag offensive 0 remove flag delete link

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's avatar darensanborn (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's avatar bscdata (2016-09-09 12:26:05 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer