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

[#1]

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

[Peter_Cammaert]

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

[#3]

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]

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

[#5]

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

[#6]

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!

[#7]

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]

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

[#9]

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!

[#10 · Accepted solution]

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