Qlik Sense, I get load error -129 when reloading app

ZimaBlue — Mon, 20 Mar 2023 09:20:01 GMT

Hello!

So, I have a very simple script and join, which is even simpler. I have several fields with the same name and 2 that I want to join. However, I get this error every time: error 129.

Any tips on how to make qlik sense work? Did I make a mistake somewhere?

my script is:

keywords_sub:
LOAD
reg_cohort as k_reg_cohort,
partner_name as k_partner_name,
ad_id as k_ad_id,

keyword as k_keyword,
request_url as k_request_url
FROM [qvd name]
(qvd);

main_data:
LOAD
"date",
monthname("date") as reg_cohort,
partner_name,
campaign,
ad_group_id,
ad_id,
ad_group_name,
ad_name,
date_rank,
user_id

FROM [qvd2 name]
(qvd);

//--------------
left join (main_data)
LOAD
k_keyword,
k_request_url,

k_reg_cohort as reg_cohort,
k_partner_name as partner_name,
k_ad_id as ad_id
resident keywords_sub;

drop tables keywords_sub;

Re: load error 129

vidyutverma — Thu, 28 Jul 2022 18:36:00 GMT

Error 129 may be due to the join taking large amount of RAM and failing thereafter. (https://community.qlik.com/t5/Knowledge/Error-129-or-128-when-reloading-app/ta-p/1713809)
Try using a small dataset and checking if your joins are behaving as expected.

Re: load error 129

ZimaBlue — Fri, 29 Jul 2022 15:21:23 GMT

thank you!

topic Qlik Sense, I get load error -129 when reloading app in App Development

Qlik Sense, I get load error -129 when reloading app

Re: load error 129

Re: load error 129