topic Re: General script error on server while read a QVD. No error on desktop. in QlikView

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

Mon, 26 Jan 2026 18:19:17 GMT

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!!!

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

Peter_Cammaert — Tue, 05 Mar 2013 22:27:51 GMT

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

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

Wed, 06 Mar 2013 08:50:43 GMT

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

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

flipside — Wed, 06 Mar 2013 09:42:54 GMT

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

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

Wed, 06 Mar 2013 10:07:58 GMT

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

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

Thu, 07 Mar 2013 13:49:20 GMT

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!

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

Thu, 07 Mar 2013 13:53:40 GMT

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.

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

flipside — Thu, 07 Mar 2013 14:20:29 GMT

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

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

Fri, 08 Mar 2013 08:44:11 GMT

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!

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

Fri, 29 Mar 2013 12:45:44 GMT

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!!!!