topic Re: General Script Error in QlikView

General Script Error

Wed, 30 Sep 2015 22:58:53 GMT

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 (qvd)

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

Re: General Script Error

tchovanec — Thu, 01 Oct 2015 01:16:05 GMT

‌is it possible you are missing the semi-colon after the statement?

Re: General Script Error

amirkachlon — Thu, 01 Oct 2015 06:35:18 GMT

Hi,

please check if any process such as backup is holding the file ,

for further investigation use procmon on qlikview files.

Good Luck

Re: General Script Error

avinashelite — Thu, 01 Oct 2015 06:48:09 GMT

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

Re: General Script Error

SreeniJD — Thu, 01 Oct 2015 07:10:19 GMT

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

Re: General Script Error

amirkachlon — Thu, 01 Oct 2015 07:12:30 GMT

oh and you can try this also:

Avoid General Script Error in STORE command

Re: General Script Error

Anonymous — Thu, 01 Oct 2015 07:19:21 GMT

Please share .qvw file for more details.

Re: General Script Error

Thu, 01 Oct 2015 16:20:41 GMT

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.

Re: General Script Error

Anonymous — Mon, 05 Oct 2015 15:31:10 GMT

Hi Michael,

Good, your app is working fine. There might be some network issue on that particular day at particular time .

Thanks

Sattya