QVD are not updated from incremental load

[Aria]

I create a QVD file from one application and load the data of one specific day(2021/05/23):

[inventory_v1]:
LOAD
"CALDAY",
"ZBASE_UOM___T",
"ZBASE_UOM",
"ZCUSTOMERNAM",
"ZSALESORDER";

SQL SELECT "CALDAY",
"ZBASE_UOM",
"ZBASE_UOM___T",
"ZCUSTOMERNAM",
"ZSALESORDER"
FROM "_SYS_BIC"."WLBI2.AL.MM/CVC_MM_STOCKAGE_SALES"
('PLACEHOLDER' = ('$$IN_QUERYDATE$$', '20210523'));
Store inventory_v1 into [lib://ibmQVD (qlik-pro_ibm.aria)/inventory_v1.qvd](qvd);

Then I create another application for conducting the incremental load into the inventory_v1.qvd:

let vDAY = Date(Today()-1,'YYYYMMDD');

[inventory_v2]:
LOAD
"CALDAY",
"ZBASE_UOM___T",
"ZBASE_UOM",
"ZCUSTOMERNAM",
"ZSALESORDER";

SQL SELECT "CALDAY",
"ZBASE_UOM",
"ZBASE_UOM___T",
"ZCUSTOMERNAM",
"ZSALESORDER"

FROM "_SYS_BIC"."WLBI2.AL.MM/CVC_MM_STOCKAGE_SALES"
('PLACEHOLDER' = ('$$IN_QUERYDATE$$', '$(vDAY)'));

Concatenate
Load * from [lib://ibmQVD (qlik-pro_ibm.aria)/inventory_v1.qvd](qvd) where CALDAY <> $(vDAY);

Store inventory_v2 into [lib://ibmQVD (qlik-pro_ibm.aria)/inventory_v1.qvd](qvd);

What I expecting is the data will be loaded into the QVD file on a daily basis and the QVD file should have the data of everyday starting from 2021/05/23.

Yet what I got is only the data of 2021/05/23 and the data of yesterday. For example: today is 5/27, the qvd file has the data of 5/23 and 5/26 without the data of 5/24 and 5/25

Why this happened? How can I fix this?

Thanks a lot !!

[MayilVahanan]

HI @Aria 

I create a QVD file from one application and load the data of one specific day(2021/05/23)

-- Are you loading this file daily?

[Aria]

Yes, through the variable: vDAY defined in the second application.

[Aria]

Sorry my misunderstanding. No only the second application are loading on a daily basis. The first application has only been loaded once.

[MayilVahanan]

Its looks like script is fine .. If you have daily schedule, I think, its work fine. 

Or, you can debug the script once or check the log.

And also, Am not sure what this part will do.

('PLACEHOLDER' = ('$$IN_QUERYDATE$$', '$(vDAY)'));

[Aria]

where can I see the log please?

[MayilVahanan]

Hi @Aria 

in QMC-> Task->Status 

You can download from here