1 Reply Latest reply: Sep 23, 2013 8:53 AM by Friedrich Hofmann RSS

    Some scripting help needed - general script error occuring

    Friedrich Hofmann



      I have one diagram drawing on a database table that has no history.

      => I store the current date and a value in a qvd file every day, thus creating my own.

      <=> Every other day, that app produces a "general script error". I cannot spot it.

      Can anybody help me here, please?

      The code is like this:


      // First, I load the "qvd history" that is already there:


      Datum_num as Datum_Hist,
      //     DATE(Datum_Sp_AOS) as %Datum,
      [..\01_QVD\Historische_qvd\Historie_Sperr1_64.qvd] (


      // Then I have to find out whether the preceding LOAD from a qvd has returned any records. (If not, I just want to construct a record with the current date and the nr. 0)


      LET v_Nr_Rows_Sperr1 = NoOfRows('Sperr1_AOS'); 


      // Next I have a RESIDENT LOAD from this preceding LOAD where I have to take into account this variable that tells me whether anything was found. I have two WHERE clauses because the app now runs all 3 hrs and I want the record for today only once and I want it after 11am - that is about the middle of a working_day, giving me a good approximation of the correct value (the value in the first run at about 3am would be more representative for yesterday)


      CONCATENATE  (Hist_Sp1_64)
      $(v_today) as Datum_num,
           IF($(v_Nr_Rows_Sperr1)<>0, count(DISTINCT BIN_ITEM_DETAIL.ITEM_NUMBER), 0) as Anzahl_Sachnrn
      RESIDENT Sperr1_AOS
      WHERE NOT EXISTS(Datum_Hist, $(v_today))
      and   Now() > '11:00:00'


      It is at this point that the script usually produces a "General script error". I see just now in the log file it says "Misplaced FROM", easy enough - but all the commands are in blue which looks right to me.


      Thanks a lot!

      Best regards,





      P.S.: What's making this all quite confusing is that it seems to me that at some times, the script executes to the end - there is an error in the log, but it doesn't stop there - but the management_console says "Failed".


      P.P.S.: One more strange thing - in the error message popup I see when I update manually, that CONCATENATE is visible twice - the same LOAD statement is printed there, immediately followed by a CONCATENATE and the same thing again - I don't have that in the script twice.

      It looks like the semicolon was missing - but it is there.

        • Re: Some scripting help needed - general script error occuring
          Friedrich Hofmann

          OK - solved.

          After looking at it approx. 1000 times, I realized that, in the course of creating that qvs file on Friday, I had recreated two variables with different names.

          So, since the scripting_editor does not show errors in variables once they are enclosed in this $() - which the book says should always be used? - I didn't notice that the variable didn't exist anymore - so the RESIDENT LOAD naturally failed.


          Best regards,