Web Connectors - Microsoft Dynamics CRM: Failed to allocate a managed memory buffer of 67108864 bytes. The amount of available memory may be low
Article Number: 000051495 | Last Modified: 2018/11/21
Using Qlik Microsoft Dynamics CRM Web Connector and in cases of large amount of data that needs to be retrieved by the Qlik Web Connector, a user may end up with the following error:
Failed to allocate a managed memory buffer of 67108864 bytes. The amount of available memory may be low.
This message error could be present on Qlik Sense or Qlik View side, but not on Web Connector UI as it is fetching / filtering always the first 5000 results.
This error occurs due to resources (network, database, etc.) and a quick workaround is to either enable paging from the database side (in case that this is supported by the db), either handle this on a script level with a loop and get chunks of data (eg, for 1 million rows to 4 loops, skipping every time the 250.000 previous results and as long as they exist results - so the total amount of rows / data needs to be calculated first)