PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Diagnosing error 17 on dim load of json data  (Read 1409 times)

Allen Miglore

  • Silver Member
  • ***
  • Posts: 38
    • View Profile
    • UnForm
Diagnosing error 17 on dim load of json data
« on: May 29, 2019, 03:03:22 PM »
I am trying to parse a fairly large json response from a web service, and just installed the very latest pxplus 2019 to test with. 

Scanning the json string as best I can visually (it's about 2.5mb), I don't see anything but simple json objects, arrays, strings, and numbers (no nested arrays, for example, which have caused errors for me before).  The json does pass validation at jsonlint.com.  But I get an error 17 when trying to use 'dim load' on it.

Is anyone aware of a system variable or tcb() function or whatever that would provide any hint about where in the string the error occurs?

If anyone wants to look at the json, it is here:

https://unform.com/download/test.05292019.json


Mike King

  • Diamond Member
  • *****
  • Posts: 3811
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Diagnosing error 17 on dim load of json data
« Reply #1 on: May 29, 2019, 03:32:18 PM »
You have floating point values (n.nnnnne+-n) which our JSON converter does not like as it assume numeric data is composed of 0-9, ., plus sign.

Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com

Allen Miglore

  • Silver Member
  • ***
  • Posts: 38
    • View Profile
    • UnForm
Re: Diagnosing error 17 on dim load of json data
« Reply #2 on: May 29, 2019, 03:55:39 PM »
Thanks, Mike.

Mike King

  • Diamond Member
  • *****
  • Posts: 3811
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Diagnosing error 17 on dim load of json data
« Reply #3 on: May 29, 2019, 04:31:08 PM »
Just an FYI -- I just added this to be addressed with the next release.
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com