Ask Your Question

stan.longhofer's profile - activity

2017-06-06 23:22:11 -0500 received badge  Notable Question (source)
2017-05-04 15:49:45 -0500 received badge  Popular Question (source)
2017-04-18 11:03:08 -0500 commented answer Topeka (Sunflower) Metadata Errors

Just following up. The errors listed here are still happening. When will the metadata refresh be completed?

2017-04-18 10:59:17 -0500 received badge  Editor (source)
2017-04-18 10:58:11 -0500 asked a question Metadata Error

Good Morning. Last weekend I started receiving the error below attempting to access the Manhattan Kansas MLS data using RETS Connector. I believe a metadata refresh may be required.

Thanks.

Task name: 'Manhattan'
Start time: 4/18/2017 10:53:00 AM
Server time: Tue, 18 Apr 2017 15:52:59 GMT
Time spent: 00:01:42.1029213
Status: FAILED
Copy of logfile in "Manhattane_Download.log":
      Resuming task "Manhattan"

Server: http://manhattan.rets.paragonrels.com... User name: WichitaState Full pull Local time: 4/18/2017 10:53:00 AM Server time: Tue, 18 Apr 2017 15:52:59 GMT

Running step "All Residential Data"

Data file: Manhattan_RETSDownload.txt Search query: (L_ListingID=0+) 2500 records downloaded Error detected: server failed the request Request: SearchType=Property&Class=RE_1&Format=COMPACT-DECODED&QueryType=DMQL2&Query=(L_ListingID=0%2B)&Select= RETS Status code = 20203: RETS undecoded lookup values found! Resource [1], Class [1]: SystemName [L_Area], LookupName [Area], Value [124] not found. SystemName [L_Area], LookupName [Area], Value [123] not found. SystemName [L_Area], LookupName [Area], Value [125] not found.

Step finished at 4/18/2017 10:54:41 AM
2017-04-14 17:14:31 -0500 received badge  Popular Question (source)
2017-04-10 13:31:46 -0500 received badge  Famous Question (source)
2017-04-07 17:10:10 -0500 received badge  Notable Question (source)
2017-04-06 16:47:07 -0500 received badge  Popular Question (source)
2017-04-04 12:38:37 -0500 asked a question Topeka (Sunflower) Metadata Errors

You merged a former Rapattoni system into the Topeka MLS last week (the new name is the Sunflower MLS). There was a metadata update after the merger, but I am still having problems with undecoded lookup values from the following fields:

L_City, LM_Char10_12, LM_Char10_13 and LM_Char10_14

These last three fields relate to school information.

I believe the metadata needs to be refreshed again. Thanks.

Server: http://topekamls-rets.paragonrels.com...

User name: topekastats

2017-04-04 12:32:23 -0500 asked a question MidKansas MLS Metadata Errors

I believe this system needs a metadata refresh or to have the fields below cleaned of invalid data. Thanks.

Server: http://midkansas.rets.paragonrels.com...

User name: 423005034

Error Message:

RETS Status code = 20203: RETS undecoded lookup values found! Resource [1], Class [1]: SystemName [LM_Char25_6], LookupName [LimitList_Lkp_1], Value [2 at $350 each] not found. SystemName [LM_Char25_6], LookupName [LimitList_Lkp_1], Value [550 & 565] not found. SystemName [LM_Char25_5], LookupName [HOA1_Lkp_1], Value [1/$325] not found. SystemName [LM_Char25_6], LookupName [LimitList_Lkp_1], Value [1/$450] not found. SystemName [LM_Char25_6], LookupName [LimitList_Lkp_1], Value [2] not found. SystemName [LM_Char25_6], LookupName [LimitList_Lkp_1], Value [$700 each side] not found. SystemName [LM_Char25_6], LookupName [LimitList_Lkp_1], Value [3/$425] not found. SystemName [LM_Char25_6], LookupName [LimitList_Lkp_1], Value [575.00 & 565.00] not found. SystemName [LM_Char25_5], LookupName [HOA1_Lkp_1], Value [8/$409 avg] not found. SystemName [LM_Char25_5], LookupName [HOA1_Lkp_1], Value [8/$384 avg] not found. SystemName [LM_Char25_5], LookupName [HOA1_Lkp_1], Value [350.00/330.00] not found. SystemName [LM_Char25_6], LookupName [LimitList_Lkp_1], Value [425.00] not found. SystemName [LM_Char25_6], LookupName [LimitList_Lkp_1], Value [750.00] not found. SystemName [LM_Char25_5], LookupName [HOA1_Lkp_1], Value [3@325] not found. SystemName [LM_Char25_5], LookupName [HOA1_Lkp_1], Value [(2)$350 $215] not found. SystemName [LM_Char25_5], LookupName [HOA1_Lkp_1], Value [1/$350] not found.

2017-03-27 09:19:29 -0500 received badge  Famous Question (source)
2017-03-17 15:56:12 -0500 received badge  Notable Question (source)
2017-03-17 15:56:12 -0500 received badge  Popular Question (source)
2017-03-13 11:51:52 -0500 asked a question SCKMLS data errors

Good Morning -

I'm trying to access the South Central Kansas MLS using RETS Connector. I've been receiving two lookup table errors:

  • Miscellaneous Search Error. Lookup: value CTYARDAUB not found in Lookup table SUBDIVN_Lkp_1 for Resource 1. [LM_Char10_18]
  • Miscellaneous Search Error. Lookup: value K not found in Lookup table State for Resource 1. [L_State]

The first appears to be a missing entry in the metadata. The second appears to be a data entry problem: The affected listings should have L_State = "KS".

Server: http://sckmls.rets.paragonrels.com/re... User name: RETS_74

Thanks.

2016-08-31 11:58:54 -0500 received badge  Famous Question (source)
2016-08-01 08:55:01 -0500 commented answer RETS Status Code 20203 TOPEKAMLS

Good Morning. Hate to say it, but the issue has come back: Error detected: server failed to send data at offset 50001 RETS Status code = 20203: Undecoded values were sent: Miscellaneous Search Error. Lookup: value Prairie Hi not found in Lookup table Subd_Lkp_1 for Resource 1. [LM_Char10_10]

2016-08-01 08:49:24 -0500 received badge  Famous Question (source)
2016-07-14 08:11:54 -0500 received badge  Notable Question (source)
2016-07-13 06:33:46 -0500 commented answer RETS Status Code 20203 TOPEKAMLS

Thanks. The 7/12/16 refresh appeared to fix the issue. I was able to download the decoded values. This did NOT fix the problem I am having with ODBC access, but I will simply change my process to use RETS Connector instead. Thanks again.

2016-07-12 14:45:13 -0500 received badge  Notable Question (source)
2016-07-08 08:20:31 -0500 received badge  Popular Question (source)
2016-07-06 15:48:22 -0500 commented question RETS Status Code 20203 TOPEKAMLS

I'm afraid I get errors with more Lookup Tables not. I sent a copy of the log to the e-mail address that was associated with this comment.

2016-07-06 08:56:01 -0500 commented question RETS Status Code 20203 TOPEKAMLS

Thanks, but I'm afraid just tried a download and I got the exact same error:
RETS Status code = 20203: Undecoded values were sent: Miscellaneous Search Error. Lookup: value 1034A not found in Lookup table Subd_Lkp_1 for Resource 1. [LM_Char10_10] FYI, I did change the server version to 1.7.2

2016-07-05 15:28:48 -0500 commented question ODBC Access to RETS Server

I did save full log files from ezRETS if you want to see them. Is there a way to attach them here?

2016-07-05 15:28:24 -0500 commented question ODBC Access to RETS Server

I tried using the corrected URL that you suggested in my other question in my ezRETS setup to try the ODBC access. I also tried updating to RETS version 1.7.2. In both cases, when I test the connection in the Windows driver setup, I am able to login, but I get the same error in Stata.

2016-07-05 15:01:39 -0500 commented answer RETS Status Code 20203 TOPEKAMLS

Great. Thank you very much. I've found 1.7.2 more reliable generally.

2016-07-05 14:21:45 -0500 asked a question RETS Status Code 20203 TOPEKAMLS

Hello -

I am trying to use RETS Connector to access the Topeka MLS data. I'm getting the following error when I try to download decoded data:

Server: http://topekamls.rets.fnismls.com/ret... User name: topekastats Full pull Local time: 7/5/2016 2:13:59 PM Server time: Tue, 05 Jul 2016 19:14:01 GMT

Running step "Full Download"

Data file: C:\Users\s352u532\Documents\Stata\MLS\RETSConnector\Topeka_RETSDownload1.txt Search query: (L_ListingID=0+) 6000 records downloaded Error detected: server failed to send data at offset 4001 RETS Status code = 20203: Undecoded values were sent: Miscellaneous Search Error. Lookup: value 1034A not found in Lookup table Subd_Lkp_1 for Resource 1. [LM_Char10_10]

Based on other posts, it appears that the Metadata need to be refreshed. Is this something you YOU do or do I need to contact the local MLS administrator to have this done?

Thank you for your prompt response.

2016-07-05 06:53:37 -0500 received badge  Popular Question (source)
2016-07-01 10:33:09 -0500 asked a question ODBC Access to RETS Server

I prepare monthly statistical reports for the a local MLS system. I access their data through a RETS feed that I access using Online Database Connectivity (ODBC) with the ezRETS ODBC driver. Using this driver, I directly import the data into my statistical software program (Stata 14.1). This has been working fine up until last night.

Now, when I try to access the server through my statistical software, it appears that it is not logging into the RETS server. When query the data, I get the following error message:

The ODBC driver reported the following diagnostics Unable to connect: XML parse error at 3:61: not well-formed (invalid token) SQLSTATE=08001 Could not log into server. SQLSTATE=08001

I tried to diagnose this by testing the login on my ezRETS setup; the test login is working fine.

I also confirmed that I am still able to use my statistical software to access other Paragon based MLS systems that I help. Every other MLS system I serve that uses the FNIS/Paragon server is still working correctly.

Next I tried to connect to the system using ODBC in Excel; here, too, it is unable to login to the server (although it DOES work for other MLS servers).

Once again, it appears that when I try to use an application to access the RETS server I am unable to login, even though I successfully do so in the ODBC Data Source Administrator setup. I use the same process to access data for other MLS systems that use Paragon, and all of these connections are working just fine. The only problem is with this one system, and the problem just arose recently.

Any assistance you could give would be greatly appreciated.

Thank you in advance.