NEREN Data Pull - Lookup value not found errors

asked 2016-08-25 19:03:30 -0500

darensanborn

updated 2016-08-30 19:23:42 -0500

I'm working on the transition for a client for the NEREN data pull.

I'm using the RETS Connector application.

Doing different pulls in several property types, I'm getting similar errors related to lookup values not being found.

Below is the error message when trying to do a one-time pull of all the residential listings with 3 bedrooms.

I'm getting similar errors when trying to pull multi-families, rentals, other residentials and even open houses.

Please advise. I'm happy to upload more error messages if needed.

Daren Sanborn

============================== Search query: (LM_Int1_6=3) 2500 records downloaded Error detected: server failed the request Request: SearchType=Property&Class=RE_1&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(LM_Int1_6=3)&Select= RETS Status code = 20203: Undecoded values were sent: Miscellaneous Search Error. Lookup: value PLYRM not found in Lookup table Rm22Level_Lkp_1 for Resource 1. [LM_char5_11] Miscellaneous Search Error. Lookup: value SUNRM not found in Lookup table Rm18Level_Lkp_1 for Resource 1. [LM_char5_31]

edit retag flag offensive close merge delete

add a comment

0

answered 2016-08-30 19:21:23 -0500

darensanborn

updated 2016-08-31 11:01:05 -0500

bwolven

http://paragonconnect....

I have notified the SSM who will schedule a RETS Metadata Refresh.

Update 2016-08-31 11:05 CST - I was informed that a refresh was done on 8/30 so the lookup values should be good now. Let us know if you are still having issues.

edit flag offensive delete link

Comments

I fully reloaded the cache and I'm still getting the same LOOKUP errors.

Here is an example:

Miscellaneous Search Error. Lookup: value LIBRY not found in Lookup table Rm18Level_Lkp_1 for Resource 1. [LM_char5_31] Miscellaneous Search Error. Lookup: value EXERC not found in Lookup table Rm22Level_L

darensanborn ( 2016-08-31 16:36:05 -0500 )edit

add a comment

0

answered 2016-09-01 15:30:42 -0500

L.Cobb

Hi Daren, We found the inaccurate data and are working to remove it now. I expect it should all be corrected tomorrow. Thank you for following up on this item to be sure we have the system in good working order.

edit flag offensive delete link

Comments

I'm still seeing the same lookup errors which is preventing me from pulling all the test data. Would it help if I paste in all the lookup errors I'm getting?

darensanborn ( 2016-09-02 09:32:19 -0500 )edit

i am having the same issue the specific was field lenght error, and gave example of multi family lease term fields set to 5 char when need at min 6, Miscellaneous Search Error. Lookup: value SEASO not found in Lookup table U2LseTerm_Lkp_5 for Resource 1. [LM_char5_19] ', 'ReplyCode': '20203'}

bscdata ( 2016-09-02 11:38:21 -0500 )edit

also finding lookup error ROYER,RECRM,WRKSH,GREAT,PLYRM,LOFT,KITCH not found in lookup table Rm22Level_Lkp_1 for Resource 1.[LM_char5_11]

njsent ( 2016-09-03 17:15:15 -0500 )edit

We corrected the bad data in both lookup fields. Please let us know if you continue to see any similar errors. Thanks.

L.Cobb ( 2016-09-06 08:34:10 -0500 )edit

Residentials all look good now. I'm still seeing lookup errors in Multi-Family and Rentals, however.

darensanborn ( 2016-09-07 22:48:32 -0500 )edit

add a comment

NEREN Data Pull - Lookup value not found errors

2 Answers

Comments

Comments

Question Tools

Stats

NEREN Data Pull - Lookup value not found errors edit

2 Answers

Comments

Comments

Question Tools

Stats

NEREN Data Pull - Lookup value not found errors