5 Replies Latest reply: Nov 27, 2012 4:29 AM by Jacek Bloch RSS

    Field not found when a lot of data

      Hi,

      Does anyone know why application works correctly when I load one amount of data (around 1,5 M records from SQL). And when I try to load a bit bigger amount I receive error "Field not found" with first field from my SQL script?

       

      The script:

      SET ThousandSep=' ';

      SET DecimalSep=',';

      SET MoneyThousandSep=' ';

      SET MoneyDecimalSep=',';

      SET MoneyFormat='# ##0,00 zł;-# ##0,00 zł';

      SET TimeFormat='hh:mm:ss';

      SET DateFormat='YYYY-MM-DD';

      SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';

      SET MonthNames='sty;lut;mar;kwi;maj;cze;lip;sie;wrz;paź;lis;gru';

      SET DayNames='Pn;Wt;Śr;Cz;Pt;So;N';

       

      ODBC CONNECT TO pcmd;

      LOAD "allocated_service",

          "answer_time",

          hour("answer_time") as ans_h,

          "call_date",

          "call_established",

          "call_type",

          cfc,

          "cfc_qualifier",

          "cfc_qualifier_sec",

          "elapsed_time",

          esn,

          "incoming_number",

          "originated_digits",

          "subscriber_number";

      SQL SELECT "allocated_service",

          "answer_time",

          "call_date",

          "call_established",

          "call_type",

          cfc,

          "cfc_qualifier",

          "cfc_qualifier_sec",

          "elapsed_time",

          esn,

          "incoming_number",

          "originated_digits",

          "subscriber_number"

      FROM pcmd."public"."npcmd_1210"

      where "call_date" between '2012-10-18' and '2012-10-31';

       

      When the above date range starts from 2012-10-20 it works fine. When the range is between 18 and 22 it works fine as well. But when the range is wider like in the example it returns error.

      Does the QlikView have any data size limitation?

       

      Jacek