Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
My script worked fine for a long time but today it decided to strike.
Here is the log:
...
9/30/2015 3:39:25 PM: | 4 fields found: Date, PNo,Cost,REGION, 15,787 lines fetched |
9/30/2015 3:39:25 PM: 0291 Directory
9/30/2015 3:39:25 PM: 0292 REV:
9/30/2015 3:39:25 PM: 0293 LOAD Date,
9/30/2015 3:39:25 PM: 0294 PNo,
9/30/2015 3:39:25 PM: 0295 sum(REVAmt) as REVAmt,
9/30/2015 3:39:25 PM: 0296 REGION
9/30/2015 3:39:25 PM: 0297 FROM
9/30/2015 3:39:25 PM: 0298
9/30/2015 3:39:25 PM: 0299 Group by Date,PNo,REGION
9/30/2015 3:39:25 PM: General Script Error
9/30/2015 3:39:25 PM: Execution Failed
9/30/2015 3:39:25 PM: Execution finished.
I have no idea because the script check doesn't find any error. And the file path is correct.
Thank you for your help!
Michael
is it possible you are missing the semi-colon after the statement?
Hi,
please check if any process such as backup is holding the file ,
for further investigation use procmon on qlikview files.
Good Luck
please check the syntax once , if your having two fields same name etc
If possible please post your script, so that we can say that exact error
In geeneral, if script fails then either the source file contents got changed or path changed. Can you rename your QVD file in folder and also in script and reload this again.
Hope this will works -
Sreeni
oh and you can try this also:
Please share .qvw file for more details.
Hello all,
thank you for your suggestions;
Today it reloads again without any error. I think the script is fine, because I did not change anything. And I don't think it's a connection problem because all data comes from qvd;The data from qvd got refreshed though; but the scripts for the qvds were not changed either.
With that being said, I am worried that there is some bug here. But generally I hope if in the future qlikview can give a more detailed log of loading and error info.
Hi Michael,
Good, your app is working fine. There might be some network issue on that particular day at particular time .
Thanks
Sattya