2 Replies Latest reply: Mar 12, 2012 9:40 AM by Gene Brown RSS

    Field not found error

      No matter what I try, I get the same error...

      I've verified the .qvd is being created, and went so far as to:

      copy the "Load" from the .qvd creation .qvw (1)

      and use it in the .qvw (2) that is accessing the .qvd.

       

      The Creation scripting:

      .qvw (1)

      Audit:

      LOAD "ACTION_DT",

          "AUDIT_ID",

          "CHANGE_DT",

          "ENTERED_BY",

          "ENTRY_TYPE",

          "IA_ACTION",

          "INCIDENT_ID",

          "NEW_VALUE",

          "OLD_VALUE";

      SQL SELECT "ACTION_DT",

          "AUDIT_ID",

          "CHANGE_DT",

          "ENTERED_BY",

          "ENTRY_TYPE",

          "IA_ACTION",

          "INCIDENT_ID",

          "NEW_VALUE",

          "OLD_VALUE"

      FROM AXENT."HD_INCIDENT_AUDIT"

       

      where "CHANGE_DT" > to_date ('12/31/2008','MM/DD/YYYY');

       

      STORE Contact into C:\QlikTest\ITS\QVD\IET_Audit.qvd;

       

      And the accessing of the .qvd (2) scripting

      Audit:

      LOAD "ACTION_DT",

          "AUDIT_ID",

          "CHANGE_DT",

          "ENTERED_BY",

          "ENTRY_TYPE",

          "IA_ACTION",

          "INCIDENT_ID",

          "NEW_VALUE",

          "OLD_VALUE"

       

      FROM

      [C:\QlikTest\ITS\QVD\IET_Audit.qvd]

      (qvd);

       

      And the error I can not get around:

       

      Field not found - <ACTION_DT>

      Audit:

      LOAD "ACTION_DT",

          "AUDIT_ID",

          "CHANGE_DT",

          "ENTERED_BY",

          "ENTRY_TYPE",

          "IA_ACTION",

          "INCIDENT_ID",

          "NEW_VALUE",

          "OLD_VALUE"

       

      FROM

      [C:\QlikTest\ITS\QVD\IET_Audit.qvd]

      (qvd)

       

      Any Ideas?

        • Field not found error
          Celambarasan Adhimulam

          Hi,

          If you used the exactly same script you posted here then check the table name you give and stored in qvd?

          Audit:

          LOAD "ACTION_DT",

              "AUDIT_ID",

              "CHANGE_DT",

              "ENTERED_BY",

              "ENTRY_TYPE",

              "IA_ACTION",

              "INCIDENT_ID",

              "NEW_VALUE",

              "OLD_VALUE";

          SQL SELECT "ACTION_DT",

              "AUDIT_ID",

              "CHANGE_DT",

              "ENTERED_BY",

              "ENTRY_TYPE",

              "IA_ACTION",

              "INCIDENT_ID",

              "NEW_VALUE",

              "OLD_VALUE"

          FROM AXENT."HD_INCIDENT_AUDIT"

           

          where "CHANGE_DT" > to_date ('12/31/2008','MM/DD/YYYY');

           

          STORE Contact into C:\QlikTest\ITS\QVD\IET_Audit.qvd;

           

          May be this might be the problem.

           

          Celambarasan