SAP Connector Reload Issue

Fri, 01 Nov 2013 13:57:37 GMT

First Query works fine but the second query fails and give different fields missing error every time. Both of them are generated from script builder. This is strange and needs to be resolved ASAP; as I want to use inner join for Incremental Load

[CRMD_ORDER_INDEX]: // Index table for one-order document
Load
[HEADER] as [HEADER],
[ITEM] as [ITEM],
[PROCESS_TYPE_IX] as [PROCESS_TYPE_IX],
[OBJECT_TYPE] as [OBJECT_TYPE],
[PARTNER_NO] as [PARTNER_NO];
SQL Select PARTNER_NO OBJECT_TYPE HEADER ITEM PROCESS_TYPE_IX from CRMD_ORDER_INDEX
;
STORE * FROM [CRMD_ORDER_INDEX] INTO CRMD_ORDER_INDEX.QVD;
DROP TABLE [CRMD_ORDER_INDEX];

***********************************************************************************************************************

[CRMD_ORDER_INDEX]: // Index table for one-order document
Load
[HEADER] as [HEADER],
[ITEM] as [ITEM],
[PROCESS_TYPE_IX] as [PROCESS_TYPE_IX],
[OBJECT_TYPE] as [OBJECT_TYPE],
[PARTNER_NO] as [PARTNER_NO];
SQL Select CRMD_ORDER_INDEX~PARTNER_NO CRMD_ORDER_INDEX~OBJECT_TYPE CRMD_ORDER_INDEX~HEADER CRMD_ORDER_INDEX~ITEM CRMD_ORDER_INDEX~PROCESS_TYPE_IX from CRMD_ORDER_INDEX
;
STORE * FROM [CRMD_ORDER_INDEX] INTO CRMD_ORDER_INDEX.QVD;
DROP TABLE [CRMD_ORDER_INDEX];

topic SAP Connector Reload Issue in QlikView

SAP Connector Reload Issue