Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Reload app failed in QMC task when creating once-only trigger
Hi Skyler, could you please have a look or attach here the log file to see the error.
Best regards,
Andrés
2016-09-14 15:31:49 Execution started.
2016-09-14 15:31:49 Qlik Sense Server Version 3.0.1+Build:62.release/ms17
2016-09-14 15:31:49 CPU Target x64
2016-09-14 15:31:49 Operating System Windows Server 2012 R2 Standard (64 bit edition)
2016-09-14 15:31:49 Wow64 mode Not using Wow64
2016-09-14 15:31:49 Language 0409 English (United States) English
2016-09-14 15:31:49 Country 1 United States United States
2016-09-14 15:31:49 MDAC Version 6.3.9600.16384
2016-09-14 15:31:49 MDAC Full Install Version 6.3.9600.16384
2016-09-14 15:31:49 PreferredCompression 2
2016-09-14 15:31:49 EnableParallelReload 1
2016-09-14 15:31:49 ParallelizeQvdLoads 1
2016-09-14 15:31:49 EnableFlushLog 0
2016-09-14 15:31:49 UserLogfileCharset 65001
2016-09-14 15:31:49 OdbcLoginTimeout -1
2016-09-14 15:31:49 OdbcConnectionTimeout -1
2016-09-14 15:31:49 LongestPossibleLine 1048576
2016-09-14 15:31:49 ScriptWantsDbWrite false
2016-09-14 15:31:49 ScriptWantsExe false
2016-09-14 15:31:49 LogFile CodePage Used: 65001
2016-09-14 15:31:49 UseMemoryFillPattern 1
2016-09-14 15:31:49 ScriptMode Standard (limits system access)
2016-09-14 15:31:49 ReloadCodebase Classic
2016-09-14 15:31:50 Reload Executed By UserDirectory=INTERNAL; UserId=sa_scheduler
2016-09-14 15:31:50 Process Executing Qlik Sense Server
2016-09-14 15:31:50 Process ID 2856
2016-09-14 15:31:50 0002 SET ThousandSep=','
2016-09-14 15:31:50 0003 SET DecimalSep='.'
2016-09-14 15:31:50 0004 SET MoneyThousandSep=','
2016-09-14 15:31:50 0005 SET MoneyDecimalSep='.'
2016-09-14 15:31:50 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'
2016-09-14 15:31:50 0007 SET TimeFormat='h:mm:ss TT'
2016-09-14 15:31:50 0008 SET DateFormat='DD/MM/YYYY'
2016-09-14 15:31:50 0009 SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT'
2016-09-14 15:31:50 0010 SET FirstWeekDay=6
2016-09-14 15:31:50 0011 SET BrokenWeeks=1
2016-09-14 15:31:50 0012 SET ReferenceDay=0
2016-09-14 15:31:50 0013 SET FirstMonthOfYear=1
2016-09-14 15:31:50 0014 SET CollationLocale='en-US'
2016-09-14 15:31:50 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2016-09-14 15:31:50 0016 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'
2016-09-14 15:31:50 0017 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2016-09-14 15:31:50 0018 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'
2016-09-14 15:31:50 0021 *** CONNECT TO ***
2016-09-14 15:31:50 0024 SELECT CHARM.ITMMVT.ITMREF_0 as [Item Reference],
2016-09-14 15:31:50 0025 ITMDES1_0 as [Item Description],
2016-09-14 15:31:50 0026 STOFCY_0 as Company,
2016-09-14 15:31:50 0027 convert(DOUBLE PRECISION,PHYSTO_0) as [Total Stock],
2016-09-14 15:31:50 0028 convert(DOUBLE PRECISION,PHYALL_0) as [Allocated Stock],
2016-09-14 15:31:50 0029 convert(DOUBLE PRECISION,AVC_0) as [Average Cost],
2016-09-14 15:31:50 0030 convert(DOUBLE PRECISION,ORDSTO_0) as [Quantity on Order],
2016-09-14 15:31:50 0031 (convert(DOUBLE PRECISION,PHYSTO_0)- convert(DOUBLE PRECISION,PHYALL_0)) as [Quantity Available]
2016-09-14 15:31:50 0032 FROM CHARM.ITMMVT , CHARM.ITMMASTER
2016-09-14 15:31:50 0033 WHERE STOFCY_0 = 'MCFI'
2016-09-14 15:31:50 0034 AND CHARM.ITMMVT.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')
2016-09-14 15:31:50 0035 AND CHARM.ITMMVT.ITMREF_0 = CHARM.ITMMASTER.ITMREF_0
2016-09-14 15:31:50 8 fields found: Item Reference, Item Description, Company, Total Stock, Allocated Stock, Average Cost, Quantity on Order, Quantity Available,
2016-09-14 15:31:50 5 lines fetched
2016-09-14 15:31:50 0042 SELECT CHARM.PORDER.POHNUM_0 as PO, CHARM.PORDER.POHFCY_0 as Company1,
2016-09-14 15:31:50 0043 convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103) as [Order Date1], CHARM.PORDER.BPSNUM_0 as [Supplier Code1],
2016-09-14 15:31:50 0044 BPRNAM_0 as [Supplier Name1],
2016-09-14 15:31:50 0045
2016-09-14 15:31:50 0046 case
2016-09-14 15:31:50 0047 when CHARM.PORDER.ZETADAT_0 < '1900/01/01' then
2016-09-14 15:31:50 0048 convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103)
2016-09-14 15:31:50 0049 ELSE
2016-09-14 15:31:50 0050 convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103)
2016-09-14 15:31:50 0051 END AS ETA1,
2016-09-14 15:31:50 0052
2016-09-14 15:31:50 0053 --convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) as ETA,
2016-09-14 15:31:50 0054 CASE
2016-09-14 15:31:50 0055 WHEN CHARM.PORDER.RCPFLG_0 = '1' THEN 'NOT YET RECEIVED'
2016-09-14 15:31:50 0056 WHEN CHARM.PORDER.RCPFLG_0 = '2' THEN 'PARTLY RECEIVED'
2016-09-14 15:31:50 0057 WHEN CHARM.PORDER.RCPFLG_0 = '3' THEN 'FULLY RECEIVED'
2016-09-14 15:31:50 0058 ELSE NULL
2016-09-14 15:31:50 0059 END AS 'Status1',
2016-09-14 15:31:50 0060 CUR_0 as Currency1,
2016-09-14 15:31:50 0061 --CSORS_0,
2016-09-14 15:31:50 0062 CHGCOE_0 as [Exchange Rate1],
2016-09-14 15:31:50 0063 CHARM.PORDERQ.ITMREF_0 as [Order Item Reference1],
2016-09-14 15:31:50 0064 convert(DOUBLE PRECISION,CHARM.PORDERQ.QTYPUU_0) as [Purchase Quantity1],
2016-09-14 15:31:50 0065 convert(DOUBLE PRECISION,CHARM.PORDERQ.RCPQTYPUU_0) as [Receipt Quantity1],
2016-09-14 15:31:50 0066 convert(DOUBLE PRECISION,CHARM.PORDERQ.LINAMT_0) as [Line Amount1],
2016-09-14 15:31:50 0067 CHARM.PORDER.CLEFLG_0 as CloseFlag,ITMDES1_0 as StockDesc1
2016-09-14 15:31:50 0068 FROM CHARM.PORDER, CHARM.PORDERQ, CHARM.ITMMASTER
2016-09-14 15:31:50 0069 WHERE CHARM.PORDER.POHNUM_0 = CHARM.PORDERQ.POHNUM_0
2016-09-14 15:31:50 0070 AND CHARM.PORDER.POHFCY_0 ='MCFI'
2016-09-14 15:31:50 0071 and CHARM.PORDER.CLEFLG_0 = 1
2016-09-14 15:31:50 0072 AND CHARM.ITMMASTER.ITMREF_0 = CHARM.PORDERQ.ITMREF_0
2016-09-14 15:31:50 0073 AND CHARM.PORDERQ.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')
2016-09-14 15:31:50 0074 order by convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) desc
2016-09-14 15:31:50 0075
2016-09-14 15:31:50 15 fields found: PO, Company1, Order Date1, Supplier Code1, Supplier Name1, ETA1, Status1, Currency1, Exchange Rate1, Order Item Reference1, Purchase Quantity1, Receipt Quantity1, Line Amount1, CloseFlag, StockDesc1,
2016-09-14 15:31:50 18 lines fetched
2016-09-14 15:31:50 0077 SELECT CHARM.PORDER.POHNUM_0 as [Purchase Order],
2016-09-14 15:31:50 0078 CHARM.PORDER.POHFCY_0 as Company,
2016-09-14 15:31:50 0079 convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103) as [Order Date],
2016-09-14 15:31:50 0080 CHARM.PORDER.BPSNUM_0 as [Supplier Code],
2016-09-14 15:31:50 0081 BPRNAM_0 as [Supplier Name],
2016-09-14 15:31:50 0082
2016-09-14 15:31:50 0083 case
2016-09-14 15:31:50 0084 when CHARM.PORDER.ZETADAT_0 < '1900/01/01' then
2016-09-14 15:31:50 0085 convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103)
2016-09-14 15:31:50 0086 ELSE
2016-09-14 15:31:50 0087 convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103)
2016-09-14 15:31:50 0088 END AS ETA,
2016-09-14 15:31:50 0089
2016-09-14 15:31:50 0090 --convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) as ETA,
2016-09-14 15:31:50 0091 CASE
2016-09-14 15:31:50 0092 WHEN CHARM.PORDER.RCPFLG_0 = '1' THEN 'NOT YET RECEIVED'
2016-09-14 15:31:50 0093 WHEN CHARM.PORDER.RCPFLG_0 = '2' THEN 'PARTLY RECEIVED'
2016-09-14 15:31:50 0094 WHEN CHARM.PORDER.RCPFLG_0 = '3' THEN 'FULLY RECEIVED'
2016-09-14 15:31:50 0095 ELSE NULL
2016-09-14 15:31:50 0096 END AS 'Status',
2016-09-14 15:31:50 0097 CHARM.PORDER.CUR_0 as Currency,
2016-09-14 15:31:50 0098 CHGCOE_0 as [Exchange Rate],
2016-09-14 15:31:50 0099 CHARM.PORDERQ.ITMREF_0 as [Order Item Reference],
2016-09-14 15:31:50 0100 convert(DOUBLE PRECISION,CHARM.PORDERQ.QTYPUU_0) as [Purchase Quantity],
2016-09-14 15:31:50 0101 convert(DOUBLE PRECISION,CHARM.PORDERQ.RCPQTYPUU_0) as [Receipt Quantity],
2016-09-14 15:31:50 0102 convert(DOUBLE PRECISION,CHARM.PORDERQ.LINAMT_0) as [Line Amount],
2016-09-14 15:31:50 0103 CHARM.PORDER.CLEFLG_0,ITMDES1_0 as StockDesc,
2016-09-14 15:31:50 0104 CHARM.PORDER.EECICT_0 as Incoterm,
2016-09-14 15:31:50 0105 BPSUPPLIER.ACCCOD_0 as Type,
2016-09-14 15:31:50 0106 CASE
2016-09-14 15:31:50 0107 WHEN BPSUPPLIER.ACCCOD_0 = 'SLNG' then
2016-09-14 15:31:50 0108 'Supplier Local Non Group'
2016-09-14 15:31:50 0109 WHEN BPSUPPLIER.ACCCOD_0 = 'SLGP' THEN
2016-09-14 15:31:50 0110 'Supplier Local Group'
2016-09-14 15:31:50 0111 WHEN BPSUPPLIER.ACCCOD_0 = 'SFGP' THEN
2016-09-14 15:31:50 0112 'Supplier Foreign Group'
2016-09-14 15:31:50 0113 WHEN BPSUPPLIER.ACCCOD_0 = 'SFNG' THEN
2016-09-14 15:31:50 0114 'Supplier Foreign Non Group'
2016-09-14 15:31:50 0115
2016-09-14 15:31:50 0116 END AS Foreign_Local,
2016-09-14 15:31:50 0117
2016-09-14 15:31:50 0118 CHARM.PORDERQ.STU_0 as ORD_UOM
2016-09-14 15:31:50 0119
2016-09-14 15:31:50 0120 FROM CHARM.PORDER, CHARM.PORDERQ, CHARM.ITMMASTER,CHARM.BPSUPPLIER BPSUPPLIER
2016-09-14 15:31:50 0121 WHERE CHARM.PORDER.POHNUM_0 = CHARM.PORDERQ.POHNUM_0
2016-09-14 15:31:50 0122 --AND CHARM.PORDER.POHFCY_0 ='MCFI'
2016-09-14 15:31:50 0123 AND CHARM.ITMMASTER.ITMREF_0 = CHARM.PORDERQ.ITMREF_0
2016-09-14 15:31:50 0124 --AND CHARM.PORDERQ.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')
2016-09-14 15:31:50 0125 AND BPSUPPLIER.BPSNUM_0 = CHARM.PORDER.BPSNUM_0
2016-09-14 15:31:50 0126 order by convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) desc
2016-09-14 15:31:51 19 fields found: Purchase Order, Company, Order Date, Supplier Code, Supplier Name, ETA, Status, Currency, Exchange Rate, Order Item Reference, Purchase Quantity, Receipt Quantity, Line Amount, CLEFLG_0, StockDesc, Incoterm, Type, Foreign_Local, ORD_UOM,
2016-09-14 15:31:51 12,103 lines fetched
2016-09-14 15:31:51 0130 SELECT MFGHEAD.MFGNUM_0 as [Works Order], MFGHEAD.ROUNUM_0 as[Finished Good Code],
2016-09-14 15:31:51 0131 convert(varchar(10),MFGHEAD.STRDAT_0, 103) as [Start Date],
2016-09-14 15:31:51 0132 YEAR(MFGHEAD.STRDAT_0) as [WIP Yearly],
2016-09-14 15:31:51 0133 --QuarterName(MFGHEAD.STRDAT_0) as [WIP Quarter],
2016-09-14 15:31:51 0134 left(datename(month, STRDAT_0 ),3) as [WIP Monthly],
2016-09-14 15:31:51 0135 Day(MFGHEAD.STRDAT_0)as [WIP Day],
2016-09-14 15:31:51 0136 MFGHEAD.ROUALT_0 as [Route Code] ,
2016-09-14 15:31:51 0137 CASE
2016-09-14 15:31:51 0138 WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)
2016-09-14 15:31:51 0139 WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg
2016-09-14 15:31:51 0140 ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)
2016-09-14 15:31:51 0141 END AS [Expected Qty],
2016-09-14 15:31:51 0142 --convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0) * 1000 as [Expected Qty],
2016-09-14 15:31:51 0143 MFGHEAD.STU_0 as UOM,
2016-09-14 15:31:51 0144 WIPCOST.ITMREF_0 as [WIP Item Reference],
2016-09-14 15:31:51 0145 convert(DOUBLE PRECISION,WIPCOST.QTY_0) as [BOM QTY], WIPCOST.WIPSEQ_0 as [Sequence],
2016-09-14 15:31:51 0146 --convert(DOUBLE PRECISION,WIPCOST.QTYACT_0) as [Actual Qty],
2016-09-14 15:31:51 0147
2016-09-14 15:31:51 0148 CASE
2016-09-14 15:31:51 0149 WHEN WIPCOST.STU_0 = 'T' THEN convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000)
2016-09-14 15:31:51 0150 WHEN WIPCOST.STU_0 = 'L' THEN convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15) --1.15kg
2016-09-14 15:31:51 0151 ELSE convert(DOUBLE PRECISION,WIPCOST.QTYACT_0)
2016-09-14 15:31:51 0152 END AS [Actual Qty],
2016-09-14 15:31:51 0153
2016-09-14 15:31:51 0154 convert(DOUBLE PRECISION,WIPCOST.REJQTY_0) as [Rejected Qty],
2016-09-14 15:31:51 0155 convert(DOUBLE PRECISION,WIPCOST.UNTCST_0) as [Unit Cost],
2016-09-14 15:31:51 0156 convert(DOUBLE PRECISION,WIPCOST.AMOUNT_0) as [Total Cost],
2016-09-14 15:31:51 0157 WIPCOST.MATGRP_0 as [MAT Group],
2016-09-14 15:31:51 0158 WIPCOST.OVENAT_0 as [Overhead Code],
2016-09-14 15:31:51 0159
2016-09-14 15:31:51 0160 CASE
2016-09-14 15:31:51 0161 WHEN WIPCOST.STU_0 = 'T' THEN 'KG'
2016-09-14 15:31:51 0162 WHEN WIPCOST.STU_0 = 'L' THEN 'KG'
2016-09-14 15:31:51 0163
2016-09-14 15:31:51 0164 ELSE WIPCOST.STU_0
2016-09-14 15:31:51 0165 END AS [UOM Raw Mat],
2016-09-14 15:31:51 0166
2016-09-14 15:31:51 0167 --WIPCOST.STU_0 as [UOM Raw Mat],
2016-09-14 15:31:51 0168 MFGHEAD.MFGFCY_0 as [Site Code], MFGHEAD.MFGSTA_0 as [Status],
2016-09-14 15:31:51 0169 CHARM.ITMMASTER.TSICOD_0 as Category0,CHARM.ITMMASTER.TSICOD_1 as Category1
2016-09-14 15:31:51 0170 FROM CHARM.ITMMASTER , x3data.CHARM.MFGHEAD MFGHEAD
2016-09-14 15:31:51 0171 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0
2016-09-14 15:31:51 0172 WHERE WIPCOST.MATGRP_0=1
2016-09-14 15:31:51 0173 AND CHARM.ITMMASTER.ITMREF_0 = MFGHEAD.ROUNUM_0
2016-09-14 15:31:51 0174 AND MFGHEAD.MFGFCY_0=N'MCFI'
2016-09-14 15:31:51 0175 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'
2016-09-14 15:31:51 0176
2016-09-14 15:31:51 0177 and MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0
2016-09-14 15:31:51 0178 ORDER BY MFGHEAD.MFGNUM_0, WIPCOST.WIPSEQ_0
2016-09-14 15:31:51 0179 '
2016-09-14 15:31:51 0180
2016-09-14 15:31:51 23 fields found: Works Order, Finished Good Code, Start Date, WIP Yearly, WIP Monthly, WIP Day, Route Code, Expected Qty, UOM, WIP Item Reference, BOM QTY, Sequence, Actual Qty, Rejected Qty, Unit Cost, Total Cost, MAT Group, Overhead Code, UOM Raw Mat, Site Code, Status, Category0, Category1,
2016-09-14 15:31:51 5,994 lines fetched
2016-09-14 15:31:51 0191 select MFGHEAD.MFGNUM_0 as [RMUE Works Order] ,
2016-09-14 15:31:51 0192 YEAR(MFGHEAD.STRDAT_0) as [RMUE WIP Yearly],
2016-09-14 15:31:51 0193 convert(varchar(10),MFGHEAD.STRDAT_0, 103) as [RMUE Start Date],
2016-09-14 15:31:51 0194 Month(STRDAT_0) as [RMUE WIP Monthly],
2016-09-14 15:31:51 0195
2016-09-14 15:31:51 0196 CASE WHEN MFGHEAD.ROUNUM_0 = WIPCOST.ITMREF_0 then
2016-09-14 15:31:51 0197
2016-09-14 15:31:51 0198 CASE
2016-09-14 15:31:51 0199 WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)
2016-09-14 15:31:51 0200 WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg
2016-09-14 15:31:51 0201 ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)
2016-09-14 15:31:51 0202 END
2016-09-14 15:31:51 0203 else 0
2016-09-14 15:31:51 0204 END AS [RMUE Expected Qty],
2016-09-14 15:31:51 0205 MFGHEAD.STU_0 as RMUE_UOM,
2016-09-14 15:31:51 0206 CASE WHEN MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0 then
2016-09-14 15:31:51 0207
2016-09-14 15:31:51 0208 CASE
2016-09-14 15:31:51 0209 WHEN WIPCOST.STU_0 = 'T' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000 ))
2016-09-14 15:31:51 0210 WHEN WIPCOST.STU_0 = 'L' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15)) --1.15kg
2016-09-14 15:31:51 0211 ELSE sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0))
2016-09-14 15:31:51 0212 END
2016-09-14 15:31:51 0213 else 0
2016-09-14 15:31:51 0214 END AS [RMUE Actual Qty],
2016-09-14 15:31:51 0215
2016-09-14 15:31:51 0216 CASE
2016-09-14 15:31:51 0217 WHEN WIPCOST.STU_0 = 'T' THEN 'KG'
2016-09-14 15:31:51 0218 WHEN WIPCOST.STU_0 = 'L' THEN 'KG'
2016-09-14 15:31:51 0219 ELSE WIPCOST.STU_0
2016-09-14 15:31:51 0220 END AS [RMUE UOM Raw Mat]
2016-09-14 15:31:51 0221
2016-09-14 15:31:51 0222
2016-09-14 15:31:51 0223 FROM x3data.CHARM.MFGHEAD MFGHEAD
2016-09-14 15:31:51 0224 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0
2016-09-14 15:31:51 0225 WHERE WIPCOST.MATGRP_0=1
2016-09-14 15:31:51 0226 AND MFGHEAD.MFGFCY_0=N'MCFI'
2016-09-14 15:31:51 0227 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'
2016-09-14 15:31:51 0228 --AND MFGHEAD.MFGNUM_0 ='MCFI1501MFG00000004'
2016-09-14 15:31:51 0229 group by MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0,MFGHEAD.MFGNUM_0,MFGHEAD.STRDAT_0,
2016-09-14 15:31:51 0230 MFGHEAD.STU_0,MFGHEAD.EXTQTY_0,WIPCOST.STU_0
2016-09-14 15:31:51 0231 order by MFGHEAD.MFGNUM_0
2016-09-14 15:31:52 8 fields found: RMUE Works Order, RMUE WIP Yearly, RMUE Start Date, RMUE WIP Monthly, RMUE Expected Qty, RMUE_UOM, RMUE Actual Qty, RMUE UOM Raw Mat,
2016-09-14 15:31:52 7,721 lines fetched
2016-09-14 15:31:52 0234 TranDet:
2016-09-14 15:31:52 0235
2016-09-14 15:31:52 0236 select MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0 as [RMUE2 WIP Item Reference],MFGHEAD.MFGNUM_0 as [RMUE2 Works Order] ,
2016-09-14 15:31:52 0237 YEAR(MFGHEAD.STRDAT_0) as [RMUE2 WIP Yearly],
2016-09-14 15:31:52 0238 convert(varchar(10),MFGHEAD.STRDAT_0, 103) as [RMUE2 Start Date],
2016-09-14 15:31:52 0239 left(datename(month, STRDAT_0 ),3) as [RMUE2 WIP Monthly],
2016-09-14 15:31:52 0240
2016-09-14 15:31:52 0241 CASE WHEN MFGHEAD.ROUNUM_0 = WIPCOST.ITMREF_0 then
2016-09-14 15:31:52 0242
2016-09-14 15:31:52 0243 CASE
2016-09-14 15:31:52 0244 WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)
2016-09-14 15:31:52 0245 WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg
2016-09-14 15:31:52 0246 ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)
2016-09-14 15:31:52 0247 END
2016-09-14 15:31:52 0248 else 0
2016-09-14 15:31:52 0249 END AS [RMUE2 Expected Qty],
2016-09-14 15:31:52 0250 MFGHEAD.STU_0 as RMUE2_UOM,
2016-09-14 15:31:52 0251 CASE WHEN MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0 then
2016-09-14 15:31:52 0252
2016-09-14 15:31:52 0253 CASE
2016-09-14 15:31:52 0254 WHEN WIPCOST.STU_0 = 'T' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000 ))
2016-09-14 15:31:52 0255 WHEN WIPCOST.STU_0 = 'L' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15)) --1.15kg
2016-09-14 15:31:52 0256 ELSE sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0))
2016-09-14 15:31:52 0257 END
2016-09-14 15:31:52 0258 else 0
2016-09-14 15:31:52 0259 END AS [RMUE2 Actual Qty],
2016-09-14 15:31:52 0260 CASE
2016-09-14 15:31:52 0261 WHEN WIPCOST.STU_0 = 'T' THEN 'KG'
2016-09-14 15:31:52 0262 WHEN WIPCOST.STU_0 = 'L' THEN 'KG'
2016-09-14 15:31:52 0263 ELSE WIPCOST.STU_0
2016-09-14 15:31:52 0264 END AS [RMUE2 UOM Raw Mat]
2016-09-14 15:31:52 0265
2016-09-14 15:31:52 0266
2016-09-14 15:31:52 0267 FROM x3data.CHARM.MFGHEAD MFGHEAD
2016-09-14 15:31:52 0268 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0
2016-09-14 15:31:52 0269 WHERE WIPCOST.MATGRP_0=1
2016-09-14 15:31:52 0270 AND MFGHEAD.MFGFCY_0=N'MCFI'
2016-09-14 15:31:52 0271 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'
2016-09-14 15:31:52 0272 --AND MFGHEAD.MFGNUM_0 ='MCFI1501MFG00000004'
2016-09-14 15:31:52 0273 group by MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0,MFGHEAD.MFGNUM_0,MFGHEAD.STRDAT_0,
2016-09-14 15:31:52 0274 MFGHEAD.STU_0,MFGHEAD.EXTQTY_0,WIPCOST.STU_0
2016-09-14 15:31:52 0275
2016-09-14 15:31:52 10 fields found: ROUNUM_0, RMUE2 WIP Item Reference, RMUE2 Works Order, RMUE2 WIP Yearly, RMUE2 Start Date, RMUE2 WIP Monthly, RMUE2 Expected Qty, RMUE2_UOM, RMUE2 Actual Qty, RMUE2 UOM Raw Mat,
2016-09-14 15:31:52 7,721 lines fetched
2016-09-14 15:31:52 0276 Final:
2016-09-14 15:31:52 0277 Load
2016-09-14 15:31:52 0278 [RMUE2 Works Order] as WIPWO,
2016-09-14 15:31:52 0279 Sum([RMUE2 Expected Qty]) AS [RMUE2 Expected Qty2],
2016-09-14 15:31:52 0280 Sum([RMUE2 Actual Qty]) AS [RMUE2 Actual Qty2],
2016-09-14 15:31:52 0281 (1-Sum([RMUE2 Actual Qty])/Sum([RMUE2 Expected Qty])) * 100 as RMUEE
2016-09-14 15:31:52 0282
2016-09-14 15:31:52 0283 Resident TranDet Group By [RMUE2 Works Order]
2016-09-14 15:31:52 4 fields found: WIPWO, RMUE2 Expected Qty2, RMUE2 Actual Qty2, RMUEE,
2016-09-14 15:31:52 1,848 lines fetched
2016-09-14 15:31:52 0286 STOJOU:
2016-09-14 15:31:52 0287 SELECT CHARM.STOJOU.ITMREF_0 as [STOJOU Item Reference],
2016-09-14 15:31:52 0288 ITMDES1_0 as [STOJOU Item Description],
2016-09-14 15:31:52 0289 STOFCY_0 as STOJOUCompan,
2016-09-14 15:31:52 0290 --convert(varchar(10),IPTDAT_0, 103) as [TransactionDate],
2016-09-14 15:31:52 0291 IPTDAT_0 as TransactionDate,
2016-09-14 15:31:52 0292 --convert(varchar(4),year(IPTDAT_0)) as STOJOUYEAR,
2016-09-14 15:31:52 0293 sum(convert(DOUBLE PRECISION,QTYSTU_0)) as Quantit,
2016-09-14 15:31:52 0294 sum(convert(DOUBLE PRECISION,VARVAL_0)) as Valu
2016-09-14 15:31:52 0295 FROM CHARM.STOJOU, CHARM.ITMMASTER
2016-09-14 15:31:52 0296 WHERE STOFCY_0 = 'MCFI'
2016-09-14 15:31:52 0297
2016-09-14 15:31:52 0298
2016-09-14 15:31:52 0299 AND CHARM.STOJOU.ITMREF_0 = CHARM.ITMMASTER.ITMREF_0
2016-09-14 15:31:52 0300 --and IPTDAT_0<= dateadd(dd,-1,dateadd(mm,datediff(mm,0,IPTDAT_0)+1,0))
2016-09-14 15:31:52 0301 GROUP BY CHARM.STOJOU.ITMREF_0,ITMDES1_0,STOFCY_0
2016-09-14 15:31:52 0302 ,IPTDAT_0
2016-09-14 15:31:52 0303 order by 4
2016-09-14 15:31:52 0304
Is that the complete log? Cause it's not showing any error and it seems like something is missing. If that's the complete log I would say that the mistake could be a network shutdown or something external to QS. Could you please verify if the log file that you pasted is complete??
Cheers,
Andrés
2016-09-15 10:20:13 Execution started.
2016-09-15 10:20:13 Qlik Sense Server Version 3.0.1+Build:62.release/ms17
2016-09-15 10:20:13 CPU Target x64
2016-09-15 10:20:13 Operating System Windows Server 2012 R2 Standard (64 bit edition)
2016-09-15 10:20:13 Wow64 mode Not using Wow64
2016-09-15 10:20:13 Language 0409 English (United States) English
2016-09-15 10:20:13 Country 1 United States United States
2016-09-15 10:20:13 MDAC Version 6.3.9600.16384
2016-09-15 10:20:13 MDAC Full Install Version 6.3.9600.16384
2016-09-15 10:20:13 PreferredCompression 2
2016-09-15 10:20:13 EnableParallelReload 1
2016-09-15 10:20:13 ParallelizeQvdLoads 1
2016-09-15 10:20:13 EnableFlushLog 0
2016-09-15 10:20:13 UserLogfileCharset 65001
2016-09-15 10:20:13 OdbcLoginTimeout -1
2016-09-15 10:20:13 OdbcConnectionTimeout -1
2016-09-15 10:20:13 LongestPossibleLine 1048576
2016-09-15 10:20:13 ScriptWantsDbWrite false
2016-09-15 10:20:13 ScriptWantsExe false
2016-09-15 10:20:13 LogFile CodePage Used: 65001
2016-09-15 10:20:13 UseMemoryFillPattern 1
2016-09-15 10:20:13 ScriptMode Standard (limits system access)
2016-09-15 10:20:13 ReloadCodebase Classic
2016-09-15 10:20:13 Reload Executed By UserDirectory=INTERNAL; UserId=sa_scheduler
2016-09-15 10:20:13 Process Executing Qlik Sense Server
2016-09-15 10:20:13 Process ID 2856
2016-09-15 10:20:13 0002 SET ThousandSep=','
2016-09-15 10:20:13 0003 SET DecimalSep='.'
2016-09-15 10:20:13 0004 SET MoneyThousandSep=','
2016-09-15 10:20:13 0005 SET MoneyDecimalSep='.'
2016-09-15 10:20:13 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'
2016-09-15 10:20:13 0007 SET TimeFormat='h:mm:ss TT'
2016-09-15 10:20:13 0008 SET DateFormat='DD/MM/YYYY'
2016-09-15 10:20:13 0009 SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT'
2016-09-15 10:20:13 0010 SET FirstWeekDay=6
2016-09-15 10:20:13 0011 SET BrokenWeeks=1
2016-09-15 10:20:13 0012 SET ReferenceDay=0
2016-09-15 10:20:13 0013 SET FirstMonthOfYear=1
2016-09-15 10:20:13 0014 SET CollationLocale='en-US'
2016-09-15 10:20:13 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2016-09-15 10:20:13 0016 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'
2016-09-15 10:20:13 0017 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2016-09-15 10:20:13 0018 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'
2016-09-15 10:20:13 0021 *** CONNECT TO ***
2016-09-15 10:20:13 0024 SELECT CHARM.ITMMVT.ITMREF_0 as [Item Reference],
2016-09-15 10:20:13 0025 ITMDES1_0 as [Item Description],
2016-09-15 10:20:13 0026 STOFCY_0 as Company,
2016-09-15 10:20:13 0027 convert(DOUBLE PRECISION,PHYSTO_0) as [Total Stock],
2016-09-15 10:20:13 0028 convert(DOUBLE PRECISION,PHYALL_0) as [Allocated Stock],
2016-09-15 10:20:13 0029 convert(DOUBLE PRECISION,AVC_0) as [Average Cost],
2016-09-15 10:20:13 0030 convert(DOUBLE PRECISION,ORDSTO_0) as [Quantity on Order],
2016-09-15 10:20:13 0031 (convert(DOUBLE PRECISION,PHYSTO_0)- convert(DOUBLE PRECISION,PHYALL_0)) as [Quantity Available]
2016-09-15 10:20:13 0032 FROM CHARM.ITMMVT , CHARM.ITMMASTER
2016-09-15 10:20:13 0033 WHERE STOFCY_0 = 'MCFI'
2016-09-15 10:20:13 0034 AND CHARM.ITMMVT.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')
2016-09-15 10:20:13 0035 AND CHARM.ITMMVT.ITMREF_0 = CHARM.ITMMASTER.ITMREF_0
2016-09-15 10:20:13 8 fields found: Item Reference, Item Description, Company, Total Stock, Allocated Stock, Average Cost, Quantity on Order, Quantity Available,
2016-09-15 10:20:13 5 lines fetched
2016-09-15 10:20:13 0042 SELECT CHARM.PORDER.POHNUM_0 as PO, CHARM.PORDER.POHFCY_0 as Company1,
2016-09-15 10:20:13 0043 convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103) as [Order Date1], CHARM.PORDER.BPSNUM_0 as [Supplier Code1],
2016-09-15 10:20:13 0044 BPRNAM_0 as [Supplier Name1],
2016-09-15 10:20:13 0045
2016-09-15 10:20:13 0046 case
2016-09-15 10:20:13 0047 when CHARM.PORDER.ZETADAT_0 < '1900/01/01' then
2016-09-15 10:20:13 0048 convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103)
2016-09-15 10:20:13 0049 ELSE
2016-09-15 10:20:13 0050 convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103)
2016-09-15 10:20:13 0051 END AS ETA1,
2016-09-15 10:20:13 0052
2016-09-15 10:20:13 0053 --convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) as ETA,
2016-09-15 10:20:13 0054 CASE
2016-09-15 10:20:13 0055 WHEN CHARM.PORDER.RCPFLG_0 = '1' THEN 'NOT YET RECEIVED'
2016-09-15 10:20:13 0056 WHEN CHARM.PORDER.RCPFLG_0 = '2' THEN 'PARTLY RECEIVED'
2016-09-15 10:20:13 0057 WHEN CHARM.PORDER.RCPFLG_0 = '3' THEN 'FULLY RECEIVED'
2016-09-15 10:20:13 0058 ELSE NULL
2016-09-15 10:20:13 0059 END AS 'Status1',
2016-09-15 10:20:13 0060 CUR_0 as Currency1,
2016-09-15 10:20:13 0061 --CSORS_0,
2016-09-15 10:20:13 0062 CHGCOE_0 as [Exchange Rate1],
2016-09-15 10:20:13 0063 CHARM.PORDERQ.ITMREF_0 as [Order Item Reference1],
2016-09-15 10:20:13 0064 convert(DOUBLE PRECISION,CHARM.PORDERQ.QTYPUU_0) as [Purchase Quantity1],
2016-09-15 10:20:13 0065 convert(DOUBLE PRECISION,CHARM.PORDERQ.RCPQTYPUU_0) as [Receipt Quantity1],
2016-09-15 10:20:13 0066 convert(DOUBLE PRECISION,CHARM.PORDERQ.LINAMT_0) as [Line Amount1],
2016-09-15 10:20:13 0067 CHARM.PORDER.CLEFLG_0 as CloseFlag,ITMDES1_0 as StockDesc1
2016-09-15 10:20:13 0068 FROM CHARM.PORDER, CHARM.PORDERQ, CHARM.ITMMASTER
2016-09-15 10:20:13 0069 WHERE CHARM.PORDER.POHNUM_0 = CHARM.PORDERQ.POHNUM_0
2016-09-15 10:20:13 0070 AND CHARM.PORDER.POHFCY_0 ='MCFI'
2016-09-15 10:20:13 0071 and CHARM.PORDER.CLEFLG_0 = 1
2016-09-15 10:20:13 0072 AND CHARM.ITMMASTER.ITMREF_0 = CHARM.PORDERQ.ITMREF_0
2016-09-15 10:20:13 0073 AND CHARM.PORDERQ.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')
2016-09-15 10:20:13 0074 order by convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) desc
2016-09-15 10:20:13 0075
2016-09-15 10:20:13 15 fields found: PO, Company1, Order Date1, Supplier Code1, Supplier Name1, ETA1, Status1, Currency1, Exchange Rate1, Order Item Reference1, Purchase Quantity1, Receipt Quantity1, Line Amount1, CloseFlag, StockDesc1,
2016-09-15 10:20:13 18 lines fetched
2016-09-15 10:20:13 0077 SELECT CHARM.PORDER.POHNUM_0 as [Purchase Order],
2016-09-15 10:20:13 0078 CHARM.PORDER.POHFCY_0 as Company,
2016-09-15 10:20:13 0079 convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103) as [Order Date],
2016-09-15 10:20:13 0080 CHARM.PORDER.BPSNUM_0 as [Supplier Code],
2016-09-15 10:20:13 0081 BPRNAM_0 as [Supplier Name],
2016-09-15 10:20:13 0082
2016-09-15 10:20:13 0083 case
2016-09-15 10:20:13 0084 when CHARM.PORDER.ZETADAT_0 < '1900/01/01' then
2016-09-15 10:20:13 0085 convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103)
2016-09-15 10:20:13 0086 ELSE
2016-09-15 10:20:13 0087 convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103)
2016-09-15 10:20:13 0088 END AS ETA,
2016-09-15 10:20:13 0089
2016-09-15 10:20:13 0090 --convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) as ETA,
2016-09-15 10:20:13 0091 CASE
2016-09-15 10:20:13 0092 WHEN CHARM.PORDER.RCPFLG_0 = '1' THEN 'NOT YET RECEIVED'
2016-09-15 10:20:13 0093 WHEN CHARM.PORDER.RCPFLG_0 = '2' THEN 'PARTLY RECEIVED'
2016-09-15 10:20:13 0094 WHEN CHARM.PORDER.RCPFLG_0 = '3' THEN 'FULLY RECEIVED'
2016-09-15 10:20:13 0095 ELSE NULL
2016-09-15 10:20:13 0096 END AS 'Status',
2016-09-15 10:20:13 0097 CHARM.PORDER.CUR_0 as Currency,
2016-09-15 10:20:13 0098 CHGCOE_0 as [Exchange Rate],
2016-09-15 10:20:13 0099 CHARM.PORDERQ.ITMREF_0 as [Order Item Reference],
2016-09-15 10:20:13 0100 convert(DOUBLE PRECISION,CHARM.PORDERQ.QTYPUU_0) as [Purchase Quantity],
2016-09-15 10:20:13 0101 convert(DOUBLE PRECISION,CHARM.PORDERQ.RCPQTYPUU_0) as [Receipt Quantity],
2016-09-15 10:20:13 0102 convert(DOUBLE PRECISION,CHARM.PORDERQ.LINAMT_0) as [Line Amount],
2016-09-15 10:20:13 0103 CHARM.PORDER.CLEFLG_0,ITMDES1_0 as StockDesc,
2016-09-15 10:20:13 0104 CHARM.PORDER.EECICT_0 as Incoterm,
2016-09-15 10:20:13 0105 BPSUPPLIER.ACCCOD_0 as Type,
2016-09-15 10:20:13 0106 CASE
2016-09-15 10:20:13 0107 WHEN BPSUPPLIER.ACCCOD_0 = 'SLNG' then
2016-09-15 10:20:13 0108 'Supplier Local Non Group'
2016-09-15 10:20:13 0109 WHEN BPSUPPLIER.ACCCOD_0 = 'SLGP' THEN
2016-09-15 10:20:13 0110 'Supplier Local Group'
2016-09-15 10:20:13 0111 WHEN BPSUPPLIER.ACCCOD_0 = 'SFGP' THEN
2016-09-15 10:20:13 0112 'Supplier Foreign Group'
2016-09-15 10:20:13 0113 WHEN BPSUPPLIER.ACCCOD_0 = 'SFNG' THEN
2016-09-15 10:20:13 0114 'Supplier Foreign Non Group'
2016-09-15 10:20:13 0115
2016-09-15 10:20:13 0116 END AS Foreign_Local,
2016-09-15 10:20:13 0117
2016-09-15 10:20:13 0118 CHARM.PORDERQ.STU_0 as ORD_UOM
2016-09-15 10:20:13 0119
2016-09-15 10:20:13 0120 FROM CHARM.PORDER, CHARM.PORDERQ, CHARM.ITMMASTER,CHARM.BPSUPPLIER BPSUPPLIER
2016-09-15 10:20:13 0121 WHERE CHARM.PORDER.POHNUM_0 = CHARM.PORDERQ.POHNUM_0
2016-09-15 10:20:13 0122 --AND CHARM.PORDER.POHFCY_0 ='MCFI'
2016-09-15 10:20:13 0123 AND CHARM.ITMMASTER.ITMREF_0 = CHARM.PORDERQ.ITMREF_0
2016-09-15 10:20:13 0124 --AND CHARM.PORDERQ.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')
2016-09-15 10:20:13 0125 AND BPSUPPLIER.BPSNUM_0 = CHARM.PORDER.BPSNUM_0
2016-09-15 10:20:13 0126 order by convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) desc
2016-09-15 10:20:14 19 fields found: Purchase Order, Company, Order Date, Supplier Code, Supplier Name, ETA, Status, Currency, Exchange Rate, Order Item Reference, Purchase Quantity, Receipt Quantity, Line Amount, CLEFLG_0, StockDesc, Incoterm, Type, Foreign_Local, ORD_UOM,
2016-09-15 10:20:14 12,120 lines fetched
2016-09-15 10:20:14 0130 SELECT MFGHEAD.MFGNUM_0 as [Works Order], MFGHEAD.ROUNUM_0 as[Finished Good Code],
2016-09-15 10:20:14 0131 convert(varchar(10),MFGHEAD.STRDAT_0, 103) as [Start Date],
2016-09-15 10:20:14 0132 YEAR(MFGHEAD.STRDAT_0) as [WIP Yearly],
2016-09-15 10:20:14 0133 --QuarterName(MFGHEAD.STRDAT_0) as [WIP Quarter],
2016-09-15 10:20:14 0134 left(datename(month, STRDAT_0 ),3) as [WIP Monthly],
2016-09-15 10:20:14 0135 Day(MFGHEAD.STRDAT_0)as [WIP Day],
2016-09-15 10:20:14 0136 MFGHEAD.ROUALT_0 as [Route Code] ,
2016-09-15 10:20:14 0137 CASE
2016-09-15 10:20:14 0138 WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)
2016-09-15 10:20:14 0139 WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg
2016-09-15 10:20:14 0140 ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)
2016-09-15 10:20:14 0141 END AS [Expected Qty],
2016-09-15 10:20:14 0142 --convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0) * 1000 as [Expected Qty],
2016-09-15 10:20:14 0143 MFGHEAD.STU_0 as UOM,
2016-09-15 10:20:14 0144 WIPCOST.ITMREF_0 as [WIP Item Reference],
2016-09-15 10:20:14 0145 convert(DOUBLE PRECISION,WIPCOST.QTY_0) as [BOM QTY], WIPCOST.WIPSEQ_0 as [Sequence],
2016-09-15 10:20:14 0146 --convert(DOUBLE PRECISION,WIPCOST.QTYACT_0) as [Actual Qty],
2016-09-15 10:20:14 0147
2016-09-15 10:20:14 0148 CASE
2016-09-15 10:20:14 0149 WHEN WIPCOST.STU_0 = 'T' THEN convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000)
2016-09-15 10:20:14 0150 WHEN WIPCOST.STU_0 = 'L' THEN convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15) --1.15kg
2016-09-15 10:20:14 0151 ELSE convert(DOUBLE PRECISION,WIPCOST.QTYACT_0)
2016-09-15 10:20:14 0152 END AS [Actual Qty],
2016-09-15 10:20:14 0153
2016-09-15 10:20:14 0154 convert(DOUBLE PRECISION,WIPCOST.REJQTY_0) as [Rejected Qty],
2016-09-15 10:20:14 0155 convert(DOUBLE PRECISION,WIPCOST.UNTCST_0) as [Unit Cost],
2016-09-15 10:20:14 0156 convert(DOUBLE PRECISION,WIPCOST.AMOUNT_0) as [Total Cost],
2016-09-15 10:20:14 0157 WIPCOST.MATGRP_0 as [MAT Group],
2016-09-15 10:20:14 0158 WIPCOST.OVENAT_0 as [Overhead Code],
2016-09-15 10:20:14 0159
2016-09-15 10:20:14 0160 CASE
2016-09-15 10:20:14 0161 WHEN WIPCOST.STU_0 = 'T' THEN 'KG'
2016-09-15 10:20:14 0162 WHEN WIPCOST.STU_0 = 'L' THEN 'KG'
2016-09-15 10:20:14 0163
2016-09-15 10:20:14 0164 ELSE WIPCOST.STU_0
2016-09-15 10:20:14 0165 END AS [UOM Raw Mat],
2016-09-15 10:20:14 0166
2016-09-15 10:20:14 0167 --WIPCOST.STU_0 as [UOM Raw Mat],
2016-09-15 10:20:14 0168 MFGHEAD.MFGFCY_0 as [Site Code], MFGHEAD.MFGSTA_0 as [Status],
2016-09-15 10:20:14 0169 CHARM.ITMMASTER.TSICOD_0 as Category0,CHARM.ITMMASTER.TSICOD_1 as Category1
2016-09-15 10:20:14 0170 FROM CHARM.ITMMASTER , x3data.CHARM.MFGHEAD MFGHEAD
2016-09-15 10:20:14 0171 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0
2016-09-15 10:20:14 0172 WHERE WIPCOST.MATGRP_0=1
2016-09-15 10:20:14 0173 AND CHARM.ITMMASTER.ITMREF_0 = MFGHEAD.ROUNUM_0
2016-09-15 10:20:14 0174 AND MFGHEAD.MFGFCY_0=N'MCFI'
2016-09-15 10:20:14 0175 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'
2016-09-15 10:20:14 0176
2016-09-15 10:20:14 0177 and MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0
2016-09-15 10:20:14 0178 ORDER BY MFGHEAD.MFGNUM_0, WIPCOST.WIPSEQ_0
2016-09-15 10:20:14 0179 '
2016-09-15 10:20:14 0180
2016-09-15 10:20:15 23 fields found: Works Order, Finished Good Code, Start Date, WIP Yearly, WIP Monthly, WIP Day, Route Code, Expected Qty, UOM, WIP Item Reference, BOM QTY, Sequence, Actual Qty, Rejected Qty, Unit Cost, Total Cost, MAT Group, Overhead Code, UOM Raw Mat, Site Code, Status, Category0, Category1,
2016-09-15 10:20:15 5,994 lines fetched
2016-09-15 10:20:15 0191 select MFGHEAD.MFGNUM_0 as [RMUE Works Order] ,
2016-09-15 10:20:15 0192 YEAR(MFGHEAD.STRDAT_0) as [RMUE WIP Yearly],
2016-09-15 10:20:15 0193 convert(varchar(10),MFGHEAD.STRDAT_0, 103) as [RMUE Start Date],
2016-09-15 10:20:15 0194 Month(STRDAT_0) as [RMUE WIP Monthly],
2016-09-15 10:20:15 0195
2016-09-15 10:20:15 0196 CASE WHEN MFGHEAD.ROUNUM_0 = WIPCOST.ITMREF_0 then
2016-09-15 10:20:15 0197
2016-09-15 10:20:15 0198 CASE
2016-09-15 10:20:15 0199 WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)
2016-09-15 10:20:15 0200 WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg
2016-09-15 10:20:15 0201 ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)
2016-09-15 10:20:15 0202 END
2016-09-15 10:20:15 0203 else 0
2016-09-15 10:20:15 0204 END AS [RMUE Expected Qty],
2016-09-15 10:20:15 0205 MFGHEAD.STU_0 as RMUE_UOM,
2016-09-15 10:20:15 0206 CASE WHEN MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0 then
2016-09-15 10:20:15 0207
2016-09-15 10:20:15 0208 CASE
2016-09-15 10:20:15 0209 WHEN WIPCOST.STU_0 = 'T' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000 ))
2016-09-15 10:20:15 0210 WHEN WIPCOST.STU_0 = 'L' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15)) --1.15kg
2016-09-15 10:20:15 0211 ELSE sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0))
2016-09-15 10:20:15 0212 END
2016-09-15 10:20:15 0213 else 0
2016-09-15 10:20:15 0214 END AS [RMUE Actual Qty],
2016-09-15 10:20:15 0215
2016-09-15 10:20:15 0216 CASE
2016-09-15 10:20:15 0217 WHEN WIPCOST.STU_0 = 'T' THEN 'KG'
2016-09-15 10:20:15 0218 WHEN WIPCOST.STU_0 = 'L' THEN 'KG'
2016-09-15 10:20:15 0219 ELSE WIPCOST.STU_0
2016-09-15 10:20:15 0220 END AS [RMUE UOM Raw Mat]
2016-09-15 10:20:15 0221
2016-09-15 10:20:15 0222
2016-09-15 10:20:15 0223 FROM x3data.CHARM.MFGHEAD MFGHEAD
2016-09-15 10:20:15 0224 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0
2016-09-15 10:20:15 0225 WHERE WIPCOST.MATGRP_0=1
2016-09-15 10:20:15 0226 AND MFGHEAD.MFGFCY_0=N'MCFI'
2016-09-15 10:20:15 0227 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'
2016-09-15 10:20:15 0228 --AND MFGHEAD.MFGNUM_0 ='MCFI1501MFG00000004'
2016-09-15 10:20:15 0229 group by MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0,MFGHEAD.MFGNUM_0,MFGHEAD.STRDAT_0,
2016-09-15 10:20:15 0230 MFGHEAD.STU_0,MFGHEAD.EXTQTY_0,WIPCOST.STU_0
2016-09-15 10:20:15 0231 order by MFGHEAD.MFGNUM_0
2016-09-15 10:20:16 8 fields found: RMUE Works Order, RMUE WIP Yearly, RMUE Start Date, RMUE WIP Monthly, RMUE Expected Qty, RMUE_UOM, RMUE Actual Qty, RMUE UOM Raw Mat,
2016-09-15 10:20:16 7,721 lines fetched
2016-09-15 10:20:16 0234 TranDet:
2016-09-15 10:20:16 0235
2016-09-15 10:20:16 0236 select MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0 as [RMUE2 WIP Item Reference],MFGHEAD.MFGNUM_0 as [RMUE2 Works Order] ,
2016-09-15 10:20:16 0237 YEAR(MFGHEAD.STRDAT_0) as [RMUE2 WIP Yearly],
2016-09-15 10:20:16 0238 convert(varchar(10),MFGHEAD.STRDAT_0, 103) as [RMUE2 Start Date],
2016-09-15 10:20:16 0239 left(datename(month, STRDAT_0 ),3) as [RMUE2 WIP Monthly],
2016-09-15 10:20:16 0240
2016-09-15 10:20:16 0241 CASE WHEN MFGHEAD.ROUNUM_0 = WIPCOST.ITMREF_0 then
2016-09-15 10:20:16 0242
2016-09-15 10:20:16 0243 CASE
2016-09-15 10:20:16 0244 WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)
2016-09-15 10:20:16 0245 WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg
2016-09-15 10:20:16 0246 ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)
2016-09-15 10:20:16 0247 END
2016-09-15 10:20:16 0248 else 0
2016-09-15 10:20:16 0249 END AS [RMUE2 Expected Qty],
2016-09-15 10:20:16 0250 MFGHEAD.STU_0 as RMUE2_UOM,
2016-09-15 10:20:16 0251 CASE WHEN MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0 then
2016-09-15 10:20:16 0252
2016-09-15 10:20:16 0253 CASE
2016-09-15 10:20:16 0254 WHEN WIPCOST.STU_0 = 'T' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000 ))
2016-09-15 10:20:16 0255 WHEN WIPCOST.STU_0 = 'L' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15)) --1.15kg
2016-09-15 10:20:16 0256 ELSE sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0))
2016-09-15 10:20:16 0257 END
2016-09-15 10:20:16 0258 else 0
2016-09-15 10:20:16 0259 END AS [RMUE2 Actual Qty],
2016-09-15 10:20:16 0260 CASE
2016-09-15 10:20:16 0261 WHEN WIPCOST.STU_0 = 'T' THEN 'KG'
2016-09-15 10:20:16 0262 WHEN WIPCOST.STU_0 = 'L' THEN 'KG'
2016-09-15 10:20:16 0263 ELSE WIPCOST.STU_0
2016-09-15 10:20:16 0264 END AS [RMUE2 UOM Raw Mat]
2016-09-15 10:20:16 0265
2016-09-15 10:20:16 0266
2016-09-15 10:20:16 0267 FROM x3data.CHARM.MFGHEAD MFGHEAD
2016-09-15 10:20:16 0268 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0
2016-09-15 10:20:16 0269 WHERE WIPCOST.MATGRP_0=1
2016-09-15 10:20:16 0270 AND MFGHEAD.MFGFCY_0=N'MCFI'
2016-09-15 10:20:16 0271 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'
2016-09-15 10:20:16 0272 --AND MFGHEAD.MFGNUM_0 ='MCFI1501MFG00000004'
2016-09-15 10:20:16 0273 group by MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0,MFGHEAD.MFGNUM_0,MFGHEAD.STRDAT_0,
2016-09-15 10:20:16 0274 MFGHEAD.STU_0,MFGHEAD.EXTQTY_0,WIPCOST.STU_0
2016-09-15 10:20:16 0275
2016-09-15 10:20:16 10 fields found: ROUNUM_0, RMUE2 WIP Item Reference, RMUE2 Works Order, RMUE2 WIP Yearly, RMUE2 Start Date, RMUE2 WIP Monthly, RMUE2 Expected Qty, RMUE2_UOM, RMUE2 Actual Qty, RMUE2 UOM Raw Mat,
2016-09-15 10:20:16 7,721 lines fetched
2016-09-15 10:20:16 0276 Final:
2016-09-15 10:20:16 0277 Load
2016-09-15 10:20:16 0278 [RMUE2 Works Order] as WIPWO,
2016-09-15 10:20:16 0279 Sum([RMUE2 Expected Qty]) AS [RMUE2 Expected Qty2],
2016-09-15 10:20:16 0280 Sum([RMUE2 Actual Qty]) AS [RMUE2 Actual Qty2],
2016-09-15 10:20:16 0281 (1-Sum([RMUE2 Actual Qty])/Sum([RMUE2 Expected Qty])) * 100 as RMUEE
2016-09-15 10:20:16 0282
2016-09-15 10:20:16 0283 Resident TranDet Group By [RMUE2 Works Order]
2016-09-15 10:20:16 4 fields found: WIPWO, RMUE2 Expected Qty2, RMUE2 Actual Qty2, RMUEE,
2016-09-15 10:20:16 1,848 lines fetched
2016-09-15 10:20:16 0286 STOJOU:
2016-09-15 10:20:16 0287 SELECT CHARM.STOJOU.ITMREF_0 as [STOJOU Item Reference],
2016-09-15 10:20:16 0288 ITMDES1_0 as [STOJOU Item Description],
2016-09-15 10:20:16 0289 STOFCY_0 as STOJOUCompan,
2016-09-15 10:20:16 0290 --convert(varchar(10),IPTDAT_0, 103) as [TransactionDate],
2016-09-15 10:20:16 0291 IPTDAT_0 as TransactionDate,
2016-09-15 10:20:16 0292 --convert(varchar(4),year(IPTDAT_0)) as STOJOUYEAR,
2016-09-15 10:20:16 0293 sum(convert(DOUBLE PRECISION,QTYSTU_0)) as Quantit,
2016-09-15 10:20:16 0294 sum(convert(DOUBLE PRECISION,VARVAL_0)) as Valu
2016-09-15 10:20:16 0295 FROM CHARM.STOJOU, CHARM.ITMMASTER
2016-09-15 10:20:16 0296 WHERE STOFCY_0 = 'MCFI'
2016-09-15 10:20:16 0297
2016-09-15 10:20:16 0298
2016-09-15 10:20:16 0299 AND CHARM.STOJOU.ITMREF_0 = CHARM.ITMMASTER.ITMREF_0
2016-09-15 10:20:16 0300 --and IPTDAT_0<= dateadd(dd,-1,dateadd(mm,datediff(mm,0,IPTDAT_0)+1,0))
2016-09-15 10:20:16 0301 GROUP BY CHARM.STOJOU.ITMREF_0,ITMDES1_0,STOFCY_0
2016-09-15 10:20:16 0302 ,IPTDAT_0
2016-09-15 10:20:16 0303 order by 4
2016-09-15 10:20:16 0304
2016-09-15 10:20:17 6 fields found: STOJOU Item Reference, STOJOU Item Description, STOJOUCompan, TransactionDate, Quantit, Valu,
2016-09-15 10:20:17 9,483 lines fetched
2016-09-15 10:20:17 0307 load
2016-09-15 10:20:17 0308 TransactionDate as _StockDate,
2016-09-15 10:20:17 0309 date(TransactionDate) as StockDate,
2016-09-15 10:20:17 0310 date([TransactionDate],'MMM YYYY') as StockDateCurMonth,
2016-09-15 10:20:17 0311 monthname(TransactionDate) as stkCurrentMonth,
2016-09-15 10:20:17 0312 QuarterName(TransactionDate) as QTR_StockDate,
2016-09-15 10:20:17 0313 num(month(TransactionDate)) as NumMthSCDate,
2016-09-15 10:20:17 0314 [STOJOU Item Reference] as stkRef,
2016-09-15 10:20:17 0315 [STOJOU Item Description] as stkDescc,
2016-09-15 10:20:17 0316 STOJOUCompan as STOJOUCompany,
2016-09-15 10:20:17 0317 Quantit as Quantity,
2016-09-15 10:20:17 0318 Valu as Value
2016-09-15 10:20:17 0319
2016-09-15 10:20:17 0320 Resident STOJOU
2016-09-15 10:20:17 11 fields found: _StockDate, StockDate, StockDateCurMonth, stkCurrentMonth, QTR_StockDate, NumMthSCDate, stkRef, stkDescc, STOJOUCompany, Quantity, Value,
2016-09-15 10:20:17 9,483 lines fetched
2016-09-15 10:20:17 0322 *** CONNECT TO ***
2016-09-15 10:20:17 0324 SELECT count(*) as No,SRETURN.STOFCY_0 as Company,
2016-09-15 10:20:17 0325 SRETURND.SRHNUM_0 ,
2016-09-15 10:20:17 0326 SRETURND.SRDLIN_0 ,
2016-09-15 10:20:17 0327 SRETURND.SDHNUM_0 ,
2016-09-15 10:20:17 0328 BPDNAM_0 as Customer,ITMDES_0 as Item,
2016-09-15 10:20:17 0329 SRETURN.RTNDAT_0 as DateReturned,
2016-09-15 10:20:17 0330 CASE WHEN
2016-09-15 10:20:17 0331 SRETURND.RTNREN_0 <> '' then
2016-09-15 10:20:17 0332 (
2016-09-15 10:20:17 0333 SELECT distinct ATEXTRA.TEXTE_0
2016-09-15 10:20:17 0334 FROM x3data.CHARM.ATEXTRA ATEXTRA
2016-09-15 10:20:17 0335 WHERE SRETURND.RTNREN_0 = ATEXTRA.IDENT2_0
2016-09-15 10:20:17 0336 AND ATEXTRA.ZONE_0='LNGDES' AND ATEXTRA.LANGUE_0='ENG'
2016-09-15 10:20:17 0337 AND ATEXTRA.IDENT1_0 = '7' AND ATEXTRA.IDENT2_0 <>''
2016-09-15 10:20:17 0338 )
2016-09-15 10:20:17 0339 else 'NoReason'
2016-09-15 10:20:17 0340 END AS Reason
2016-09-15 10:20:17 0341 FROM CHARM.SRETURND SRETURND, CHARM.SRETURN SRETURN
2016-09-15 10:20:17 0342 WHERE SRETURND.SRHNUM_0 = SRETURN.SRHNUM_0
2016-09-15 10:20:17 0343 AND SRETURND.CPY_0 = 'MCF'
2016-09-15 10:20:17 0344 --and SRETURN.RTNDAT_0 = '2015/10/28'
2016-09-15 10:20:17 0345 group by SRETURN.STOFCY_0,SRETURND.SRHNUM_0,SRETURND.SRDLIN_0,SRETURND.SDHNUM_0,
2016-09-15 10:20:17 0346 SRETURN.BPDNAM_0,SRETURND.ITMDES_0,SRETURN.RTNDAT_0,SRETURND.RTNREN_0
2016-09-15 10:20:17 0347 order by SRETURN.RTNDAT_0 desc
2016-09-15 10:20:18 9 fields found: No, Company, SRHNUM_0, SRDLIN_0, SDHNUM_0, Customer, Item, DateReturned, Reason,
2016-09-15 10:20:18 367 lines fetched
2016-09-15 10:20:18 0349 LOAD
2016-09-15 10:20:18 0350 COMPANY,
2016-09-15 10:20:18 0351 "ITEM CODE",
2016-09-15 10:20:18 0352 DESCRIPTION,
2016-09-15 10:20:18 0353 BRAND,
2016-09-15 10:20:18 0354 "TYPE",
2016-09-15 10:20:18 0355 DES_0,
2016-09-15 10:20:18 0356 LOP,
2016-09-15 10:20:18 0357 DES_01,
2016-09-15 10:20:18 0358 TSICOD_3,
2016-09-15 10:20:18 0359 DES_02,
2016-09-15 10:20:18 0360 DIM,
2016-09-15 10:20:18 0361 LOCATION,
2016-09-15 10:20:18 0362 STA_0,
2016-09-15 10:20:18 0363 QTY,
2016-09-15 10:20:18 0364 "UNIT COST",
2016-09-15 10:20:18 0365 "TOTAL VALUE",
2016-09-15 10:20:18 0366 "LAST PURCH DATE",
2016-09-15 10:20:18 0367 CURRENT,
2016-09-15 10:20:18 0368 "1MONTH",
2016-09-15 10:20:18 0369 "2MONTH",
2016-09-15 10:20:18 0370 "3MONTH",
2016-09-15 10:20:18 0371 "4MONTH",
2016-09-15 10:20:18 0372 "5MONTH",
2016-09-15 10:20:18 0373 "6MONTH",
2016-09-15 10:20:18 0374 "7MONTH",
2016-09-15 10:20:18 0375 "8MONTH",
2016-09-15 10:20:18 0376 "9MONTH",
2016-09-15 10:20:18 0377 "10MONTH",
2016-09-15 10:20:18 0378 "11MONTH",
2016-09-15 10:20:18 0379 OVER1YR
2016-09-15 10:20:18 0380 FROM [lib://x/MCFISTOCKAGE.xls]
2016-09-15 10:20:18 0381 (biff, embedded labels, table is Sheet1$)
2016-09-15 10:20:18 Error: Cannot open file: 'lib://x/MCFISTOCKAGE.xls'
2016-09-15 10:20:18 Execution Failed
2016-09-15 10:20:18 Execution finished.
Hi, could you check if you have your.xls file on that path? (lib://x/MCFISTOCKAGE.xls)
Hi,
Either Excel file is missing or wrong connection is used.
Regards,
Shraddha
Hello, I have my excel sheet at path c:/x/MCFISTOCKAGE.xls and in QMC dataconnection the path is the same.