topic Receive 'ErrorCode.4004' in connection with INTERVALMATCH in App Development

Receive 'ErrorCode.4004' in connection with INTERVALMATCH

Christiann — Tue, 30 Jul 2024 09:48:33 GMT

Hi,

I'm trying to assign a date (only one line in the calendar) to a period (approx. 400,000 lines) with the following statement:

LEFT JOIN ( MyDataTable ) INTERVALMATCH ( Date ) LOAD
DateFrom,
DateTo
RESIDENT MyDataTable;

and get the error message 'ErrorCode.4004' (not more).

Any idea and solution about this?

Best regards

Christian

Re: Receive 'ErrorCode.4004' in connection with INTERVALMATCH

mpc — Wed, 31 Jul 2024 13:44:46 GMT

Hi,

No information here unfortunately: https://qlik.dev/apis/json-rpc/qix/errors/

Can you provide Engine logs if you are in Qlik Sense Client-Managed ?

Kind regards

Re: Receive 'ErrorCode.4004' in connection with INTERVALMATCH

Liam-Grant — Tue, 10 Sep 2024 15:48:19 GMT

I also had this issue with a large dataset (~8 million rows) while attempting an interval match. I reduced the data down to 1 million rows and instead got this error:

Out of object memory The request exceeds the memory limit.

I instead used the following solution instead of IntervalMatch:

left join (Vacation) load StartDate ,EndDate ,autonumber(StartDate & '-' & EndDate) as DateRangeId resident Vacation; VacationToDate: load distinct DateRangeId, StartDate + IterNo() - 1 as Date resident Vacation while StartDate + IterNo() - 1 <= EndDate;

Thanks to this post: Avoiding a gigantic intervalmatch - Qlik Community - 164252