Table not found when creating qvd file in qlikview

sasghar12 — Sat, 16 Nov 2024 01:14:59 GMT

This is my script for incremental load. Its work fine without store statement but with store statement it is giving error table not found. I don't get what i am doing wrong here.

CUSTOM CONNECT TO "Provider=QvSAPBAPIConnector.dll; ASHOST=; SYSNR=00; CLIENT=500; XUserId=; XPassword=";

let vDateFrom='20130701';
let vDateTo= Date(Today(), 'YYYYMMDD');

[CAP_STAT]:
LOAD *;
SQL {
"function":"ZAK_CAP_STAT_RPT_FM_PAR",
"output":"OUTTAB_CAP_STAT",
"parameters":
[
{ "direction":"in", "length":12, "name":"AR_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":12, "name":"AR_LOW", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":8, "name":"BUD_HEAD_HIGH", "optional":true, "type":"NUM", "value":"00000000" },
{ "direction":"in", "length":8, "name":"BUD_HEAD_LOW", "optional":true, "type":"NUM", "value":"00000000" },
{ "direction":"in", "length":8, "name":"GR_DATE_HIGH", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":8, "name":"GR_DATE_LOW", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":8, "name":"PO_DATE_HIGH", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":8, "name":"PO_DATE_LOW", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":10, "name":"PO_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":10, "name":"PO_LOW", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":8, "name":"PROJ_DEF_DATE_HIGH", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":8, "name":"PROJ_DEF_DATE_LOW", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":24, "name":"PROJ_DEF_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":24, "name":"PROJ_DEF_LOW", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":10, "name":"PR_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":10, "name":"PR_LOW", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":24, "name":"WBS_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":24, "name":"WBS_LOW", "optional":true, "type":"CHAR", "value":" " },
{
"direction":"tables",
"name":"OUTTAB_CAP_STAT",
"optional":true,
"table":
[
{ "field":"PD_PSPNR", "length":8, "type":"NUM", "values":[] },
{ "field":"PD_PSPID", "length":24, "type":"CHAR", "values":[] },
{ "field":"PD_POST1", "length":40, "type":"CHAR", "values":[] },
{ "field":"PD_OBJNR", "length":22, "type":"CHAR", "values":[] },
{ "field":"PD_VERNR", "length":8, "type":"NUM", "values":[] },
{ "field":"PD_VERNA", "length":25, "type":"CHAR", "values":[] },
{ "field":"PD_ERNAM", "length":12, "type":"CHAR", "values":[] },
{ "field":"PD_ERDAT", "length":8, "type":"DATE", "values":[] },
{ "field":"WBS_PSPNR", "length":8, "type":"NUM", "values":[] },
{ "field":"WBS_POSID", "length":24, "type":"CHAR", "values":[] },
{ "field":"WBS_POST1", "length":40, "type":"CHAR", "values":[] },
{ "field":"WBS_OBJNR", "length":22, "type":"CHAR", "values":[] },
{ "field":"WBS_VERNR", "length":8, "type":"NUM", "values":[] },
{ "field":"WBS_VERNA", "length":25, "type":"CHAR", "values":[] },
{ "field":"WBS_PRART", "length":2, "type":"CHAR", "values":[] },
{ "field":"WBS_PRART_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"WBS_ERNAM", "length":12, "type":"CHAR", "values":[] },
{ "field":"WBS_ERDAT", "length":8, "type":"DATE", "values":[] },
{ "field":"AUFNT_FULL", "length":12, "type":"CHAR", "values":[] },
{ "field":"AUFNT", "length":12, "type":"CHAR", "values":[] },
{ "field":"AR_REL_DAT", "length":8, "type":"DATE", "values":[] },
{ "field":"WBS_SUP_PSPNR", "length":8, "type":"NUM", "values":[] },
{ "field":"WBS_SUP_POSID", "length":24, "type":"CHAR", "values":[] },
{ "field":"WBS_SUP_POST1", "length":40, "type":"CHAR", "values":[] },
{ "field":"APRV_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"APP_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"ACT_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"COMM_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"BELNR", "length":10, "type":"NUM", "values":[] },
{ "field":"BLDAT", "length":8, "type":"DATE", "values":[] },
{ "field":"GJAHR", "length":4, "type":"NUM", "values":[] },
{ "field":"AUFNR_FULL", "length":12, "type":"CHAR", "values":[] },
{ "field":"AUFNR", "length":12, "type":"CHAR", "values":[] },
{ "field":"SN_REL_DAT", "length":8, "type":"DATE", "values":[] },
{ "field":"BANFN", "length":10, "type":"CHAR", "values":[] },
{ "field":"BNFPO", "length":5, "type":"NUM", "values":[] },
{ "field":"PR_DATE", "length":8, "type":"DATE", "values":[] },
{ "field":"MATNR", "length":18, "type":"CHAR", "values":[] },
{ "field":"TXZ01", "length":40, "type":"CHAR", "values":[] },
{ "field":"PREIS", "length":10, "type":"BCD", "values":[] },
{ "field":"EBELN", "length":10, "type":"CHAR", "values":[] },
{ "field":"EBELP", "length":5, "type":"NUM", "values":[] },
{ "field":"PO_DATE", "length":8, "type":"DATE", "values":[] },
{ "field":"PO_KNTTP", "length":1, "type":"CHAR", "values":[] },
{ "field":"NETWR", "length":10, "type":"BCD", "values":[] },
{ "field":"EFFWR", "length":10, "type":"BCD", "values":[] },
{ "field":"GR_BELNR", "length":10, "type":"CHAR", "values":[] },
{ "field":"GR_GJAHR", "length":4, "type":"NUM", "values":[] },
{ "field":"GR_BUZEI", "length":4, "type":"NUM", "values":[] },
{ "field":"GR_DATE", "length":8, "type":"DATE", "values":[] },
{ "field":"GR_MENGE", "length":7, "type":"BCD", "values":[] },
{ "field":"GR_WRBTR", "length":10, "type":"BCD", "values":[] },
{ "field":"INV_BELNR", "length":10, "type":"CHAR", "values":[] },
{ "field":"INV_GJAHR", "length":4, "type":"NUM", "values":[] },
{ "field":"INV_BUZEI", "length":4, "type":"NUM", "values":[] },
{ "field":"INV_DATE", "length":8, "type":"DATE", "values":[] },
{ "field":"INV_MENGE", "length":7, "type":"BCD", "values":[] },
{ "field":"INV_WRBTR", "length":10, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_1", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_1", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_1", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_2", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_2", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_2", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_3", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_3", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_3", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_4", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_4", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_4", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_5", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_5", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_5", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_6", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_6", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_6", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_7", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_7", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_7", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_8", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_8", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_8", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_9", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_9", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_9", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_10", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_10", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_10", "length":8, "type":"BCD", "values":[] },
{ "field":"PR_KNTTP", "length":1, "type":"CHAR", "values":[] },
{ "field":"PR_COM_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"PR_COM_QTY", "length":8, "type":"BCD", "values":[] },
{ "field":"PR_COM_GJAHR", "length":4, "type":"NUM", "values":[] },
{ "field":"PO_COM_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"PO_COM_QTY", "length":8, "type":"BCD", "values":[] },
{ "field":"PO_COM_GJAHR", "length":4, "type":"NUM", "values":[] }
]
}
]
};

*****

store [CAP_STAT] into $(vDirectoryPath)CAP_STAT.qvd(qvd);

Re: Table not found when creating qvd file in qlikview

sasghar12 — Wed, 19 Feb 2020 11:29:37 GMT

I am retrieving data from SAP using SAP BAPI connector. Kindly look into it. It is urgent.

Re: Table not found when creating qvd file in qlikview

jonathandienst — Wed, 19 Feb 2020 11:42:19 GMT

Either the CAP_STAT query is returning nothing, or CAP_STAT is getting autococatenate to a previously loaded table the same set of fields.

If you think its the latter, add NoConcatenate to the load

CAP_STAT:
NoConcatenate

.....

Re: Table not found when creating qvd file in qlikview

sasghar12 — Wed, 19 Feb 2020 17:13:32 GMT

I have deleted previously loaded data using drop table statement and when i run this script without store it is showing data in tabular view that means table is present in memory so why error is occuring.

Re: Table not found when creating qvd file in qlikview

sasghar12 — Wed, 19 Feb 2020 17:15:55 GMT

Actually it was working fine before but when i added script again to generate qvd it keeps on giving me error.

Re: Table not found when creating qvd file in qlikview

Brett_Bleess — Tue, 24 Mar 2020 19:10:34 GMT

Best thing in these cases is to start with the Script/Document log:

How to enable Script/Document Log

Without, bit difficult to say what is going on, so I would start there and if you have the log, attaching that should help us try to help you figure things out.

Regards,
Brett

topic Table not found when creating qvd file in qlikview in QlikView

Table not found when creating qvd file in qlikview

Re: Table not found when creating qvd file in qlikview

Re: Table not found when creating qvd file in qlikview

Re: Table not found when creating qvd file in qlikview

Re: Table not found when creating qvd file in qlikview

Re: Table not found when creating qvd file in qlikview