Not Enough Storage VBA - JSON

[mnaveedraza]

Hi ,

Thank you so much making this JSON Converter. This helps.
However, there were couple of challenges while parsing the JSon data for more than 1 Lakh Records.
Issue 1: "Run Time error for "Not enough storage is available to complete this operation" at this line
Set JS = JsonConverter.ParseJson(http.responsetext)
Issue 2: Unable to extract field names from JSON data. Can you pls help me on how we can do this.

Regards,
Naveed Raza

[Steve184]

Hi,

JSON Converter is a great library ! It's been working like a charm in one of my programs for every minute of everyday for the past 3 months.

A week or two I also started to encounter the memory issue
"Run Time error for "Not enough storage is available to complete this operation" at this line
Set JS = JsonConverter.ParseJson(http.responsetext)

The program now works 70% of the time. In 30% occasions, it freezes and raises the memory issue.

I have tried everything with no luck (upgrading version, modify options, etc). The only way to restart the program is to kill the process in the task manager... Might be linked to recent windows updates ?

Any idea of what is going on ?

Many thanks for your help !

Steve

[timhall]

I expected this to be an issue with ConvertToJson since that's creating large strings in memory, but for ParseJson I'm not sure what could be causing it. There is some manual memory management with parsing strings that I had thought about adding a switch for in case it was causing an issue like this, will have to look into further.