9 Replies Latest reply: Mar 29, 2013 8:45 AM by c.dellabruna RSS

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


        • Re: General script error on server while read a QVD. No error on desktop.
          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

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

              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.

              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!