Table not found error

[#1]

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;

[Miguel_Angel_Baeyens]

Hi,

Try the following instead:

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

Hope that helps.

Miguel

[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;

[#4]

Sorry Guys, no one of these methods works.

Anyway, thank you very much.