topic QVD Implement Load in QlikView

QVD Implement Load

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can someone please tell me why my implement load keep failing? Even when I comment out the variable vLastRunTime and the QVDs to implement load on and just store small table QVDs....it still fails. I'm attaching my scripting for the QVDs.

Any help would be appreciated.

Thanks in Advance,

Re: QVD Implement Load

satishkurra — Mon, 28 Mar 2016 15:46:22 GMT

As we cannot reload the file, could you please help us in understanding what is the error it throws...

Re: QVD Implement Load

Mon, 28 Mar 2016 15:52:47 GMT

Hi,

Thanks for the reply. It doesn't even reload the first table correctly.

Re: QVD Implement Load

sunny_talwar — Mon, 28 Mar 2016 15:52:56 GMT

Are you talking about Incremental load?

Re: QVD Implement Load

Chanty4u — Mon, 28 Mar 2016 15:54:30 GMT

please post ur error?

Re: QVD Implement Load

sunny_talwar — Mon, 28 Mar 2016 15:54:57 GMT

Check if this is a valid location

$(vQVDLocation) -> ..\Data

Re: QVD Implement Load

Mon, 28 Mar 2016 16:05:45 GMT

Hi,

For the large tables I'm doing a incremental load but for the small tables I'm doing a regular QVD storage.

Even after changing the QVD location it still gives error.

Re: QVD Implement Load

sunny_talwar — Mon, 28 Mar 2016 16:09:12 GMT

Can you try this:

LET vLastRunTime = Date(Today(), 'DD-MMM-YYYY');

ODBC CONNECT TO ExcessionProd;

CustomerCuration:

SQL SELECT *

FROM "rbc_dw"."open".dim1customercuration

Where updatedate > '$(vLastRunTime)';

Concatenate(CustomerCuration)

LOAD *

FROM

(qvd)

where not exists (pkdim1customercuration);

STORE CustomerCuration INTO CustomerCuration.qvd (qvd);

This will save the QVD in the same location as your QVW. If this works, then I would check if you have write access to the other locations.

Re: QVD Implement Load

satishkurra — Mon, 28 Mar 2016 16:10:34 GMT

Please check manually if the below statement is returning any results from DB.

SELECT *

FROM "rbc_dw"."open".dim1customercuration

Thanks

Satish

Re: QVD Implement Load

Kushal_Chawda — Mon, 28 Mar 2016 16:15:56 GMT

try changing all store commands. Remove '\'

STORE INTO $(vQVDLocation)CustomerCuration.qvd;

if not working put the store path manually like below

STORE INTO D:\Data\CustomerCuration.qvd;

Re: QVD Implement Load

Anonymous — Mon, 28 Mar 2016 16:16:40 GMT

May sound weird this, but try putting a Sleep(9000) after the STORE.

Re: QVD Implement Load

Mon, 28 Mar 2016 16:18:25 GMT

Thanks Sunny. This script doesn't give an error but it's not loading the latest data from the database. The database shows a total count of customercuration table 295K rows while the below shows 293K rows.

Re: QVD Implement Load

sunny_talwar — Mon, 28 Mar 2016 16:23:54 GMT

I guess that goes back to the issue that you have specified the variable before the incremental load, while I think you should do it at the end of the script to give it a value for next time onwards. I have probably mentioned this before as well, but try this:

One Time:

CustomerCuration:

SQL SELECT *

FROM "rbc_dw"."open".dim1customercuration;

LET vLastRunTime = Date(Today(), 'DD-MMM-YYYY');

Incremental:

ODBC CONNECT TO ExcessionProd;

CustomerCuration:

SQL SELECT *

FROM "rbc_dw"."open".dim1customercuration

Where updatedate > '$(vLastRunTime)';

Concatenate(CustomerCuration)

LOAD *

FROM

(qvd)

where not exists (pkdim1customercuration);

STORE CustomerCuration INTO CustomerCuration.qvd (qvd);

LET vLastRunTime = Date(Today(), 'DD-MMM-YYYY');

NOTE: The position of the variable -> vLastRunTime is at the bottom of the script and not at the top while doing the incremental load. This is very very important thing to note, if you don't follow this, the results are more likely then not going to deviate.

Re: QVD Implement Load

Mon, 28 Mar 2016 16:28:19 GMT

Can you try deleting .qvd from the location and try the reload?

Re: QVD Implement Load

Mon, 28 Mar 2016 16:43:35 GMT

Thanks guys for all your help but it's still providing me with the number of rows I had from last week. Sunny I've tried placing the vLastRunTime variable towards the end of my script but still no fruition.

Re: QVD Implement Load

sunny_talwar — Mon, 28 Mar 2016 16:45:52 GMT

For just one time, can you try this:

LET vLastRunTime = Date(Today()-1, 'DD-MMM-YYYY');

ODBC CONNECT TO ExcessionProd;

CustomerCuration:

SQL SELECT *

FROM "rbc_dw"."open".dim1customercuration

Where updatedate > '$(vLastRunTime)';

Concatenate(CustomerCuration)

LOAD *

FROM

(qvd)

where not exists (pkdim1customercuration);

STORE CustomerCuration INTO CustomerCuration.qvd (qvd);

Re: QVD Implement Load

Mon, 28 Mar 2016 16:58:53 GMT

Thanks Sunny for the response.

Re: QVD Implement Load

Mon, 28 Mar 2016 17:25:57 GMT

Didn't work Kush141087.

Re: QVD Implement Load

sunny_talwar — Mon, 28 Mar 2016 17:49:46 GMT

What do you get for this?

CustomerCuration:

SQL SELECT *

FROM "rbc_dw"."open".dim1customercuration;

Re: QVD Implement Load

Mon, 28 Mar 2016 18:06:24 GMT

I get 184 rows.