topic Re: Incremental Update Script [Store] in QlikView

Incremental Update Script [Store]

Thu, 20 Feb 2014 22:06:04 GMT

Hi All,

While building an incremental qvd I am facing a problem near last step which is at Store table step :

STORE Salesorder INTO ;

I am sure that it is at that step because when I change the Qvd file name it works. Is my QVD locked or something?

Please help me out of this problem.

Thanks,

Thu, 20 Feb 2014 22:46:07 GMT

Hi,

Do you get any errors when writing to a qvd? What does the error say?

Is there a qvd that already exist with the same name. In that case if any other file is writing to it then you might get an error.

Thanks

Thu, 20 Feb 2014 23:17:46 GMT

Thanks for your reply AJ..

unfortunately I didn't get any error while building the qvd. I even checked the log file and found this line after store command:

21/02/2014 8:54:28 AM: 0346 STORE Salesorder INTO

21/02/2014 8:54:34 AM: General Script Error

21/02/2014 8:54:34 AM: Execution Failed

21/02/2014 8:54:34 AM: Execution finished.

Yes there is a qvd that exists and I am updating the qvd using this incremental script.

Thanks,

Anonymous — Thu, 20 Feb 2014 23:20:56 GMT

MC-

Take a look at this discussion:

Hope this helps.

Sean

Thu, 20 Feb 2014 23:36:17 GMT

How to delete my qvd using the script automatically as I do not want to delete the qvd manually everyday for the incremental update.

I would like to know how this is working for people using incremental script.

Can someone please post your script.

Thanks,

Fri, 21 Feb 2014 00:35:36 GMT

If you can post your script it will be helpful for debugging the code.

Fri, 21 Feb 2014 00:47:32 GMT

Thank you all..Fixed the issue finally

changed the store script line

to STORE Salesorder INTO 'C:\Data\Qvd\SalesOrderAll.qvd'(qvd);

Cheers,