Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Hi,
Try the following instead:
tableChangeHistory :
NOCONCATENATE load "Change history line ID",
...
Hope that helps.
Miguel
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;
Sorry Guys, no one of these methods works.
Anyway, thank you very much.