Receive 'ErrorCode.4004' in connection with INTERVALMATCH

[Christiann]

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

[mpc]

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

[Liam-Grant]

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