System.OutOfMemoryException thrown on JSONTABLE with Twinfield BI-ON-Focus

Vragen
,
8

In Query Tool 20.0.145 is dit de foutcode:

itgenclr007: Application is using more memory than available. Restarting the application, use 64-bit Windows and Office or making more memory available might resolve this problem.

Er is een uitzondering opgetreden van het type System.OutOfMemoryException.

Message ID: bfce3548-93c8-4975-9d88-7256e2a86aaf

Occurred (UTC): 21-4-2021 08:31:04

create or replace table xyz@inmemorystorage
    as
    select dta.*
    from   httpdownload@datadictionary
           ( url => 'https://twinfield.[jeweetwelkepartij].nl/general-ledger-details?type=frozen'
           , contentType => 'application/json'
           , headers => 'Authorization=Basic%20' || urlencode(base64_encode(ascii_to_blob([auth_code])))
           ) htp
    join   jsontable
           ( '[*][*]'
             passing htp.content_clob
              columns   divisionname          varchar2 path '[''Company name'']'
              ,         financialyear         varchar2 path '[''Year'']'
              ,         financialperiod       varchar2 path '[''Period'']'
           ) dta

Het bestand is ruim 1 GB:

curl -i -H "Authorization: Basic [auth_code]" https://twinfield.[jeweetwelkepartij.nl/general-ledger-details?type=frozen > c:/temp/test.json
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 1079M    0 1079M    0     0  5341k      0 --:--:--  0:03:27 --:--:-- 6223k