topic Re: General Script Error on Resident Load in QlikView

General Script Error on Resident Load

Tue, 29 Jan 2013 16:50:32 GMT

Getting a General Script Error on a simple RESIDENT Load. This is the first time I've tried RESIDENT Loading so I anticipate I may have a simple syntactical issue here, unfortunately the Log file provides no useful info on the error other than stating its a General Script Error and Debugger doesn't seem to provide any additional info on the problem either

Here is my LOAD statement:

NET30DELTA:

LOAD
(SUM(AVERAGE_DELTA)/COUNT(AVERAGE_DELTA)) AS AVGGROWTH
RESIDENT DISC_USAGE
WHERE DISC_DATE >= AddMonths(MAX(DISC_DATE),-1)
;

Re: General Script Error on Resident Load

montero91 — Tue, 29 Jan 2013 17:32:20 GMT

Hi Lew

is not an error in a table resident,

you're doing grouping operations(sum, Count) without a GROUP BY

for any field

example month

NET30DELTA:

LOAD
(SUM(AVERAGE_DELTA)/COUNT(AVERAGE_DELTA)) AS AVGGROWTH ,

Month,
RESIDENT DISC_USAGE
WHERE DISC_DATE >= AddMonths(MAX(DISC_DATE),-1)

Group by Month;

Re: General Script Error on Resident Load

Tue, 29 Jan 2013 19:38:00 GMT

Hello Manuel,

Thanks for your reply. I have applied your recomendation and added another column to use for Grouping, yet I still get the failure. Here is what I see in the Log.

1/29/2013 1:33:34 PM: 0148 NET30_DELTA:
1/29/2013 1:33:34 PM: 0149 LOAD
1/29/2013 1:33:34 PM: 0150 SRC_SYS_CD,

1/29/2013 1:33:34 PM: 0151    (SUM(AVERAGE_DELTA)/COUNT(AVERAGE_DELTA)) AS AVG_GROWTH30
1/29/2013 1:33:34 PM: 0152     RESIDENT DISC_USAGE
1/29/2013 1:33:34 PM: 0153    WHERE DISC_DATE >= AddMonths(MAX(DISC_DATE),-1)
1/29/2013 1:33:34 PM: 0154    Group By SRC_SYS_CD

1/29/2013 1:33:34 PM: General Script Error
1/29/2013 1:33:34 PM: Execution Failed

Re: General Script Error on Resident Load

Gysbert_Wassenaar — Tue, 29 Jan 2013 19:47:53 GMT

Using an aggregation function in the where clause is most likely the problem.

WHERE DISC_DATE >= AddMonths(MAX(DISC_DATE),-1)

You can try using a variable instead:

Temp:

load Max(DISC_DATE) as MaxDiscDate

from ...disc_usage_source...;

LET vMaxDD = addmonths(peek('MaxDiscDate'),-1);

drop table Temp;

LOAD

(SUM(AVERAGE_DELTA)/COUNT(AVERAGE_DELTA)) AS AVGGROWTH

RESIDENT DISC_USAGE

WHERE DISC_DATE >= $(vMaxDD);

Re: General Script Error on Resident Load

Tue, 29 Jan 2013 20:56:25 GMT

Hi Gysbert,

I commend your QV Skills...that seems to have done the trick! Thanks for your assistance, I'm not so sure I would have figured this one out on my own.

Best Regards,

Lew