Table not found when creating qvd file in qlikview

[sasghar12]

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

[sasghar12]

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

[jonathandienst]

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

.....

[sasghar12]

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. 

[sasghar12]

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

[Brett_Bleess]

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