Incremental load help for QVD Gen

[amit_saini]

Hi Folks,

Attached is our QVD Gen from one of our support team , which is some how complicated (Use of variables).

I have tried few things in order to do incremental load on generated qvd's , but failed to do so.

Currently I believe this is doing full load in each trigger and storing qvd's. See below:

I'm looking for a solution where I can do incremental load on generated qvds, can't wait for 2 hours for new data.

I tried so many things based on comments from developer at script side , but still no success .

Please suggest what is the best possible way for incremental load.

Thanks,

AS

[rwunderlich]

It was a pleasure meeting you as well and thanks for the picture.

The incremental load portion of your script is conditionally executed by the test:

if $(ReloadAllData) = 0 then

The ReloadAllData variable is set to 1, so the else/full load is executed.

Change the value of ReloadAllData in the input box to 0.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[amit_saini]

Hi Rob,

This is what suggested by developer, see below:

But this change is not working at all.

Attached is log file.

Thanks,

AS

[rwunderlich]

it looks like the directory

STORE ARTIKEL INTO D:\qvprod\Operation\Prisma Report Palau\#Source\Qvd\ARTIKEL_R.qvd (qvd)

does not exist?

-Rob

[amit_saini]

Hi Rob,

Here it is:

Thanks,

AS

[stabben23]

Hi Amit,

Is 😧 on Your local computer? if not, you need to use the path to the server where it is placed,

\\servername\qvprod\Operation\Prisma Report Palau\#Source\Qvd\ARTIKEL_R.qvd (qvd).

the scrip error can also depend on that the user who runs the script doesent have Write permissions to the folder/file.

The file could also be occupied by another process

[amit_saini]

Hi Staffan,

Thanks for input!

This suggestion already has been checked , before introducing issue here.

Thanks,
AS

[stabben23]

Ok,

have a look here then; I cant find 2 of Your Variables in Your script.

multilanguage=  no value

Last_Updated_Date = No value

both is used in script.

[rwunderlich]

It appears to be some type of file system error since it happens after the STORE. File in use? Try putting [] around the path,

-Rob

[amit_saini]

Hi Rob,

Yes with [] it took only 15 seconds for load (When errormode set =0)

Looking into log file , looks to me we are having some table issue , could you please have a look on the attachment and suggest what's wrong.

Thanks,

AS

[rwunderlich]

I think you need to go back to the developer of the script. I see the error

Error: Field not found - <DTUPDATE>

The script assumes that the QVDs contain a field called DTUPDATE.

-Rob