topic Re: Store error in QlikView

Store error

ilanbaruch — Sun, 13 Mar 2016 13:38:25 GMT

hi all,

I have a qvd store process that runs daily, today I load it manually and got below error,

the script is:

SQL SELECT *

FROM ACCOUNTS;

STORE ACCOUNTS into $(vQVDPath)ACCOUNTS.qvd;

when I comment the STORE line it finishes the script with all the data, so I assume the problem is with the 'store' any ideas??

advanced thanks.

Re: Store error

sunny_talwar — Sun, 13 Mar 2016 13:57:58 GMT

Have you checked if you have writing access to that location? If you don't then you might not be able to save anything at that location

Re: Store error

Chanty4u — Sun, 13 Mar 2016 13:59:28 GMT

please chk the qvd path once.... may be any changes to ur folder path?

Re: Store error

swuehl — Sun, 13 Mar 2016 13:59:59 GMT

Check that the path exists and that the user running the script has the proper rights to access this folder and write to the file.

This error may also occur if the existing Accounts.qvd is locked by another process.

Re: Store error

ilanbaruch — Sun, 13 Mar 2016 14:00:06 GMT

i have, other QVD's it saves propertly.

Re: Store error

Chanty4u — Sun, 13 Mar 2016 14:03:11 GMT

close all working qvw's and and restrt ur system? and relaod once?

Re: Store error

ilanbaruch — Sun, 13 Mar 2016 14:03:56 GMT

thanks,

i checked it without the variable with full path as C:\QVD\accounts.qvd

still it wont work..

Re: Store error

Chanty4u — Sun, 13 Mar 2016 14:11:09 GMT

chk dis

Avoid General Script Error in STORE command

Re: Store error

Chanty4u — Sun, 13 Mar 2016 14:12:58 GMT

or else u can change the qvd name for both locations and reload again...

Re: Store error

Chanty4u — Sun, 13 Mar 2016 15:00:55 GMT

is it wrkng fyn? and what is the issue?

Re: Store error

ilanbaruch — Sun, 13 Mar 2016 15:03:15 GMT

closed QVW's and logged of all users,

logged on again, reload ...

fixed!

thank you a lot!

Ilan

Re: Store error

Chanty4u — Sun, 13 Mar 2016 15:05:27 GMT

Hmmm good.

Best

Suresh chanty