3 Replies Latest reply: May 24, 2012 12:15 PM by onurguclu RSS

    Table not found error

      Hi everybody,

       

      I have a "table not found" error when loading.

      If I don't put tableChangeHistory load in my script, tableTempChangeHistory is loaded correctly and i can find all its data's in my application.

       

      When I try to load tableChangeHistory, Qlickview display an error message: "table not found" ( I guess it's about tableTempChangeHistory while it was loaded before).

       

      Could you help me with that please? 

      Thank you very much.

       

       

       

      tableTempChangeHistory :
      SELECT ITSM_HISTORYLINES_CHANGE.HCH_OID AS "Change history line ID",
             ITSM_HISTORYLINES_CHANGE.HCH_CHA_OID AS "Change ID (internal)",
             REP_CODES_TEXT.RCT_NAME AS "Change status (hist./temp)",
             ITSM_WORKGROUPS.WOG_SEARCHCODE AS "Change workgroup (hist./temp)"
             ITSM_HISTORYLINES_CHANGE.REG_CREATED AS "Change changed on",
      FROM   SERVICEDESK.ITSM_HISTORYLINES_CHANGE ITSM_HISTORYLINES_CHANGE,
             SERVICEDESK.ITSM_CHANGES ITSM_CHANGES,
             SERVICEDESKREPO.IFC_ATTRIBUTES IFC_ATTRIBUTES,
             SERVICEDESKREPO.REP_CODES_TEXT REP_CODES_TEXT,
             SERVICEDESK.ITSM_WORKGROUPS ITSM_WORKGROUPS
      WHERE  ITSM_HISTORYLINES_CHANGE.HCH_CHA_OID = ITSM_CHANGES.CHA_OID
        AND  (ITSM_CHANGES.REG_CREATED > to_date('01/10/2011','DD/MM/YYYY'))
        AND  ITSM_HISTORYLINES_CHANGE.HCH_VALUEATR_OID = IFC_ATTRIBUTES.ATR_OID
        AND  IFC_ATTRIBUTES.ATR_NAME in ('Status', 'To workgroup')
        AND  ITSM_HISTORYLINES_CHANGE.HCH_VALUETO = REP_CODES_TEXT.RCT_RCD_OID(+)
        AND  ITSM_HISTORYLINES_CHANGE.HCH_VALUETO = ITSM_WORKGROUPS.WOG_OID(+)
      ORDER BY ITSM_HISTORYLINES_CHANGE.HCH_CHA_OID;

      /***********************************************************/
      tableChangeHistory :
      load "Change history line ID",
           "Change ID (internal)",
           "Change changed on"
      resident tableTempChangeHistory;
      drop table tableTempChangeHistory;

        • Re: Table not found error
          Miguel Angel Baeyens de Arce

          Hi,

           

          Try the following instead:

           

          tableChangeHistory :
          NOCONCATENATE load "Change history line ID",
          ...
          

           

          Hope that helps.

           

          Miguel

          • Table not found error
            Jason Michaelides

            Try using a preceding load:

             

            tableTempChangeHistory :

            LOAD * ;
            SELECT ITSM_HISTORYLINES_CHANGE.HCH_OID AS "Change history line ID",
                   ITSM_HISTORYLINES_CHANGE.HCH_CHA_OID AS "Change ID (internal)",
                   REP_CODES_TEXT.RCT_NAME AS "Change status (hist./temp)",
                   ITSM_WORKGROUPS.WOG_SEARCHCODE AS "Change workgroup (hist./temp)"
                   ITSM_HISTORYLINES_CHANGE.REG_CREATED AS "Change changed on",
            FROM   SERVICEDESK.ITSM_HISTORYLINES_CHANGE ITSM_HISTORYLINES_CHANGE,
                   SERVICEDESK.ITSM_CHANGES ITSM_CHANGES,
                   SERVICEDESKREPO.IFC_ATTRIBUTES IFC_ATTRIBUTES,
                   SERVICEDESKREPO.REP_CODES_TEXT REP_CODES_TEXT,
                   SERVICEDESK.ITSM_WORKGROUPS ITSM_WORKGROUPS
            WHERE  ITSM_HISTORYLINES_CHANGE.HCH_CHA_OID = ITSM_CHANGES.CHA_OID
              AND  (ITSM_CHANGES.REG_CREATED > to_date('01/10/2011','DD/MM/YYYY'))
              AND  ITSM_HISTORYLINES_CHANGE.HCH_VALUEATR_OID = IFC_ATTRIBUTES.ATR_OID
              AND  IFC_ATTRIBUTES.ATR_NAME in ('Status', 'To workgroup')
              AND  ITSM_HISTORYLINES_CHANGE.HCH_VALUETO = REP_CODES_TEXT.RCT_RCD_OID(+)
              AND  ITSM_HISTORYLINES_CHANGE.HCH_VALUETO = ITSM_WORKGROUPS.WOG_OID(+)
            ORDER BY ITSM_HISTORYLINES_CHANGE.HCH_CHA_OID;

            /***********************************************************/
            tableChangeHistory :
            load "Change history line ID",
                 "Change ID (internal)",
                 "Change changed on"
            resident tableTempChangeHistory;
            drop table tableTempChangeHistory;