Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

General script error on server while read a QVD. No error on desktop.

Hi all!

I'm stumbling in a strange error, on Qlikview server (11.20.11705.0 x86 w2003 32b Ent. 16GB) and not on desktop (11.20.11707 x64 W7 4bit 4GB).

I'm reading a qvd file, the same qvd file ,  from server and desktop

this is the load:


venduto:

LOAD Ditta &'-'& text(precod) &'-'& text(codart) as KeyVenduto,

  (1-

  (100*

  (100-num(scont1))/100*

  (100-num(scont2))/100*

  (100-num(scont3))/100*

  (100-num(scont4))/100*

  (100-num(scont5))/100)/100) as ScontoMedio

FROM

C:\GrpCresci\QVD\Righe_documento.qvd (qvd)

where Exists(KeyVenduto, Ditta &'-'& text(precod) &'-'& text(codart))

and

(text(codcma)='5' or text(codcma)='6');

The long formula calculates the simple discount from complex (example 30%+10%+15+etc)

Thi is the log from desktop:

......

......

05/03/2013 09:59:38: 0115  LOAD Ditta &'-'& text(precod) &'-'& text(codart) as KeyVenduto,

05/03/2013 09:59:38: 0116    (1-

05/03/2013 09:59:38: 0117    (100*

05/03/2013 09:59:38: 0118    (100-num(scont1))/100*

05/03/2013 09:59:38: 0119    (100-num(scont2))/100*

05/03/2013 09:59:38: 0120    (100-num(scont3))/100*

05/03/2013 09:59:38: 0121    (100-num(scont4))/100*

05/03/2013 09:59:38: 0122    (100-num(scont5))/100)/100) as ScontoMedio

05/03/2013 09:59:38: 0123  FROM C:\GrpCresci\QVD\Righe_documento.qvd (qvd) where Exists(KeyVenduto, Ditta &'-'& text(precod) &'-'& text(codart)) and (text(codcma)='5' or text(codcma)='6')

05/03/2013 09:59:39:                 2 campi trovati: KeyVenduto, venduto.ScontoMedio, 1.250.310 linee recuperate

.....

.....

and this is the Server qvw log:

05/03/2013 10:07:12: 0114  venduto:

05/03/2013 10:07:12: 0115  LOAD Ditta &'-'& text(precod) &'-'& text(codart) as KeyVenduto,

05/03/2013 10:07:12: 0116    (1-

05/03/2013 10:07:12: 0117    (100*

05/03/2013 10:07:12: 0118    (100-num(scont1))/100*

05/03/2013 10:07:12: 0119    (100-num(scont2))/100*

05/03/2013 10:07:12: 0120    (100-num(scont3))/100*

05/03/2013 10:07:12: 0121    (100-num(scont4))/100*

05/03/2013 10:07:12: 0122    (100-num(scont5))/100)/100) as ScontoMedio

05/03/2013 10:07:12: 0123  FROM C:\GrpCresci\QVD\Righe_documento.qvd (qvd) where Exists(KeyVenduto, Ditta &'-'& text(precod) &'-'& text(codart)) and (text(codcma)='5' or text(codcma)='6')

05/03/2013 10:07:12:       2 fields found: KeyVenduto, venduto.ScontoMedio, General Script Error

05/03/2013 10:07:35:       Execution Failed

05/03/2013 10:07:35:      Execution finished.

thanks in advance... and sorry about my english!!!


1 Solution

Accepted Solutions
Not applicable
Author

Installaed a new 64 bit server, no problem found.

The same document generate no error!

so the problem is the 32 bit enviroment!

Thanks to all!!!!

View solution in original post

9 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Are you sure that the account under which QVS is running as a service has the same access rights to Righe_documento.qvd as yourself when executing the scipt in QV desktop?

Peter

Not applicable
Author

Hi Peter,

in my previous post I omitted part of the log.

The report load successfully other QVD, in the same path, (like other report).

The QVS account has access about.

If i remove the long formula, so i load scont1, scont2...etc, i receive no errors about.

Look "venduto2"

06/03/2013 09:44:19: 0115  venduto2:

06/03/2013 09:44:19: 0116  LOAD Ditta as DittaX, precod, codart, codcma, scont1, scont2, scont3, scont4, scont5

06/03/2013 09:44:19: 0117  FROM C:\GrpCresci\QVD\Righe_documento.qvd (qvd)

06/03/2013 09:44:19:                 9 fields found: DittaX, venduto2.precod, venduto2.codart, venduto2.codcma, venduto2.scont1, venduto2.scont2, venduto2.scont3, venduto2.scont4, venduto2.scont5, 4.275.435 lines fetched

06/03/2013 09:44:20: 0121  venduto:

06/03/2013 09:44:20: 0122  LOAD Ditta &'-'& text(precod) &'-'& text(codart) as KeyVenduto,

06/03/2013 09:44:20: 0123    (1-(100*(100-num(scont1))/100*(100-num(scont2))/100*(100-num(scont3))/100*(100-num(scont4))/100*(100-num(scont5))/100)/100) as ScontoMedio

06/03/2013 09:44:20: 0124  FROM C:\GrpCresci\QVD\Righe_documento.qvd (qvd) where Exists(KeyVenduto, Ditta &'-'& text(precod) &'-'& text(codart)) and (text(codcma)='5' or text(codcma)='6')

06/03/2013 09:44:20:                 2 fields found: KeyVenduto, venduto.ScontoMedio, General Script Error

06/03/2013 09:44:39:       Execution Failed

06/03/2013 09:44:39:      Execution finished.

I could use the formula inside a Pivot dimension, due to performances and due so much data, I prefer load it.....

Thanks

flipside
Partner - Specialist II
Partner - Specialist II

I notice your logs are in different languages, could this possibly be down to different locales and formatting of your numeric fields? You may need to check the fields are stored as expected (i.e. "2,50" or "2.50").

flipside

Not applicable
Author

HI ,

There can by few reason of this kind of error.

1. Are you using erromode inside your script. Because the value for erromode will be different for manual run and for QMC run.

2. This kind of error also occur if at the same time QVD is getting accessed by two report. (i.e one is trying to store data and other try to fetch at same time.)

Br Dhiraj

Not applicable
Author

Hi Flipside,

beginning of the qvw report file i have this set:

07/03/2013 14:41:21: 0003  SET ThousandSep='.'

07/03/2013 14:41:21: 0004  SET DecimalSep=','

07/03/2013 14:41:21: 0005  SET MoneyThousandSep='.'

07/03/2013 14:41:21: 0006  SET MoneyDecimalSep=','

07/03/2013 14:41:21: 0007  SET MoneyFormat='€ #.##0,00;-€ #.##0,00'

07/03/2013 14:41:21: 0008  SET TimeFormat='hh:mm:ss'

07/03/2013 14:41:21: 0009  SET DateFormat='DD/MM/YYYY'

07/03/2013 14:41:21: 0010  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

07/03/2013 14:41:21: 0011  SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic'

07/03/2013 14:41:21: 0012  SET DayNames='lun;mar;mer;gio;ven;sab;dom'

The QVD file are loaded from text file and the fields scontX are with the comma like "20,0" to say 20%

Thanks!

Not applicable
Author

HI D J,

About errormode i'm not understanding about, I will read manual.

No simultaneous access. I load text into QVD in night schedules...

Thanks.

flipside
Partner - Specialist II
Partner - Specialist II

Can you load the script on the server without the long formula but WITH the WHERE clause - and also test vice-versa?

Also, your logs have a 20 second wait before error is generated which suggests it is either waiting to access something or trying to do something in memory.  Is there something earlier in the code causing a loop or synthetic key? Ignore this, the error is generated immediately so must be something with the script.

Sorry to be vague but I think you just have to keep narrowing down the fault by eliminating possible causes.

flipside

Not applicable
Author

Hi all!

The error, or rather the problem, is inside the KEY, and no syn key was generated.

I use  "where Exists(KeyVenduto, Ditta &'-'& text(precod) &'-'& text(codart))" to remove records not relevant to the report.

I tried to remove Text function, but no success.....

I tried to remove Exist function and the reload is success, but the report is conceptually distorted.......

KeyVenduto is a string concatenation, long by 7 to 15 alphanumeric characters:

"AR_NC_." the smallest

"AE_99_LUCIDA MOBILI SPRAY" the largest.

and it is composed of 20635 rows.

However, the mystery remains as to the desktop 64-bit works fine.

Bye!

Not applicable
Author

Installaed a new 64 bit server, no problem found.

The same document generate no error!

so the problem is the 32 bit enviroment!

Thanks to all!!!!