Issue in while storing data into qvd

sunil1989 — Wed, 10 May 2017 08:23:33 GMT

Hi ,

Thanks in Advance!!!

below is my log file , i am not getting where i am wrong , qlik is giving me error that table not found. can anyone look to log file and help me to find out what is the issue

10/05/2017 09:09:14: Execution started.

10/05/2017 09:09:14: QlikView Version:11.20.12904.0

10/05/2017 09:09:14: CPU Target x64

10/05/2017 09:09:14: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

10/05/2017 09:09:14: Wow64 mode Not using Wow64

10/05/2017 09:09:14: MDAC Version 6.1.7601.17514

10/05/2017 09:09:14: MDAC Full Install Version 6.1.7601.17514

10/05/2017 09:09:14: PreferredCompression 2

10/05/2017 09:09:14: EnableParallelReload 1

10/05/2017 09:09:14: ParallelizeQvdLoads 1

10/05/2017 09:09:14: AutoSaveAfterReload 0

10/05/2017 09:09:14: BackupBeforeReload 0

10/05/2017 09:09:14: EnableFlushLog 0

10/05/2017 09:09:14: SaveInfoWhenSavingFile 0

10/05/2017 09:09:14: UserLogfileCharset 1200

10/05/2017 09:09:14: OdbcLoginTimeout -1

10/05/2017 09:09:14: OdbcConnectionTimeout -1

10/05/2017 09:09:14: ScriptWantsDbWrite false

10/05/2017 09:09:14: ScriptWantsExe false

10/05/2017 09:09:14: LogFile CodePage Used: 1200

10/05/2017 09:09:14: Reload Executed By PREPROD\extmasys

10/05/2017 09:09:14: Process Executing: QlikView Desktop

10/05/2017 09:09:14: Process ID: 16452

10/05/2017 09:09:14: 0003 SET ThousandSep=','

10/05/2017 09:09:14: 0004 SET DecimalSep='.'

10/05/2017 09:09:14: 0005 SET MoneyThousandSep=','

10/05/2017 09:09:14: 0006 SET MoneyDecimalSep='.'

10/05/2017 09:09:14: 0007 SET MoneyFormat='£#,##0.00;-£#,##0.00'

10/05/2017 09:09:14: 0008 SET TimeFormat='hh:mm:ss'

10/05/2017 09:09:14: 0009 SET DateFormat='DD/MM/YYYY'

10/05/2017 09:09:14: 0010 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

10/05/2017 09:09:14: 0011 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

10/05/2017 09:09:14: 0012 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

10/05/2017 09:09:14: 0014 Let vComputer = ComputerName()

10/05/2017 09:09:14: 0005 TRACE ---- Computer Name : DEV0772QLIKAP01

10/05/2017 09:09:14: 0005 ---- Computer Name : DEV0772QLIKAP01

10/05/2017 09:09:14: 0007 IF vComputer='WMM0949QLIKAP01' THEN

10/05/2017 09:09:14: 0020 SET vQR = 'P:'

10/05/2017 09:09:14: 0021 ENDIF

10/05/2017 09:09:14: 0026 Let vsPathBigQueryExtract = 'P:\01_QlikView\03 QVD\Shared\BigQuery\Raw\'

10/05/2017 09:09:14: 0028 Let vSourceData = 'P:\01_QlikView\04 Source Data\Projects\Store Pick\'

10/05/2017 09:09:14: 0030 Let vExtractBusinessfileDimQVDPath = 'P:\01_Qlikview\03 QVD\QVDs\Extract\Business File\Dim\'

10/05/2017 09:09:14: 0032 Let vExtractBigQueryDimQVDPath = 'P:\01_QlikView\03 QVD\QVDs\Extract\BigQuery\Dim\'

10/05/2017 09:09:14: 0034 Let vExtractBigQueryFactQVDPath = 'P:\01_QlikView\03 QVD\QVDs\Extract\BigQuery\Fact\'

10/05/2017 09:09:14: 0036 Let vTransformQVDPath = 'P:\01_QlikView\03 QVD\QVDs\Transform\Store Pick\'

10/05/2017 09:09:14: 0038 Let vExcel = 'P:\01_QlikView\02 Include\Projects\Store Pick\'

10/05/2017 09:09:14: 0040 Let vAuditLog = 'P:\01_QlikView\03 QVD\Projects\Store Pick\RAW\AuditLog\'

10/05/2017 09:09:14: 0043 SET Schema_Name = 'BIA_RTL'

10/05/2017 09:09:14: 0044 SET datasetName= 'store_pick'

10/05/2017 09:09:14: 0046 SET vMYellow = RGB(250,220,65)

10/05/2017 09:09:14: 0047 SET vMGreen = RGB(0,112,80)

10/05/2017 09:09:14: 0022 parm_value:

10/05/2017 09:09:14: 0023 LOAD BatchDate

10/05/2017 09:09:14: 0024 FROM

10/05/2017 09:09:14: 0025 [BatchDate.qvd]

10/05/2017 09:09:14: 0026 (qvd)

10/05/2017 09:09:14: 1 fields found: BatchDate, 1 lines fetched

10/05/2017 09:09:14: 0028 vBatchDate = Peek('BatchDate',0)

10/05/2017 09:09:14: 0030 trace -- 20170508

10/05/2017 09:09:14: 0030 -- 20170508

10/05/2017 09:09:14: 0032 LIST_OF_TABLES:

10/05/2017 09:09:14: 0033 LOAD * INLINE [

10/05/2017 09:09:14: 0034 Connection,TableName,LoadType,StartDate,EndDate,Period,

10/05/2017 09:09:14: 0035 200,store_pick.Payments,1,20170427,20170505,

10/05/2017 09:09:14: 0036 200,store_pick.Refunds,1,20170430,20170505,

10/05/2017 09:09:14: 0037 300,BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY,2,20170427,20170505,Day

10/05/2017 09:09:14: 0038 ]

10/05/2017 09:09:14: 6 fields found: Connection, TableName, LoadType, StartDate, EndDate, Period, 3 lines fetched

10/05/2017 09:09:14: 0045 FOR i=0 to FieldValueCount('TableName') - 1

10/05/2017 09:09:14: 0046 Let vCon = peek('Connection',0)

10/05/2017 09:09:14: 0047 trace 200

10/05/2017 09:09:14: 0047 200

10/05/2017 09:09:14: 0049 If 200 = 200 then

10/05/2017 09:09:14: 0050 CUSTOM CONNECT*Provider*QvBigQueryConnector.exe*XUserId*XPassword*

10/05/2017 09:09:19: 0051 ENDIF

10/05/2017 09:09:19: 0054 If 200 = 300 then

10/05/2017 09:09:19: 0058 LET vTableName = peek('TableName',0)

10/05/2017 09:09:19: 0059 trace store_pick.Payments

10/05/2017 09:09:19: 0059 store_pick.Payments

10/05/2017 09:09:19: 0060 LET vLoadType = peek('LoadType',0)

10/05/2017 09:09:19: 0061 trace 1

10/05/2017 09:09:19: 0061 1

10/05/2017 09:09:19: 0063 Let vMax ='store_pick.Payments'&'_Max'

10/05/2017 09:09:19: 0065 LET vStartDate = peek('StartDate',0)

10/05/2017 09:09:19: 0066 trace 20170427

10/05/2017 09:09:19: 0066 20170427

10/05/2017 09:09:19: 0067 LET vEndDate = peek('EndDate',0)

10/05/2017 09:09:19: 0068 trace 20170505

10/05/2017 09:09:19: 0068 20170505

10/05/2017 09:09:19: 0075 If 1 = 0 then

10/05/2017 09:09:19: 0087 If 1 = 1 then

10/05/2017 09:09:19: 0088 Load Max(maxLoad) as maxLoad

10/05/2017 09:09:19: 0089 from

10/05/2017 09:09:19: 0090 [store_pick.Payments_Max.qvd](qvd)

10/05/2017 09:09:19: 1 fields found: maxLoad, 1 lines fetched

10/05/2017 09:09:19: 0092 vStartDate= Date(Date#(Peek('maxLoad',0),'YYYYMMDD')+1,'YYYYMMDD')

10/05/2017 09:09:19: 0094 trace 20170509

10/05/2017 09:09:19: 0094 20170509

10/05/2017 09:09:19: 0095 vEndDate = 20170508

10/05/2017 09:09:19: 0096 trace 20170508

10/05/2017 09:09:19: 0096 20170508

10/05/2017 09:09:19: 0097 ENDIF

10/05/2017 09:09:19: 0099 If 1 = 2 then

10/05/2017 09:09:19: 0114 IF 200 = 200 then

10/05/2017 09:09:19: 0115 store_pick.Payments:

10/05/2017 09:09:19: 0116 SQL

10/05/2017 09:09:19: 0117

10/05/2017 09:09:19: 0118 SELECT * , Integer(STRFTIME_UTC_USEC(createdDate,"%Y%m%d")) as loadDateKey FROM store_pick.Payments

10/05/2017 09:09:19: 0119 where Integer(STRFTIME_UTC_USEC(createdDate,"%Y%m%d")) >= 20170509

10/05/2017 09:09:19: 0120 and Integer(STRFTIME_UTC_USEC(createdDate,"%Y%m%d")) <= 20170508

10/05/2017 09:09:21: 21 fields found: paymentId, orderId, customerId, retailerCustomerId, paymentStatusUpdatedDateTime, finalTotalAmount, paymentCurrency, fundingInstrument, paymentServiceProvider, paymentCompletionDateTime, transactionId, transactionType, transactionStatus, transactionCode, failureReason, createdDate, createdBy, fileName, partitionDt, version, loadDateKey, 0 lines fetched

10/05/2017 09:09:21: 0124 store_pick.Payments_Max:

10/05/2017 09:09:21: 0125

10/05/2017 09:09:21: 0126 LOAD max(loadDateKey) as maxLoad

10/05/2017 09:09:21: 0127 Resident store_pick.Payments

10/05/2017 09:09:21: 1 fields found: maxLoad, 1 lines fetched

10/05/2017 09:09:21: 0128 STORE store_pick.Payments_Max into [store_pick.Payments_Max.qvd](qvd)

10/05/2017 09:09:21: 0129 DROP Table store_pick.Payments_Max

10/05/2017 09:09:21: 0133 ENDIF

10/05/2017 09:09:21: 0135 IF 200 = 300 then

10/05/2017 09:09:21: 0158 IF noOfRows('store_pick.Payments') <> 0 then

10/05/2017 09:09:21: 0211 DROP Table store_pick.Payments

10/05/2017 09:09:21: 0223 NEXT i

10/05/2017 09:09:21: 0046 Let vCon = peek('Connection',1)

10/05/2017 09:09:21: 0047 trace 200

10/05/2017 09:09:21: 0047 200

10/05/2017 09:09:21: 0049 If 200 = 200 then

10/05/2017 09:09:21: 0050 CUSTOM CONNECT*Provider*QvBigQueryConnector.exe*XUserId*XPassword*

10/05/2017 09:09:25: 0051 ENDIF

10/05/2017 09:09:25: 0054 If 200 = 300 then

10/05/2017 09:09:25: 0058 LET vTableName = peek('TableName',1)

10/05/2017 09:09:25: 0059 trace store_pick.Refunds

10/05/2017 09:09:25: 0059 store_pick.Refunds

10/05/2017 09:09:25: 0060 LET vLoadType = peek('LoadType',1)

10/05/2017 09:09:25: 0061 trace 1

10/05/2017 09:09:25: 0061 1

10/05/2017 09:09:25: 0063 Let vMax ='store_pick.Refunds'&'_Max'

10/05/2017 09:09:25: 0065 LET vStartDate = peek('StartDate',1)

10/05/2017 09:09:25: 0066 trace 20170430

10/05/2017 09:09:25: 0066 20170430

10/05/2017 09:09:25: 0067 LET vEndDate = peek('EndDate',1)

10/05/2017 09:09:25: 0068 trace 20170505

10/05/2017 09:09:25: 0068 20170505

10/05/2017 09:09:25: 0075 If 1 = 0 then

10/05/2017 09:09:25: 0087 If 1 = 1 then

10/05/2017 09:09:25: 0088 Load Max(maxLoad) as maxLoad

10/05/2017 09:09:25: 0089 from

10/05/2017 09:09:25: 0090 [store_pick.Refunds_Max.qvd](qvd)

10/05/2017 09:09:25: 1 fields found: maxLoad, 1 lines fetched

10/05/2017 09:09:25: 0092 vStartDate= Date(Date#(Peek('maxLoad',0),'YYYYMMDD')+1,'YYYYMMDD')

10/05/2017 09:09:25: 0094 trace 20170509

10/05/2017 09:09:25: 0094 20170509

10/05/2017 09:09:25: 0095 vEndDate = 20170508

10/05/2017 09:09:25: 0096 trace 20170508

10/05/2017 09:09:25: 0096 20170508

10/05/2017 09:09:25: 0097 ENDIF

10/05/2017 09:09:25: 0099 If 1 = 2 then

10/05/2017 09:09:25: 0114 IF 200 = 200 then

10/05/2017 09:09:25: 0115 store_pick.Refunds:

10/05/2017 09:09:25: 0116 SQL

10/05/2017 09:09:25: 0117

10/05/2017 09:09:25: 0118 SELECT * , Integer(STRFTIME_UTC_USEC(createdDate,"%Y%m%d")) as loadDateKey FROM store_pick.Refunds

10/05/2017 09:09:25: 0119 where Integer(STRFTIME_UTC_USEC(createdDate,"%Y%m%d")) >= 20170509

10/05/2017 09:09:25: 0120 and Integer(STRFTIME_UTC_USEC(createdDate,"%Y%m%d")) <= 20170508

10/05/2017 09:09:28: 27 fields found: refundId, refundRequestSource, refundRequestDateTime, paymentId, orderId, customerId, retailerCustomerId, refundType, refundReason, refundAmountRequested, refundAmountAuthorized, refundAuthorizedDateTime, finalRefundTotalAmount, paymentCurrency, fundingInstrument, paymentServiceProvider, paymentCompletionDateTime, transactionId, transactionStatus, transactionCode, failureReason, createdDate, createdBy, fileName, partitionDt, version, loadDateKey, 0 lines fetched

10/05/2017 09:09:28: 0124 store_pick.Refunds_Max:

10/05/2017 09:09:28: 0125

10/05/2017 09:09:28: 0126 LOAD max(loadDateKey) as maxLoad

10/05/2017 09:09:28: 0127 Resident store_pick.Refunds

10/05/2017 09:09:28: 1 fields found: maxLoad, 1 lines fetched

10/05/2017 09:09:28: 0128 STORE store_pick.Refunds_Max into [store_pick.Refunds_Max.qvd](qvd)

10/05/2017 09:09:28: 0129 DROP Table store_pick.Refunds_Max

10/05/2017 09:09:28: 0133 ENDIF

10/05/2017 09:09:28: 0135 IF 200 = 300 then

10/05/2017 09:09:28: 0158 IF noOfRows('store_pick.Refunds') <> 0 then

10/05/2017 09:09:28: 0211 DROP Table store_pick.Refunds

10/05/2017 09:09:28: 0223 NEXT i

10/05/2017 09:09:28: 0046 Let vCon = peek('Connection',2)

10/05/2017 09:09:28: 0047 trace 300

10/05/2017 09:09:28: 0047 300

10/05/2017 09:09:28: 0049 If 300 = 200 then

10/05/2017 09:09:28: 0054 If 300 = 300 then

10/05/2017 09:09:28: 0055 OLEDB CONNECT*Provider*XPassword*

10/05/2017 09:09:28: 0056 ENDIF

10/05/2017 09:09:28: 0058 LET vTableName = peek('TableName',2)

10/05/2017 09:09:28: 0059 trace BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY

10/05/2017 09:09:28: 0059 BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY

10/05/2017 09:09:28: 0060 LET vLoadType = peek('LoadType',2)

10/05/2017 09:09:28: 0061 trace 2

10/05/2017 09:09:28: 0061 2

10/05/2017 09:09:28: 0063 Let vMax ='BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY'&'_Max'

10/05/2017 09:09:28: 0065 LET vStartDate = peek('StartDate',2)

10/05/2017 09:09:28: 0066 trace 20170427

10/05/2017 09:09:28: 0066 20170427

10/05/2017 09:09:28: 0067 LET vEndDate = peek('EndDate',2)

10/05/2017 09:09:28: 0068 trace 20170505

10/05/2017 09:09:28: 0068 20170505

10/05/2017 09:09:28: 0075 If 2 = 0 then

10/05/2017 09:09:28: 0087 If 2 = 1 then

10/05/2017 09:09:28: 0099 If 2 = 2 then

10/05/2017 09:09:28: 0106 LET vStartDate = peek('StartDate',2)

10/05/2017 09:09:28: 0107 trace 20170427

10/05/2017 09:09:28: 0107 20170427

10/05/2017 09:09:28: 0108 LET vEndDate = 20170508

10/05/2017 09:09:28: 0109 trace 20170508

10/05/2017 09:09:28: 0109 20170508

10/05/2017 09:09:28: 0111 ENDIF

10/05/2017 09:09:28: 0114 IF 300 = 200 then

10/05/2017 09:09:28: 0135 IF 300 = 300 then

10/05/2017 09:09:28: 0136 BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY:

10/05/2017 09:09:28: 0137 SQL

10/05/2017 09:09:28: 0138 SELECT * FROM BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY

10/05/2017 09:09:28: 0139 where DAY_KEY >= 20170427

10/05/2017 09:09:28: 0140 and DAY_KEY <= 20170508

10/05/2017 09:09:28: 0141 and org_bsns_unit_key = 1

10/05/2017 09:09:29: 14 fields found: DAY_KEY, ACCTING_DAY_KEY, SKU_ITEM_KEY, ORG_BSNS_UNIT_KEY, LFL_CTGRY_KEY, SCN_SLS_UNITS, NET_AMT, SLS_TRNVR_AMT, SRC_FLG, VNDR_NBR, LOAD_DT, LAST_UPDT_DT, LAST_UPDT_BY, SLS_UOM_UNITS, 133,637 lines fetched

10/05/2017 09:10:15: 0148 BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY_Max:

10/05/2017 09:10:15: 0149

10/05/2017 09:10:15: 0150 LOAD max(DAY_KEY) as maxLoad

10/05/2017 09:10:15: 0151 Resident BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY

10/05/2017 09:10:19: 1 fields found: maxLoad, 1 lines fetched

10/05/2017 09:10:19: 0152 STORE BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY_Max into [BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY_Max.qvd](qvd)

10/05/2017 09:10:19: 0153 DROP Table BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY_Max

10/05/2017 09:10:19: 0154 ENDIF

10/05/2017 09:10:19: 0158 IF noOfRows('BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY') <> 0 then

10/05/2017 09:10:19: 0159 If 2 = 0 then

10/05/2017 09:10:19: 0163 If 2 = 1 then

10/05/2017 09:10:19: 0172 If 2 = 2 then

10/05/2017 09:10:19: 0173 Let vFromDate = Date(Date#(20170427,'YYYYMMDD'),'YYYYMMDD')

10/05/2017 09:10:19: 0174 TRACE ---20170427

10/05/2017 09:10:19: 0174 ---20170427

10/05/2017 09:10:19: 0176 Let vToDate = Date(Date#(20170508,'YYYYMMDD')- 1,'YYYYMMDD')

10/05/2017 09:10:19: 0177 Trace ---20170507

10/05/2017 09:10:19: 0177 ---20170507

10/05/2017 09:10:19: 0190 FOR j=vFromDate to vToDate

10/05/2017 09:10:19: 0191 Let vFromDate = Date(Date#(20170427,'YYYYMMDD') + 1,'YYYYMMDD')

10/05/2017 09:10:19: 0192 TRACE -- 20170428

10/05/2017 09:10:19: 0192 -- 20170428

10/05/2017 09:10:19: 0193 Let Day_Table = 'BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY'&'_'&'20170428'

10/05/2017 09:10:19: 0194 BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY_20170428:

10/05/2017 09:10:19: 0195 SQL

10/05/2017 09:10:19: 0196 SELECT * FROM BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY

10/05/2017 09:10:19: 0197 where DAY_KEY = 20170428

10/05/2017 09:10:19: 0198 and org_bsns_unit_key = 1

10/05/2017 09:10:19: 14 fields found: DAY_KEY, ACCTING_DAY_KEY, SKU_ITEM_KEY, ORG_BSNS_UNIT_KEY, LFL_CTGRY_KEY, SCN_SLS_UNITS, NET_AMT, SLS_TRNVR_AMT, SRC_FLG, VNDR_NBR, LOAD_DT, LAST_UPDT_DT, LAST_UPDT_BY, SLS_UOM_UNITS, 145,843 lines fetched

10/05/2017 09:10:20: 0199 STORE [BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY_20170428] into [BIA_RTL.DWA_X_RTL_SL_ITEM_LOC_DAY_20170428.qvd] (qvd)

10/05/2017 09:10:20: Error: Table not found

10/05/2017 09:12:16: General Script Error

10/05/2017 09:12:16: Execution Failed

10/05/2017 09:12:16: Execution finished.

topic Re: Issue in while storing data into qvd in QlikView

Issue in while storing data into qvd

Re: Issue in while storing data into qvd

Re: Issue in while storing data into qvd

Re: Issue in while storing data into qvd

Re: Issue in while storing data into qvd