topic Table not found error in QlikView

Table not found error

Wed, 23 May 2012 16:03:58 GMT

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 — Wed, 23 May 2012 16:06:34 GMT

Hi,

Try the following instead:

tableChangeHistory :

NOCONCATENATE load "Change history line ID",

...

Hope that helps.

Miguel

Table not found error

Jason_Michaelides — Wed, 23 May 2012 16:07:20 GMT

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;

Table not found error

Thu, 24 May 2012 16:15:22 GMT

Sorry Guys, no one of these methods works.

Anyway, thank you very much.